Feb 8, 2011
Recently I spoke about how The Best Database Administrators Automate Everything, as well as Document Everything and this got me to thinking in general about things that every Database Administrator (DBA) should be doing. No two Database Administration jobs are the same that’s for sure but there are definitely things that I believe every DBA [...]
Apr 12, 2010
No matter how much of a Super Hero DBA you consider yourself to be, I can guarantee you that there that there will come a time when you have to deal with either a disaster scenario or some form of mistake. Interestingly however, it is what happens next that separates the Pro’s from everyone else. Things can [...]
Jul 27, 2009
In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility. Given that your data is so important, how can you manage and ensure it’s safekeeping? Should a data loss event occur, you want to be in a position to enable you to protect the majority, if not all, of [...]
Jul 20, 2009
You’re busy coding away at your workstation when all of a sudden your manager walks over to you all excited and begins discussing with you, the details of this great new application your company has just aquired. It turns out that he wants you to look after and administer this newly aquired application platform, which [...]
Jun 5, 2009
Paul Randal pointed me in the direction of an awesome resource list of FREE SQL Server tools. There is an absolute mountain of quality stuff here and I wanted to share it with you all. Free SQL Server Tools that might make your life easier Be sure to me know which resources you use and [...]
Mar 20, 2009
This week I came across what could quite possibly be, the best SQL Server index defrag script I have seen. This little beauty is fully customisable and is freely available courtesy of Michelle Ufford (aka SQL Fool) on her blog SQLFool.com As you know, it is just not practical to use a SQL Server Maintenance [...]
Feb 3, 2009
The starting point for a rock solid disaster recovery (DR) strategy is to establish what the true cost of server/platform downtime would be to the business. The project will require you to collaborate with your key business decision makers and you will need to communicate to them what the associated costs of downtime are and [...]
Most Commented Posts