Index Maintenance Can Change NORECOMPUTE Settings

I had a customer recently ask about a change in one of their constraints on production, where a new option appeared when they went to deploy some changes from...

So You Think You Should Get a Radio

This is not database related, so if you’re not interested in hearing about something besides SQL Server, PostgreSQL, DevOps, community or data management in general, time to move on....

Speaking at SQL Saturday Austin 2025

SQL Saturday Austin 2025 is in just a few days. I am honored to be speaking there, and glad to be going back. I’ve missed a number of the...

Updating SSMS is Easy (w/ v21)

I’ve been using the SSMS preview for v21. This is the next evolution of SSMS, where the VS shell is finally being updated. For many of us, SSMS has...

Execute Fabric Data Pipeline from Azure Data Factory

In the blog post Call a Fabric REST API from Azure Data Factory I explained how you can call a Fabric REST API endpoint from Azure Data Factory (or...

Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025

I’m excited to announce that on June 17 – 18, 2025, I’ll be running a special Online Live Training event focused entirely on SQL Server Query Tuning! This is...

Testing for End of Month in PowerShell

This is one of those blog posts you write so that 2 years later, you can look it up to remind yourself how to do something.
I found myself needing...

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

I have recently had the privilege of working with multiple clients who have been taking advantage of Change Data Capture “CDC”. Change Data Capture is a feature that utilizes...

KDA: Echoes of Deception - Onboarding

I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.
The UI layout
This is what your layout might look like:

LHS menu where you...

Kusto Detective Agency - Intro

While I mostly write about SQL Server, I have a soft spot for Kusto. In this series, I will explore solutions to fun challenges collectively known as the Kusto...