Is the traditional data warehouse dead?

There have been a number of enhancements to Hadoop recently when it comes to fast interactive querying with such products...

Using SQL Server Management Studio Projects

One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can...

Creating and Using Failover Groups in Azure DBaaS – Part 1

Introduction
Hello everybody! Welcome back! One of my favorite features in Azure SQL DBaaS is Failover Groups.  I have been working...

Design Concepts For Better Power BI Reports Part 4: The Squint Test

Data visualization should be iterative. You should get a good initial draft put together and then check to make sure...

A Business Lesson from an Oil Change

When I first moved to the city where I now live, I found an oil change place just a couple...

Capture Index Maintenance Operations

If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
Related Posts:

Where is that Mask? December 28,...

Capture Index Maintenance Operations

One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...

Disable, don’t delete those indexes

A quick post this week, since it’s that time of the year when people do gift exchanges and put up...

Making a Difference: Andy Warren

Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...

AHHH I need a Blog Topic!!!

One of the hardest things you can do as a blogger is to come up with a post topic. Do...