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

SQL Server Alerts

Don’t Let Trouble Sneak Up on You   Most SQL Servers run quietly. Until they don’t. By the time someone notices an application outage or a failed backup, you’re...

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

Connect resiliently to SQL Server

 Why you should connect resiliently to SQL Server
Transient failures happen — in the cloud (Azure SQL) and on-prem. A resilient connection strategy lets your app recover gracefully instead of...

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