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…)

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…)

Why OCI is the Perfect Platform for Oracle EBS

By | Blog, Oracle
Oracle E-Business Suite (EBS) is a fantastic compilation of tools for consolidating your enterprise functionality, management, and analytics. But what platform should you use to make the most out of your Oracle EBS? On-prem or third-party cloud infrastructure may not be making the most out of your Oracle applications. With Oracle Cloud Infrastructure (OCI) you will enjoy the fastest, most efficient, most optimized platform to get the maximum benefit from Oracle EBS. What is Oracle EBS? This suite of applications handles everything you need to run your enterprise level business functionality, including customer relationship management (CRM), human resources management (HRM), enterprise resource planning (ERP), and supply-chain management (SCM). The EBS collection is one of Oracle’s major product offerings with robust capabilities to consolidate your business management under one roof. With tools covering logistics, financials, order management, marketing, HR, and many more, Oracle EBS is an industry leading, comprehensive solution. Is On-Prem a Problem? If you are a current or future owner of Oracle EBS you may be wondering what infrastructure will best compliment this powerhouse of tools. More and more companies are moving away from in-house data centers because of the high cost of implementation and maintenance. These data centers (more…)
Oracle Gold Partner

What’s New in Oracle’s Database 19c

By | Oracle
Oracle is one of the leading providers of database services with decades of experience at the top of the pack. Their new product releases are always exciting to watch, improving upon their legacy of client-focused products and services. Last year they released database 18c, the first of a new annual release schedule, that featured the revolutionary Autonomous Cloud database along with Multitenant Architecture, In-Memory Columnar Architecture, and Native Database Sharding. This year’s database 19c continues to build on the foundations set in previous years with a focus on stability and efficiency. If you are thinking about upgrading or migrating to Oracle’s database 19c, here are a few special features to expect in this newest version. New Features in 19c This database version comes with some exciting enhancements to make your job faster and easier. While the main focus of this development cycle has been on stability, there are a few new features focused on automating and optimizing for the client. Let’s look at a few of these enhancements. Automatic Indexing – Indexing items takes time and can mean a lot of busywork for your IT team. With Automatic Indexing, Oracle’s 19c uses machine learning algorithms to identify items, map and (more…)