Archives: March 2011
I look after several clustered instances of SQL SERVER. One of the tasks that I do every morning is to check if any of those instances have failed over to a new node. I would prefer to have this monitored automatically, and that’s what this post is about –… Read more
Occasionally, I hear things that surprise me. And one of the statements that I’ve heard lately that fits into that category is that if your database files are on a RAID volume that you don’t need backups.
Well, we hopefully all know what RAID stands for – Redundant… Read more
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will be used so that I can implement good indexes up front – rather than waiting until production to performance tune.
Some of those choices will be
- Where to place…
In part one, I gave a general overview of some of the things that may affect IT services in the event of a natural disaster, specifically an earthquake.
In this article I will look at how priorities may change and the speed at which they will change and…
I've just read Paul Randal's sqlmag article about the need to test your disaster recovery strategy. In that article Paul mentions a short presentation that I did on the Thursday night at the Feb 2011 Internals event in Dallas.
In that presentation I spoke about my own IT…