SQL Noire – A Database Murder Mystery
Proposed session for SQLBits 2026TL; DR
One hard-boiled DBA, one rogue developer, one dead database.
Step into the aftermath of a failed deployment, where our two protagonists examine the evidence and decipher the clues to get to the bottom of who, or what, killed the production database. Was it a bug, an honest mistake, or was it something more sinister? As this riveting story of lies and database corruption unravels, our investigators will uncover the shocking truth of what really happened that fateful Friday evening.
Session Details
One hard-boiled DBA, one rogue developer, one dead database.
Step into the aftermath of a failed deployment, where our two protagonists examine the evidence and decipher the clues to get to the bottom of who, or what, killed the production database. Was it a bug, an honest mistake, or was it something more sinister? As this riveting story of lies and database corruption unravels, our investigators will uncover the shocking truth of what really happened that fateful Friday evening.
Step into the aftermath of a failed deployment, where our two protagonists examine the evidence and decipher the clues to get to the bottom of who, or what, killed the production database. Was it a bug, an honest mistake, or was it something more sinister? As this riveting story of lies and database corruption unravels, our investigators will uncover the shocking truth of what really happened that fateful Friday evening.
3 things you'll get out of this session
* Troubleshooting a failed deployment
* Using Querystore and logs to troubleshoot database problems
* Spotting a liar
Speakers
Daniel Hutmacher's other proposed sessions for 2026
20 years of productivity tips - a love letter to SSMS - 2026
Good dates, bad dates: Mastering your T-SQL date and time datatypes - 2026
JSON fundamentals for SQL pros - 2026
SQL Injection – The Old Dog of Data Security - 2026
T-SQL paging done right - 2026
Daniel Hutmacher's previous sessions
ACID in SQL Server: what it is, how it works, and how to live more adventurously.
A primer on ACID compliance in SQL Server, though mostly on Isolation and Durability, since those are the ones you have some control over. Presented at Data Saturday Gothenburg and Oslo 2023.
From substitutions to public keys - an introduction to cryptography
High-level introduction to cryptography.
Magnus Ahlkvist
tsql.nu
Magnus Ahlkvist's other proposed sessions for 2026
An introduction to SQL Server database projects - 2026
Everything you need to know about Temporal Tables - 2026
Get Started with tSQLt - 2026