T-SQL Snapshot Backups on Availability Group Secondary Replicas

One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups. The ability to leverage the snapshot capabilities of modern storage arrays to take application consistent...

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

How to Check TDE Progress and Elapsed Time in SQL Server

How to Check TDE Progress and Elapsed Time in SQL Server

Transparent Data Encryption (TDE) protects SQL Server data and log files while they are stored...

PostgreSQL Support in the Data API Builder

Next week I’m at VS Live in San Diego (register and join me) and one of my talks is on the Data API Builder. I want to show how...

Ten Years of PowerShell

Ten years ago today, I filmed a Pluralsight Play by Play on open source PowerShell. I was standing between Jason Helmick and Jeffrey Snover, trying very hard not to...

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

T-SQL Tuesday #202 - That One Outage You'll Never Forget

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Marlon Ribunal
(blog) asks us to talk about that one SQL Server outage...

Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search

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. In Part 1, we...

T-SQL Tuesday #202: The Two Outages I Won't Ever Forget

My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages. Two nights I still remember minute by minute, and what I do differently because of...

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