Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: March 2011

Cluster failover – what’s the best way to get notified?


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, 1,518 reads

Posted in measure twice, cut once. on 27 March 2011

So you’re RAIDed, but are you protected?


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

0 comments, 203 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…

Read more

7 comments, 1,168 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…

Read more

1 comments, 241 reads

Posted in measure twice, cut once. on 15 March 2011

Disaster Recovery Exposure. - Part One


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…

Read more

5 comments, 493 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, 287 reads

Posted in measure twice, cut once. on 6 March 2011