T-SQL Tuesday #202: 100 Hours

It’s time for T-SQL Tuesday again and this is a great prompt to start writing. I might have written about this before, but it’s a story that sticks with...

Why sys.fn_dblog Is Undocumented And Why It's Still There

Why sys.fn_dblog Is Undocumented And Why It's Still There

Why sys.fn_dblog Is Still Undocumented — And Still There

This article is about why things are the way...

A Last Minute Trip to the EU

My life has some crazy travel stretches for sure. Between speaking, office visits, customer trips, I can be on the road a lot. As it is, I’ve flown across...

Building a DBA Agent for Your SQL Server Estate with MCP

Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your SQL Server Estate”. I’ll drop the recording into this post once it’s published. What I...

Measuring RAG Solutions: Are We Retrieving the Right Information?

A RAG pipeline that answers questions in the demo is not the same thing as a RAG pipeline that answers them correctly. The gap between the two only shows up...

Keeping Redshift System Table History Past 7 Days with S3 Tables

Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine until an auditor or an incident review asks for something older. Until now the usual...

The Book of Redgate: Hours

I have said and written this many times: Redgate Software is the type of company I’d want to build if I founded another company. It’s a great place, and...

Updating the Data API Builder

I was updating my session for the Data API Builder (DAB) recently, mostly to work with the MCP server capabilities. As I was trying to get this working, I...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

How I used AI for this postChatGPT to generate images based on info specifically provided by me,including examples.Grammarly to catch grammar and sentence construction errors. I did a presentation...

Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together

Most enterprise questions do not live neatly in one place. The numbers may be in a warehouse, the rules may be buried in PDF files, and the explanation may...