Testing an application for SQL injection on a safe copy reveals response clues and unsafe query construction before repair.
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples
How trigger recursion and nesting work in SQL Server 2005: triggers nest up to 32 levels, recursive triggers fire themselves, and both can be turned off.
SQL SERVER – 2005 Enable CLR using T-SQL script
In SQL Server 2005 the CLR is off by default. Here is the sp_configure script to enable CLR, turning on show advanced options and then clr enabled.
SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’
ALTER LOGIN can enable, disable or rename a SQL Server login. I verify another administrative access path before changing sa.
SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1
Msg 3159 says the tail of the log was not backed up, then Msg 3013 ends RESTORE DATABASE. A script that worked in SQL Server 2000 failed in 2005, and here is why.
SQL SERVER – SET ROWCOUNT and TOP Precedence with Deterministic Limits
SET ROWCOUNT limits the session, while TOP limits a statement. I reset ROWCOUNT after testing so later queries keep their intended limits.
SQL SERVER – Good, Better and Best Programming Techniques
My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.