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.
SQL SERVER – Order of Hotfix and Service Pack
What is the right order of hotfix and service pack installs? You do not need every older service pack. Install the latest service pack and hotfix and you are done.
Sending a Microsoft Teams Alert From a SQL Server Agent Job
Send a Teams alert from a failed SQL Server Agent job with a Workflows webhook, PowerShell, SQL Server 2025 REST calls, and mail fallback.
SQL SERVER – What is Interim Table – Simple Definition of Interim Table
What is an interim table? A simple question started a long debate on a call with developers. Here is my simple definition of interim table.
STDEV and STDEVP: Choose Sample or Population
STDEV and STDEVP report spread in the input’s units. Compare a sample, a full population, duplicates, NULL and a single observed value.
SQLAuthority News – Summary of TechEd India 2009 – A Grand Event
My summary of TechEd India 2009: Steve Ballmer’s keynote, a talk by the Oscar winning sound designer of Slumdog Millionaire, tech sessions and great community spirit.
SQL SERVER – List All Objects Created on All Filegroups in Database
A reader asked which object belongs to which filegroup. Here is how to list all objects created on all filegroups in a database, with a sample database.
SQL SERVER – Create Multiple Filegroup For Single Database
How to create multiple filegroup for a single database, both for a new database and an existing one, using T-SQL as well as SSMS.