Posts

The crime spree in Digitown is not ending. This time 20 cars have been stolen and we need to find where they’re stored.

The people of Digitown are being targeted by phishermen, and they need my help to stop them in their tracks.

Another KDA case: Digitown’s utility bills suddenly doubled for no good reason. With the election coming up, I got pulled in to figure out what went wrong. I’ve got the billing data and the SQL they used—now it’s time to dig in.

I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.

While I mostly write about SQL Server, I have a soft spot for Kusto. In this series, I will explore solutions to fun challenges collectively known as the Kusto Detective Agency.

Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.

I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but … reading the extended event file is so much pain.