Find deprecated features with SQL Server counters, event metadata, and code searches, then separate future risk from features already removed.
SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video
Many asked for a demo after our video on errors and reactions. In SQL in Sixty Seconds #005, Rick Morelan shows how SQL Server reacts to a T-SQL error.
Why Staging Tables Earn Their Keep
Use staging tables to preserve raw input, validate changes, separate extraction from publication, and make failed loads easier to diagnose and replay.
Stopping a Trigger From Firing Itself With TRIGGER_NESTLEVEL
A timestamp trigger that updates its own table can loop until SQL Server gives up. Here is the small guard that stops it, with a demo you can run.
SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video
SQL in Sixty Seconds #004 for February 29th: a short function that checks if any year is a leap year, using the SQL Server 2012 IIF, EOMONTH and CONCAT functions.
SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video
In SQL in Sixty Seconds #003, Vinod Kumar shows T-SQL constructs for declaration and initialization of variables, a simple trick to save time.
SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video
In SQL in Sixty Seconds #002, Rick Morelan explains T-SQL errors and reactions: what SQL Server does when it hits an error, in about a minute.