T-SQL

Nuggets of gold for SQL Server and T-SQL

Availability Group Database Replication Status

Show replication status (send/redo/...) for Availability Group databases
Dynamic SQL

Execute dynamically constructed T-SQL statements
Debug output

Getting non-buffered feedback/ progress from batches and stored procedures
Show locks

What locks are currently held on objects in the current database and by who?