Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger

I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post...

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

What Does It Mean to Make Data AI-Ready?

Making Data AI-Ready, Part 1 (This is the first article in a three-part series on making data AI-ready. Part 1 explains what AI-ready data actually means, Part 2 looks...

Car Update September 2026

Software is hard. While I love our Lucid Gravity, I realize that they are behind Tesla with software. A few of the weird UX and software engineering decisions they’ve...

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

T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup

When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what kind of stories would come out of it.
The topic was simple:
That one SQL Server outage...

Microsoft Tools for Making Data AI-Ready

Making Data AI-Ready, Part 2 (This is the second article in a three-part series on making data AI-ready. Part 1 covered the fundamentals of AI-ready data, this article looks...

Local Models Using GPUs with Ollama

Can you use your GPUs when running a local model under Ollama? You can, and it really depends on how you run Ollama and what your hardware is. Ollama...

Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency

In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with edges, and uses greedy graph traversal to avoid comparing a query against every vector in...

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