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

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

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