Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

Read-only T-SQL checks for a SQL Server DBA working through a daily operational review. The scripts are designed for a lab or an authorised administrative environment and avoid data modification.

This template provides a baseline for evaluating enterprise DBA candidate’s skill set, ranging from application deployment support to database design.