Our Blog

The Dobler Consulting Blog

A Wealth of Information from the vault of Dobler Consulting

Database Consulting

What is Custom Software Development?

By | Custom Software
Software is an essential component of any business. Processes like supply chain management, operations, customer service, and administration are facilitated by software solutions. There are two main types of software, off-the-shelf and custom. If your software isn’t meeting your needs or you see room for process improvement or more efficiency, a custom solution might be just the thing you need. What is Custom Software? –  Typical mass-produced, or off-the-shelf, software products are created with a large audience in mind. These solutions are readily available and quick to implement, although you may sacrifice time trying to fit them into your . Since they are made to be widely accepted by a variety of businesses, these off-the-shelf software solutions won’t be seamlessly integrated into your . You will typically find your team making adjustments and concessions to work them into your processes, sacrificing efficiency. In contrast, custom software is created specifically for a unique client, application, or circumstance. These products are commissioned and then developed to your exact specifications by a team of custom software developers. The result is a product that does exactly what you need to do, exactly how you want it to be done, without any extraneous noise. (more…)

Is SQL PaaS Right for You?

By | Azure
With the arrival of the new year, you might be considering how SQL Server can better fit your company’s growth in 2019.  SQL Platform as a Service (PaaS) could be a viable option for managing essential database operations. With PaaS, your SQL Server workloads would run as a hosted service in the cloud with most database management functions maintained by the cloud service provider instead of your IT team. Top Reasons to Consider PaaS Operates completely within the cloud. PaaS provides developers with an environment to develop and deploy applications entirely within the cloud. This includes complex enterprise applications your company may need to solve business problems and simple cloud-based applications. Scaling is easy. You can pay-as-you-go. Service providers allow you to take of advanced development tools as you need them, giving you more value at an affordable rate. Your bottom line increases. You no longer need to purchase software licenses, application infrastructure, or development tools. Finally, your development team can have the opportunity to focus on managing the applications and services they create while the cloud service provider manages the rest. Decrease coding time. The development tools PaaS can provide include some pre-coded application components (i.e., security features, directory services, workflow, etc.) (more…)

Machine Learning, AI and Advanced Analytics

By | Database Technology Trends
Big data is big news across industry sectors. The digital age has given rise to information overload, and the most resourceful businesses are learning how to take advantage of that information. It takes a special type of skill to gain actionable insights from these massive amounts of data, and that is where advanced analytics comes in. With technologies like artificial intelligence (AI) and machine learning (ML), data-driven business insights are possible like never before. Here’s a breakdown of how these technologies really work. The Science of Advanced Analytics – Traditional analytics refers to more linear quantitative analysis, usually generated by business intelligence (BI) systems. These are examinations of performance drawn from a structured and pre-defined framework. They use existing historical data from a database or data warehouse. With advanced analytics, we are able to follow the data without a pre-determined scope. All you need is a starting point. For example, consider the question: what type of people buy yogurt in the mornings? With traditional analysis, you would be left skimming through sales data and designing reports to cross reference yogurt sales and time of day, but that only tells you how many people have performed this action, not what type (more…)

Understanding Blockchain, the Trending New Tool

By | Database Technology Trends
There’s been an increasing amount of buzz around blockchain technology lately, and people are more interested than ever before. “A new technology that functions as a distributed ledger within a decentralized network and promises greater security, lower transaction costs, etc.” is usually how it’s described. But what does all of this really mean? What is Blockchain? In its simplest form, Blockchain is a digital ledger (consider the general ledger your organization’s /accounting teams use) that stores information across a network of computers. It stores information in batches called “blocks,” that are linked together in a chronological fashion, similar to a chain of blocks. This information can be virtually anything, but try imagining it in terms of a financial transaction, since that’s probably the easiest to visualize. To illustrate, here’s what happens when you make a purchase: Imagine purchasing new software online from Microsoft (for illustrative purposes only). The block would store the date, time, and dollar amount of your purchase. It would also log information about who is making the transaction. For security purposes, your name would be recorded as a unique “digital signature,” more like a username instead of your actual name. Once your block has been verified and (more…)
Database Consulting

What are Data Clusters and What Can They do For You?

By | Azure, SQL Server
Learning to effectively manage large datasets is key to optimizing your data analytics. Using data clusters can help optimize your data management. It involves grouping data points with similar characteristics into the same cluster to speed up processing time and improve analysis. Consider starting an analysis project on customer spending habits by gender in different regions. Your time on the project would be maximized if you’re able to use statistical techniques to automatically organize the data into logical groups prior to analyzing. How do data clusters work? Data clustering allows you to partition large volumes of structured and /observations into logical groupings. One way it does this is by analyzing all of the data in the data warehouse and comparing each data point with clusters created. You rely upon the clustering algorithms to sort and cluster the data in a logical way. In a perfect world, all data points in the same group should be highly similar in nature, while data points in different groups should be dissimilar. There are several different models and algorithms that guide the clustering process. Here are a few: Hierarchical Method: This method creates separate successive clusters using specific criteria. Partitioning Method: This method (more…)

What’s New in Management Studio Version 17.6

By | SQL Server
Microsoft continues to make great strides in improving SQL Server Management Studio (SSMS). Version 17.6 comes with some impressive new features and bug fixes that enhance your user experience. Azure SQL Database Managed Instance Users If you’re using the newly developed Azure SQL Database Managed Instance, a new model of Azure SQL Database, you should definitely consider upgrading to SSMS v 17.6. One of the most notable changes is the added support for some of its most common management scenarios. After you complete the upgrade, you can expect a much more efficient support process if you encounter issues with the following: Databases – Creating, altering, backing up, and restoring databases are all fairly common tasks in database management, which makes their processes easy to support. Object Explorer – All technical issues that arise while using Object Explorer to manage objects in each SQL Server instance are eligible for support. SQL Linked Servers – You can relax when using Linked Servers to connect to other database instances on a remote server, same server, or an entirely different machine. The SQL Tools Team has you covered. SQL Agent Jobs – Your automated execution jobs/tasks usually consist of several steps. Any disruption can (more…)

Ron Hymer Chosen To Lead New, Data Intensive, Custom Software Development Division

By | Press Releases
BAY, FLA. JANUARY 21, 2019 Dobler Consulting is pleased to announce that Ron Hymer, a recognized thought–leader in custom software development, will be joining the Dobler team to lead their client-centric software development practice. Hymer brings to Dobler years of experience designing and implementing data-intensive software solutions for national and regional business in a variety of sectors. “We are excited to have such a savvy business technologist like Ron join our team,” said Peter Dobler, President of Dobler Consulting. “The trend we’re seeing for 2019 and going forward is that business not only need expert managed services for their expanding enterprise data assets; they now need to more expertly leverage those assets through integrative, fine-tuned, custom software applications that are niche specific. Ron gives us this expertise and leadership.” According to Gartner’s Top 10 Strategic Trends for 2019, this trend of fine-tuned software customization is driven by the combinatorial effects of strategic technologies: AI–driven development, edge computing, augmented analytics, blockchain, and security to create smart spaces for innovation, collaboration and immersive experiences. “I have worked in data leveraged software development for over twenty years, and there has never been a more exciting time where the convergence of technologies has (more…)

Integrating Oracle Cloud Mobile Apps into Your Workload

By | Oracle
As the digital world continues to expand, the demand for mobility solutions is increasing. The good news is that the prevalence of cloud migrations is making the transition much smoother. Oracle recommends you move any on-premise Oracle application to the cloud. As a leader, knowing your enterprise’s data and applications are accessible regardless of your physical location can do wonders for your peace of mind. Consider Oracle Mobile Hub If you are interested in enterprise mobility for your organization, consider the Oracle Mobile Hub. It provides a comprehensive platform that simplifies application development for your developers and business owners. It focuses on extending your back-end systems so you can take advantage of applications you already use in a secure mobile environment. You also have the option of using your own developers to build and deploy new apps that will integrate seamlessly onto the platform. What Other Capabilities Does Oracle Offer to Enhance Enterprise Mobile Strategies? Using Oracle’s mobile development framework, you can create a single application that will run on multiple devices, phones and tablets, and operating systems. Android and iOS are both compatible. Oracle’s service bus manages interactions between services and applications throughout the network. This includes both newly (more…)

How to Make Power BI Work for You

By | Database Technology Trends, SQL Server
If you’re searching for software that will enhance your analytics process while making it simpler and more flexible, Power BI is worth looking at. It provides tools that the non-technical users on your team can use to perform analytics with minimal help from the IT team. You can create intuitive models, data visualizations, and dashboards and share them with whoever you want. What is Power BI? –Power BI is a cloud-based analytics software service consisting of a combination of tools (i.e., visualization, self-service data analysis, etc.) that allows users to connect to multiple data sources—no matter where the data resides— and create customized, coherent insights. It’s not exactly new since many of its components were in the market prior to its 2015 release. For instance, Microsoft released Power Pivot as an Excel add-on in 2010. This tool alone is a game changer as it gives analysts the tools to import large volumes of data, create relationships between the data, and perform powerful analysis using PivotTables and Pivot Charts. Using Power BI, you can further manipulate these datasets to perform more complex analyses. Utilize All Components of Power BI – Power BI consists of many components. Users find some more useful (more…)

Make the Most of Microsoft SQL Server with Management Studio

By | SQL Server
Microsoft SQL Servers are an industry leading choice for your workloads, but if you are not using Management Studio you may be making things harder for yourself. The additional service is designed to integrate with your SQL database engine and improve object management, database queries, and other management functionality. What is Management Studio? – SQL Server Management Studio (SSMS) was originally released with SQL 2005 and helps users access and manage their SQL instances. It is an integrated management interface that allows you to access your SQL Server, manage objects, write and perform queries with a number of tools and features. It combines tools from Enterprise Manger, Query Analyzer, and Analysis Manager to get this job done. SSMS is easy to use with an intuitive User Interface (UI) and familiar design built on Visual Studio and will help improve your team’s management of SQL Server objects and elements Object Explorer – The interface is intuitive and makes accessing and managing your databases simple and efficient. The Object Explorer is a hierarchical navigation tree that allows you to locate and act upon objects in your environment. These objects can be databases, tables, etc. You can click through the tree to (more…)

Get your complimentary database consultation
from Dobler Consulting