Archives: March 2011
Cluster failover – what’s the best way to get notified?
G’day,
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
2 comments, 2,803 reads
Posted in measure twice, cut once. on 27 March 2011
So you’re RAIDed, but are you protected?
G’day,
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.
Really!!!
Well, we hopefully all know what RAID stands for – Redundant… Read more
0 comments, 377 reads
Posted in measure twice, cut once. on 24 March 2011
Primary Keys – why accept the defaults.
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…
7 comments, 1,729 reads
Posted in measure twice, cut once. on 19 March 2011
Disaster Recovery Exposure - Part Two
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…
1 comments, 515 reads
Posted in measure twice, cut once. on 15 March 2011
Disaster Recovery Exposure. - Part One
G'day,
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…
5 comments, 1,119 reads
Posted in measure twice, cut once. on 15 March 2011
In summary - SQLskills internals.
Well, I attended a full week of SQL internals from Paul Randal [Blog | Twitter] and Kimberley L. Tripp [Blog | Twitter] of SQLskills.
Some of you may remember that I won entry to the week's training with this blog post. In that post… Read more
2 comments, 466 reads
Posted in measure twice, cut once. on 6 March 2011