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(…)
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(…)
Popular Articles