This T-SQL script backs up all user databases.
exec sp_msforeachdb 'if db_id(''?'')>4 backup database [?] to disk = ''c:\?.bak'' with init, compression;' 
New author Jason Crider brings us a few tricks and tips that can help you be a more efficient DBA, or a more efficient employee in general using technology.
2009-02-19
9,021 reads
2009-02-12
6,669 reads
New author Greg Bates brings us a few tips for those of you new to being a DBA or without much experience.
2009-01-26
14,593 reads
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking about and I have a short story to support it.
2008-09-22
2,211 reads
In this article, republished from Brad McGehee's book 'How to Become an Exceptional DBA', Brad explains why there are several advantages for DBAs in continuing to take exams throughout their careers.
2008-07-08
5,554 reads