You are an awesome DBA. You have complete control over your dominion. You have all your backups automated and the testing of those backups is automated. You have alerts properly configured on all your servers. You have your index maintenance plans running regularly. You ride a unicorn to the office and George Hamilton asks you […]
I submitted a script to SQLServerCentral.com and it’s been published today. The script automatically re-trusts foreign keys or constraints. It will also report any that could not be re-trusted. Discussion about the script can be found here. I have post here about how your foreign keys and constraints might become untrusted and why it is […]
Pop Quiz, hotshot. A vendor installed a maintenance plan on one of your SQL Servers. It looks like this: What do you do?
I’ve been playing around some more with SQL 2012 and I discovered another nice little improvement. This isn’t anything huge, but rather a nice little touch that makes my life as a DBA a little bit easier. If you have your SQL Agent jobs configured to send you email when they fail (or succeed or […]
Brent Ozar Unlimited has released a new version of their awesome sp_Blitz server checkup script. I’m pleased to report that this version includes some checks that I submitted: a check for the last successful DBCC CHECKDB, a check to see if @@servername is null, and an update to the backup check to make sure the […]