An Identity Crisis: Is it Profiler or is it Extended Events?

I have been working on this article for far longer than one might think is necessary for something of this...

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...

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...

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...

Live on Channel 9 with ReadyRoll

I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some...

More Beginner / Fundamentals Content

Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts. 

I put up the poll based on a...

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...

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...

How to Get Estimated Completion Time of SQL Server Database Backup OR Restore

“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of...