This script will create a procedure to list all databases on the server (except tempdb), the last time the database was backed up (database backup, not log backups), and a comment which could be customized. For my purposes, I flag any database which hasn't been backed up in the last week. This provides a quick […]
2002-06-14
3,131 reads
For jobs that run periodically and should take only a short time to run, a DBA may want to know when the job has been running for an excessive time. In this case, just checking to see IF the job is running won't do; the ability to make sure that it hasn't been running for […]
2002-01-15
3,975 reads
This script will allow you to create a stored procedure that will check a server for any jobs that have failed in a specified number of days. It has proven valuable to me, since I have servers with lots of jobs that run frequently; I got tired of checking the history of each job to […]
2002-01-01
4,314 reads
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
By Brian Kelley
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...
Comments posted to this topic are about the item Serverless Gets Faster
I have a task to check the connection managers as part of ssis integration...
I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?
See possible answers