DataOps – Developing Processes for Analytics and Data Management

By | Blog, Uncategorized
Big data and analytics mean big things for industries across all sectors. As data continues to grow, so do the applications. The newest challenge is streamlining the analytics process to improve efficiency and create actionable insights in a timely manner. That is where DataOps comes in. This newest development utilizes concepts learned from DevOps practices to simplify and streamline the data pipeline and analytics process. Let’s take a look at how this works. The Science of Analytics The analysis of big data is a complicated process of pattern recognition using statistical tools and algorithms. Your data scientists, engineers, and analysts may all play some part in this role. Managing the analytics process from an operational standpoint, as well as a statistical standpoint, can be time-consuming. If you want to have real, useable insights from your data it is imperative to validate both input and output data. It’s taxing to your analysts and means longer lead times on identifying key insights. But these steps are there for a reason, right? You can’t skip vital processes just because they’re lengthy. But you can innovate those processes and improve their efficiency. The development world has been working on this for a while with (more…)
Data Migration Support

Containers are In – Azure Can Help

By | Azure, Blog, Uncategorized
Application development and deployment has come a long way in recent years. The introduction of containers opens the door for more lightweight, portable, scalable development. Add to that the capabilities of Kubernetes clusters and you get a new level of efficiency when managing application development, testing, and deployment. If your team is actively using Linux containers and Kubernetes clusters, it’s important to make sure your database products are supporting your efforts. Microsoft Azure has been helping its clients utilize and manage containers with Azure Container Service (ACS), now taking it a step further with the development of Azure Kubernetes Service (AKS). Why Containers? Containers have tons of benefits for API development. They are basically self-contained instances that run natively on your OS, maintaining configuration settings across multiple platforms. Imagine your developers working on an API on their laptop, which has one set of configurations, and then sending to another developer for review. Will the other environment behave exactly the same way? Impossible to know. With virtualization, you can eliminate these issues, but this is taxing on your system. Containers are lightweight so that you can run multiple containers on your machine without experiencing performance issues. Remember, these are running natively, (more…)

Simplify Data Management with Azure Data Studio

By | Azure
Azure is well known as one of the industry’s leading cloud providers, offering exceptional security, business management, and analysis tools in affordable packages. In this article we take a look at one of the best tools for editors and DBAs, the Azure Data Studio. This resource, formerly known as SQL Operations Studio, is a platform for building and editing your SQL queries with useful tools and an intuitive UI. If you are looking for a tool to seamlessly integrate your query editing with your database management, look no further than Azure Data Studio. This cross-platform tool makes managing your database, objects, and queries easier than ever. Initial Release and Rebrand – This product was released for public preview nearly 2 years under the name of SQL Operations Studio, and last fall was released for general availability (GA) under the new name, Azure Data Studio. Some customers questioned whether the Azure heading would pose problems for on-prem SQL infrastructures. The answer is no. Microsoft is dedicated to supporting all instances of SQL Server and related database products, including on-premises and hybrid infrastructures. This means that whether you are hosting on site SQL Servers or utilizing the Azure Cloud infrastructure, you can (more…)

Migrating from SQL Server to Azure

By | Azure, Database Technology Trends, SQL Server
Extended support for SQL Server 2008 has ended, and there is no better time to consider a migration to Azure. Continuing to run business applications and workloads on an unsupported platform will open you up to unnecessary vulnerabilities and potential legal issues. The risk is just not worth it. If you have been holding out for fear of complicated processes, there’s good news, Microsoft is making it easier than ever to migrate to Azure and take advantage of the benefits of cloud computing, including scalable resources and always up-to-date security features. With a trusted database solutions partner, your migration can be quick and painless. Check out this guide for more information about migrating from SQL to Azure. Why Migrate – If you are on SQL Server 2008, the answer is clear. Migrating is a must to stay on top of your database health and security. Now you may be asking, why can’t I just upgrade to Server 2019? You absolutely can. But this time is a perfect opportunity to minimize the impact of a cloud migration to reap the benefits of hosting your workloads in a cloud or hybrid environment. Utilizing the Azure cloud allows for scalable database solutions and (more…)

Connecting Devices Securely With the Azure Sphere

By | Azure
Customer experience is rising in importance for businesses these days, and one of the primary factors that customers value is efficiency. As more and more devices become connected, creating the Internet of Things (IOT), companies and products are able to provide enhanced services that can significantly improve the customer experience. The benefits of connectivity are clear, as are the roadblocks. Until recently, security was one of the biggest obstacles to overcome. That’s all changing with Microsoft’s new end-to-end solution, the Azure Sphere. It’s about Connecting those MCUs Microcontrollers are all around us, in toasters, ovens, microwaves, cars, thermostats, remotes, etc. These consumer products use what are essentially dedicated mini-computers, CPUs designed with specific tasks to achieve. These MCUs can be connected to the internet to improve performance, adapt to our interactions, and enhance customer experience, but very few of these MCUs are currently connected. This is because connectivity creates vulnerability for the device. Security breaches by bad actors can have disastrous results, and many companies have been staying away from the risk. But Microsoft was determined to create an environment that would allow companies to securely reap the benefits of connectivity with peace of mind. The development of the Azure (more…)

Oracle 19C Available on Linux!

By | Oracle
If you are a fan of open source operating systems, you’re not alone. These robust systems are gaining popularity as the era of proprietary restriction putters to a close. These resources have a lot going for them, from high compatibility to high security and flexibility. Industry leading database providers are taking notice and incorporating Linux compatibility into their products. Now Oracle has announced the exciting news that their Oracle 19c database is available on Linux, one of the most well-known open source operating systems. This opens up an exciting host of possibilities and brings the Oracle database to a whole new client base. 19c Focus on The Client, Adds Linux to Boost Compatibility Oracle 19C is the newest release of the 12c database line, continuing to contribute to the continuous release schedule established in 2018. This release schedule means more flexibility and stability of the database created by eliminating the major and minor release pattern. This newest release features fewer new additions than last year’s 18c, but has many enhancements designed to continue improving the user’s experience and ease of use (for more on new features, check out our blog post What’s New in Oracle’s Database 19c)To that end, offering (more…)

What Can AI Do for You?

By | Blog
Artificial Intelligence and Machine learning algorithms are continually increasing in their sophistication and application. These programs are designed to utilize input to learn and evolve, rewriting themselves and building in their capabilities. When used for a specific task, AI and machine learning programs get better and faster as they go, learning and growing more familiar with the data set, trends, and patterns of their workload. This has exciting applications for businesses looking to speed up processing, analyze big data, and reduce workloads on human resources. From improved automation to customer outreach and security, here are 10 ways AI can help any business. 1. Automation – AI is great at taking over routine tasks and automating time-consuming workloads. From virtual automation, like Robotic Process Automation (RPA) to machining and manufacturing, AI can take over many tasks once relegated to the grunt work pile. Programs and machines run by AI don’t get tired, don’t get bored, and don’t make human errors. This makes them particularly valuable for handling dangerous or hazardous tasks in industry and manufacturing. 2. Forecasting – Knowing how much to produce comes down to accurate forecasting. That is, analyzing sales trends to see how much product you anticipate moving (more…)

The Rise of Edge Computing

By | Blog
In today’s age of big data and instant gratification, issues of speed and scalability are at the forefront of technology solutions. The development of cloud computing environments represented a major breakthrough in this effort, but these cloud servers are still a centralized solution, subject to the challenges therein. As the cloud becomes more and more saturated with data and processing needs, issues of latency and bottlenecking grow. The drive to mimic instantaneous transfer means even small instances of latency can create big problems. Edge computing is the next step in ensuring the most powerful and scalable processing capabilities and provides vital support to traditional cloud server banks. Edge Evolution Edge computing came about as an organic evolution of technological advancements and the benefits and drawbacks of cloud computing. The amount of data being used, stored, processed, and accessed at any given time is extraordinary. Many personal and company computing needs are now being accomplished on the cloud. But don’t think of the cloud as a decentralized nebulous network. Cloud processing still takes place in a centralized location. In this case, it is one of several server banks owned by the various cloud providers. When a cloud customer wants to perform (more…)

Oracle EBS Gets a Boost with New Features from Enterprise Command Center

By | Oracle
Oracle E-Business Suite (EBS) is a fantastic suite of applications to enable management of enterprise level operations. This comprehensive application suite does just that, providing clients with an end-to-end solution to accounting, HR, inventory and process management, and much more. With such a robust suite of tools, concerns about navigation and data visibility are always at the forefront. That is not an issue for Oracle EBS. With the addition of the Enterprise Command Center, this suite is more accessible than ever. Introduction of the Enterprise Command Center – In October last year, Oracle announced the release of the Enterprise Command Center (ECC) to improve reporting and navigation for their E-Business Suite. The ECC improves visibility and data navigation through tools and drill down dashboards that go to the transactional level. This represents the most comprehensive reporting tool to date, and significantly improves utilization of the application suite. Some of the best news about this release is that it comes without additional licensing fees. Anyone with an EBS license can begin using ECC free of charge. It is compatible with versions 12.2.4 and above. Additional Enhancements to ECC – As part of the ECC rollout plan, Oracle announced several enhancements due to (more…)

Why Consider Dobler Consulting for Your Custom Software Development

By | Custom Software
Custom software development projects are a close collaboration between the client and development team. Your development team will directly impact the success of your project, and your experience during the process.  Identifying the right development team for your project is about more than just finding knowledgeable coders. It involves finding the right combination of experience, knowledgebase, services, and personality. At Dobler Consulting, we handle comprehensive database management and technology services, and this puts us in a unique position to address custom software projects with a holistic understanding of the IT strategy. The result is more than just a development project. More Than Just Custom Software – Communication is a key aspect of the design process and requires bridging the gap between the business and tech languages. This is no easy feat, as most subject matter experts are proficient in one over the other. The resulting miscommunication can create challenges from the requirements phase all the way to implementation. Understanding the true goals of the software and how best to accomplish them from both a business and a software perspective means finding a team that can bridge those language barriers. At Dobler Consulting, we have built relationships with many companies through (more…)