2020-11-02
481 reads
2020-11-02
481 reads
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 […]
2020-10-29
5,065 reads
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.
2020-10-27
1,774 reads
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,262 reads
2020-10-19
436 reads
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
2020-10-14
91 reads
2020-10-12
459 reads
2020-09-28
461 reads
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.
2020-09-28
78 reads
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 […]
2020-09-24
505 reads
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Comments posted to this topic are about the item Data Privacy Grows in California
Hi I need to grant a user access to a DB on the server...
I have this table that unfortunately has spaces in the field, which I am...