A Failed Jobs Monitoring System
One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)
2017-02-02 (first published: 2008-02-05)
23,118 reads
One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)
2017-02-02 (first published: 2008-02-05)
23,118 reads
2009-04-01
5,154 reads
What are some of the on-call duties a DBA must perform? TJay Belt talks about them in this new article.
2008-10-27
6,160 reads
Tjay Belt brings us a quick and easy DR solution that might provide you some protection if you don't have a DR plan and want some lessons learned in this area.
2008-07-31
8,263 reads
Tjay Belt brings us a story of how auditing was actually implemented and a discussion of why particular decisions were made.
2008-06-11
8,970 reads
2008-03-27
5,044 reads
This will report all backup activity for all databases, sorted by date, so you see the last backup activity first. You can filter this one by a db name as well, and only see the backup info for said database.
2002-03-07
798 reads
This will get the last date a database was backuped. It allows you to report this date on all databases on a server, or pass in a db name, and it'll report the date that db was last backed up
2002-03-07
439 reads
spAddField is the proc I use to add all fields to the db in our upgrade scripts. With this proc, you pass it the tablename, fieldname, datatype, and null or not null. This will call spGetFieldsExists and see if the fields exists or not. If it does, spAddField will drop that column. Then it readds […]
2002-03-05
212 reads
spDropField does exactly the opposite of spAddField. It checks for existence, then drops it, if it does exist.
2002-03-05
135 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi everyone I need to find the last business of the week. In most...
Please share a situation when enabling and taking further advantage of DBCC TRACEON -...
All, Need a linked server guru. Trying the following in a stored procedure: SET...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers