Sorry for the thin amount of apparent content, but this site is pretty much just where i login and download my scripts as I hop from server to laptop . 90% of the content is behind the login, so I can access it, but the available shared content to the public is really light.

As An Experienced SQL Server DBA, you’ll begin to notice that the most common issues you focus on end up falling into a handful of logical categories.

I have assembled a collection of very data-dense SQL Server scripts that will help you focus and identify the issues in these categories, to provide a fast,

complete picture of what is going on, and the direction to take to fix the issues.

“The Right Now Emergency Bucket”

queries that help you see exactly what is going on quickly, so you can focus on the resolution

“The Performance is Slow Bucket”

queries that help you find bad statistics, missing indexes and poor procedure/sql statement performance

“The Stuff is Not Working as Expected Bucket”

queries that find errors, job problems, SSRS reports and subscription  failures, login or permissions issues, and application errors.