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)
2009-09-04 (first published: 2008-02-05)
22,545 reads
TJay Belt
2009-04-01
5,001 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
5,650 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,058 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,748 reads
2008-03-27
4,849 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
788 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
429 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
202 reads
spDropField
spDropField does exactly the opposite of spAddField. It checks for existence, then drops it, if it does exist.
2002-03-05
127 reads
Blogs
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
What's New in SQL 2019? at BRSSUG
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Forums
Using crypt_gen_random to generate unique Serial Numbers
Trying to generate unique serial numbers with alphanumerics (A-Z,a-z,0-9) and no special characters.Used below...
OPENQUERY is not inserting identical rows
Hi, Thanks in advance for any help. I am trying to insert into a...
Azure file copy creating a directory to hold the renamed file
Hi All, I'm pretty new to azure and am hitting the following problem. I've...
Ask SSC