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

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

T-SQL Tuesday #186–Agent Jobs

It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month...

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

SQL Saturday NYC Recap 2025

My first time at SQL Saturday New York City was an absolute blast! Thank you so much to the organizers and the incredible people who chatted with me during...

SQL Server Index Primer

Indexes 101: What, Why, and When? “What Is an Index?” I get this question a lot, especially from developers and sysadmins who’ve been handed a SQL Server and told,...

SSMS 21

Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio...

A New Word: Lookaback

lookaback– n.  the chock of meeting back up with someone and learning that your mental image of them had fallen wildly out of date – having grown up or...

Secure Azure SQL Server Backups Using Managed Identities

I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs).  If you recall you would use the storage key...

Can AI Read Execution Plans?

Yeah, yeah, second AI post in a row. I promise not to make a habit of it. But I saw someone else mention that you can feed them XML...