KQL

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.

I’m using SQL and KQL to solve Advent of Code puzzles this year. It’s an annual event in which participants solve a series of increasingly complex challenges.