Resources

SQL Saturday and User Group presentations

storage     locks

 blocking-operators dba-guide

analyze-your-plan

Code snippets

Identify SQL Server data type drift (columns with mis-matched data types)

SQL Server authenticated account password brute force demo

Identify SQL Server accounts with passwords that are blank or same as name

Retrieving data from the SQL Server default trace

Hardware validation using PowerShell

Publications

AlwaysOn Architecture Guide | Technical Reviewer

Finding and Extracting Deadlocks using Extended Events | Author

Monitoring SQL Server Disk Usage | Author

 

FITDB™ – Complete SQL Server assessment

fitdb