Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.
An Error Handling Template for Stored Procedures With THROW
Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.
Designing a Simple ETL Framework
An ETL framework in SQL Server needs a small set of configuration, run logs, restart checkpoints, and alerts that operators can trust.
SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012
SQL Server 2012 adds the new system stored procedure sp_describe_first_result_set. I try it on a query and a view to see what metadata it returns.
Stored Procedure Recompile Quiz: What Forces a New Plan?
This Stored Procedure Recompile Quiz asks which action makes SQL Server build a new plan for a procedure. The answer is a new index on a table it reads. A tested script uses plan counters to show what reuses the plan and what rebuilds it.
SET NOEXEC and PARSEONLY: Checking a Script Without Running It
Use PARSEONLY and NOEXEC to inspect scripts without executing them, understand deferred references, and check existing module dependencies.
SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object
Why using keywords as an object name is a bad practice: a stored procedure named GO runs with EXEC GO, and the result can surprise you.