Archive for September, 2009
Using sysjobhistory to Find What’s Running Longer than Usual
We all have SQL Agent jobs that run periodically. Wouldn’t it be nice to know that something ran longer than average last night? When something runs longer than average, this could indicate a looming problem. I love finding these things before they cause serious problems because that prevents my phone from ringing in the middle [...]
An Object by Any Other Name
In my career, I’ve seen a lot of database objects. And I’ve seen a lot of names, both good and bad. It seems that every shop I’ve worked in talks about naming standards. Unfortuately, those standards aren’t always followed. I’ve read some of the following ideas about naming standards: Tables should be prefixed with tbl [...]
Giving Microsoft Access a Seat at the Table
Ask any DBA what they think of Microsoft Access, and you’ll rarely see a smile. Perhaps you’ll get a laugh, but most DBAs will turn up their nose. What I’m about to say is probably blashphemy in the DBA community, but when used properly, Access can have a place in some environments. I pray that [...]