The Challenge of Implicit Transactions: #SQLNewBlogger

I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another...

A Broken Copilot Query

I was testing the new SSMS (v22 Preview 3) with Copilot and ran into an interesting issue. This is part of a series of experiments with AI systems. My...

Set Theory vs. Batch Mode in SQL Server

Set Theory vs. Batch Mode in SQL Server

Not long ago, a colleague of mine was completely shocked when he first heard about SQL Server’s Batch Mode feature. His immediate...

The Mystery of the Locked-Up Database -Scooby Dooing Episode 6

No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL Server 2025, those footprints point us straight toward the next big feature: optimized locking. And...

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

There was a time when the Chief Data Officer lived in the shadows of the enterprise. Their office lights burned late into the night as they combed through spreadsheets...

Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation

Artificial intelligence is no longer a distant concept. It is here, embedded in the way we work, create, and make decisions. From generative assistants to predictive analytics, AI is...

Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect

Have you ever received the dreaded error from SQL Server that the TempDB log file is full? Only to open SSMS and be greeted with a message that prevents...

T-SQL Tuesday #191: Invitation–Your Favorite String Parsing

It’s that time of the month, and I’m late. My apologies. I had a mix-up with a host and was on vacation all last week, so no invite. I’m...

The Book of Redgate: We Value Teams

This value is something that I still hear today: our best work is done in teams. On the facing page, there is a short description of what this means....

The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5

Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail of clues. With SQL Server 2025 now reaching its first Release Candidate (RC0), it feels...