How to Troubleshoot Waiting Tasks Without Requests in SQL Server?

Usually, when I need to troubleshoot currently running requests, I use a combination of sys.dm_exec_requests and sys.dm_os_waiting_tasks. The former retrieves...

Multiple disk controllers in VMs can mean improved performance

I recently had a great question on some of the differences in virtual machine disk presentation from one of our...

Server Audit Mystery 1: Filtering class_type gets Error Msg 25713

The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...

Summit 2018 Program Survey

PASS has a survey out asking for your thoughts on the  2018 content. Take a few minutes and fill it...

Undercover TV – We’ve got a YouTube channel!

We’ve now got ourselves a shiny new YouTube channel at UndercoverTV.
We’ll be using this to host our monthly podcasts as well...

VSLive 2018 Austin, TX

VSLive events are nice conferences to get a wide range of topics from .Net to mobile development to the data...

Why I cannot download .pbix files from powerbi.com

If like me you thought “Hey, it’s a new feature, I can finally create reports in powerbi.com service and then...

Can You Hear It Now?

Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...

Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...

DAX IF & Switch Statement Performance – Does Order Matter?

Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...