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

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

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8 million Hacker News articles that that I used for my talk on SQL Server-based vector...

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

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

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

Evidence-bound: what AgentDBA will and won’t link

When the evidence names the database, it says so. When it doesn’t, it stops. Three databases have no recorded full backup. One backup job failed. Many tools would link...

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

Making Data AI-Ready, Part 3 (This is the final article in a three-part series on making data AI-ready. Part 1 covered what AI-ready data means, Part 2 looked at...

10 Decisions to Make Before You Create A Fabric Workspace

Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built content in them takes a lot longer. Moving content to another workspace usually means redeploying...

Flyway Tips: Object History

It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the object history for different schema changes, so as you are evaluating how your changes might...