KQL

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.