Find sleeping sessions with open transactions, inspect their locks and last batch, and identify the application owner before ending work.
SQL SERVER – Clustered Index on Separate Drive From Table Location
A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.
SQL SERVER – Effect of Normalization on Index and Performance
Normalization organizes data dependencies, while indexes support access paths. I evaluate their performance effects through the actual workload.
SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
SQL Server 2008 brought the debugger back, and its button sits right next to Execute. Here is how to customize toolbar buttons and remove the debug button.
Preventing Overbooking When Two Sessions Grab the Last Seat
Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.
Errors TRY CATCH Cannot Catch: Compile, Name and Severity Errors
Learn which errors TRY CATCH cannot catch, test execution scopes safely, and pair transaction cleanup with caller timeout handling.
Your First Extended Events Session
Build your first Extended Events session for slow SQL calls, choose a bounded ring buffer or file target, and read the captured result.