Uncategorized

Developing and implementing the complete ETL process—from raw data extraction to transforming, cleaning and validating the data to loading it into the target data warehouse—can be complex. Whether you are dealing with quantitative data or unstructured data, the right end-to-end ETL solution—XpressInsight, for example—can make the difference between making real-time, insightful decisions or complete, chaotic …

ETL Processes Designed to Fuel Your Business Intelligence Strategy Read More »

Your First Step Toward Optimized Database Performance and Security Take control of your data environment with a database health check by Dobler Consulting   Position Yourself for Success with an Database Health Check Before you can build a winning business strategy or begin transforming your organization to be more competitive, you need to first identify your strengths, weaknesses, assets and liabilities. Getting a …

Database Assessments Read More »

First of all I have to apologize to my loyal readers for the long absence from my blog. In simple terms, “I got busy”. But in these economic times, I guess this is a good thing. I don’t want to give a promise I can’t keep, but I will do my best to keep this …

2010 – The Year of In-Memory Databases? Read More »

It seems analyst are hard at work to find the right wording that connects the promise of in-memory technology, to advanced analytics to multiple database sources, at the precise moment of transaction with the customer. Forrester calls it the odd-looking word  “translytic” as in “translytic data platforms”, Gartner uses the term “hybrid transaction / analytical processing, hopefully, HTAP for …

2018 Trends for Database and Data Management – Six Months Later (Trend 2) Read More »

Database support does not have to be challenging.  Your database systems should work for you by contributing to your productivity and business practices.  When businesses spend most of their time and resources on managing their database systems, they are taking away quality time that should be spent on high-level projects.  This is a common issue …

3 Ways Remote DBA Services can Save Your Company Time and Money Read More »

If you are interested in migrating to a cloud database but concerned about security issues, look no further. Hybrid and cloud native databases do have their own set of security concerns, but if you go with a trusted company and maintain it appropriately, you have nothing to fear. In fact, cloud databases can be more …

Improving your Database Security with Microsoft Azure Read More »

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 …

Is SQL PaaS Right for You? Read More »

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 …

Simplify Data Management with Azure Data Studio Read More »

Big data and analytics go hand in hand. If you are handling big data, then you understand the power and the pitfalls this brings. Advanced analytic options, AI and real-time processing are useful tools. But to balance this power you may end up sacrificing productivity and ease of use. Azure Databricks provides a high-performance analytics …

Simplifying Your Analytics with Azure Databricks Read More »

Let’s talk a little bit about big data. This is such an important buzz word in technology and data management circles these days. I think, however, that sometimes the nuances get lost. Big data is great, and has amazing potential applications for improving business processes, marketing opportunities, and customer identification, among others. Big data facilitates …

Getting Lost in Big Data? Read More »