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,140 reads
TJay Belt
2009-04-01
5,157 reads
On-Call Duties
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,177 reads
A Simple DR Solution
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,266 reads
Audit Database Changes in the Real World
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,979 reads
2008-03-27
5,048 reads
sp_GetBackupInfo
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
sp_GetLastBackup
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
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
spDropField does exactly the opposite of spAddField. It checks for existence, then drops it, if it does exist.
2002-03-05
135 reads
Blogs
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Forums
One more reason to use foreign key constraints
Comments posted to this topic are about the item One more reason to use...
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers