Write tests for stored procedures with arrange, act, and assert steps in T-SQL, isolated data, and a repeatable check before every change.
SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS
@@CONNECTIONS and @@MAX_CONNECTIONS explained: login attempts since SQL Server started versus the most simultaneous user connections allowed.
THROW or RAISERROR
THROW or RAISERROR changes how SQL Server handles severity, formatting, and XACT_ABORT; choose the right pattern for new procedures.
SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
What is the effect of a TRANSACTION on local variable values after ROLLBACK and after COMMIT? A short example I wrote for a Jr. Developer shows the answer.
Last Line of a SQL Script: The Joke Every DBA Has Lived
The last line of a SQL script decides whether your work is saved, rolled back, or still holding locks. Here are the classic endings and how to check them.
SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
An SSIS package fails with Error 3902: the COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. Two fixes, one is RetainSameConnection set to true.