Announcements from the Microsoft Fabric Community Conference

A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference (FabCon Vienna) recently. Here are all the new features that I found most interesting, with...

Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise

For decades, enterprises have thought about data like plumbers think about water: you build pipelines, connect sources to sinks, and hope the pipes do not burst under pressure. That...

Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain

Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton of fun writing these, and I hope you’re enjoying the ride through SQL Server’s haunted...

The Book of Redgate: Don’t be an a**hole

This was one of the original values: The facing page has this text: No matter how smart you are, or how good you are at narrowly defined tasks, there...

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

Prompt AI helping with Auditing

I had a conversation with a customer asking this question: how can I tell who called a stored procedure so I can audit the action? I decided to see...

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