Missing Indexes in the Query Store

I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place...

Missing Indexes in the Query Store

I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing...

Data Warehouse Design and Power BI at SQL Saturday Tampa 2019

Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...

One week blogging hiatus

I’m taking a brief break from daily blogging, even though it has been a ton of fun.

No excuses
I hope...

SQL Server Availability Group Failovers in Kubernetes

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

Last Week Reading (2019-03-10)

Databricks-Connect – FINALLY! Do write your code in VS Code and run it remotely on Azure Databricks cluster. Automatically validate E-mail...

dbatools

Requests or Suggestions

...

Debugging Type Binding in PowerShell

Some effort I spent in researching Type Binding in Stack Overflow to help answer a question by Chris Oldwood helped me solidify my understanding of the best way to...

Communication in Azure: using Data Factory to send messages to Azure Service Bus

(2019-Mar-10) A conversation between two or more people involves continuous efforts to listen and reflect on what other people have to...

Speaking

A place to collect abstracts & links to presentations I’ve given. Please be sure to check out my Sessionize profile as well.
Backup Basics with PowerShell and dbatools Abstract As...