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...

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...

Primary Keys – why accept the defaults.

G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...

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...

Disaster Recovery Exposure. - Part One

 G'day,

I've just readPaul Randal's sqlmag article about the need to test your disaster recovery strategy. In that article Paul mentions...

In summary - SQLskills internals.

 Well, I attended a full week of SQL internals from Paul Randal [Blog | Twitter] and Kimberley L. Tripp [Blog | Twitter]...

What...you mean I won...and Thank You.

Well, what a week it’s been. I started my winning blog post for the SQLskills blogging competition by stating that...

Internals and Performance class in Dallas

 
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...

Remember OBJECTPROPERTY(..) when investigating objects.

The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...

Check that what you expected is actually what you got - DB's and SQLCMD

I feel that it is wise move for a script to actually check itself that the database connection that is...