Did the server really crash, or just restart? Here is how to list dump files, read the error log and protect the evidence before anyone cleans up.
Where a Business Rule Should Actually Live
Place the business rules database applications depend on in constraints, procedures, triggers, or application code according to their guarantees.
Blocking DELETE Without a WHERE Clause Using a Trigger
A trigger cannot read your statement, but it can count the rows that vanish. Here is a guard that stops a runaway delete, and where it falls short.
A Page of Rows and the Grand Total Count in One Query
One query can give a grid its ten rows and the total for the label. Here is how, plus the empty page trap that catches almost everyone.
Temporal Tables: Keeping History Without a Trigger
Use temporal tables to retain earlier row versions, query a past state, and plan history storage without confusing version history with user auditing.
A Shared SEQUENCE for Invoices and Credit Notes in One Range
One sequence, two tables, and an auditor asking about number 8. See where gaps come from, how duplicates sneak in, and where uniqueness should live.
Running SQL Server in a Container for Testing
Create a SQL Server container for testing from Windows PowerShell, keep data in a named volume, and separate disposable runtime from backups.