Lift and shift vs modernizing your data warehouse

If you are migrating a data warehouse, there is a question worth asking before you start: should you recreate the existing solution on the new platform, or use the...

Power BI Fun With Travels

I’m back from a great vacation. I had the chance to visit two new countries (for me and my wife) and many new cities as we cruised around the...

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