Does a Query always wait in the SUSPENDED State?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Music City Tech Rocked!

I know Nashville is most famous for Country music, but in the recent years, it has become home to more...

Power BI Custom Visuals Class (Module 105 – Text Wrapper MAQ Software)

In this module you will learn how to use the Text Wrapper by MAQ Software. The Text Wrapper allows you...

SQL Database Corruption: Causes, Prevention, Fixing Techniques

“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I...

SQLSaturday Orlando 2018 – Planning Update #2

Continuing the notes I wrote in Update #1, got a few more things done last week:
Received confirmation that the event...

WSFC Lost Quorum votes due to network problem

Problem:

Early in the morning I received emails requesting for support as the applications were failing to connect to one of the production servers that are configured with Always On,...

A Broken Linux VM

I have no idea if this is the best thing, but I went to boot up a Linux VM today...

DBCC Clonedatabase and Query Store

Cloning things is all the rage these days…..even Storm Troopers.
Anyway, by now, you probably have seen documentation on Query Store...

Deploying Azure Container Instances

In a previous post I went through how to Push an image to the Azure Container Registry
Now let’s look at...

Extended Events, the system_health Session, and Waits

I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old...