Better SQL Server Agent Job Failure Monitoring

SQL Server Agent has a built-in alerting process for when jobs fail, but the information it provides isn’t very useful. You’re only told which job, what time, who ran it, and which step failed. If you want to see why it failed, you have to review the job history manually. On a busy system with […]

Recovering Databases From a Master Backup

Losing your instance might result in the need to get information from what you have. Steve Jones looks at a way to get the proper version and patch, and database list, from what limited resources you might have.

Great Power(Shell)...Great Responsibility

-WhatIf you could see what would happen if you ran a command?

Setting Affinity

Bean Counting to Burnout

Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.

Upgrading User Information

Limiting Access on Startup

Do You Know What the Settings Should Be?

Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.

Execute on DMVs without user having View Server State

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

The Last Compile Time