T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a break with my wife. I think I’m in Croatia (or off the coast) today, but...

dataMinds Connect 2026 – Slides & Scripts

You can find the slides and SQL scripts for my session “Spice up your SQL – Intro to window functions” at GitHub.
The post dataMinds Connect 2026 – Slides &...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later)

Updated for SSMS 21 and later: This is a new, rewritten version of my earlier article...

The flight recorder: Replaying what an AI agent did on my SQL Server

“What exactly did it do on my server?” is the first question a DBA should ask about any AI agent. AgentDBA answers it from its own records: every decision...

Announcements from the Microsoft Fabric Community Conference — Barcelona 2026

Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon and SQLCon Barcelona 2026, with approximately 5,000 attendees at the conference. I’ve tried to make...

Au Revoir for now

No, I’m not quitting or retiring. Just going on vacation, but I leave tonight for Brussels and this is my last day at work for a couple of weeks....

Goodbye, Microsoft

A few years ago I took a new job at Microsoft, working as a Senior Content Developer, and as of this writing I own all the SQL Server content...

The SUM of Nothing: #SQLNewBlogger

I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the...

How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections

I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But why keep this important visual warning at the bottom of the screen? In this post,...

Architecting Zero Downtime Deployments–Day of Data Boston

Here are the resources for my talk at Day of Data Boston. Slides – ArchitectingZeroDowntime.pptx Slides also at: https://dayofdata.org/2026-10-03-dayofdata1150/#schedule Code: https://github.com/way0utwest/ZeroDowntime Book: Refactoring Databases Some interesting questions. I’ll write...