This is a quick rewrite of the script I just posted a few days ago.  The script had a few flaws if trying to run it on a SQL 2005 box.  I have updated it to run against SQL 2005 and up.

This version is done using Dynamic SQL to… Read more

We have all heard that backup is not complete until you test it by restoring it.  We also know that part of a DR plan involves the testing of those backups through restores.

I recently had the opportunity to run through a test scenario and ran into a substantial failure.… Read more

Here are the most interesting people I met at PASS Summit 2012

Mickey Stuewe (sqlmickey)

Neil Hambly (neil_hambly)

Bob Hovious

Gail Shaw (sqlinthewild)

Ed Watson (SQLGator)

This is the short list of the many many many… Read more

Diligent DBAs like to check their databases for a little thing called corruption.  Some of those DBAs are masterful at keeping records and logging that the database was checked and came up with a clean bill of health.

There are many different ways of logging this kind of activity.  Today… Read more

Community – What is it?

Community is something that is improperly defined with words alone.  Community is best defined through first person experience.  Community is a feeling and a sense more than it is a definition in “pick your dictionary here.”

So how do you experience this thing we call… Read more

Will you be at Summit 2012?

I will be. I will even be pretty easy to find on multiple occasions.  If you haven’t seen my schedule already – you can check it out here. You’ll probably notice that there are a few times where I… Read more

In case you have been living under a rock (I know it’s not under my rock), here is your notice that Summit 2012 is just a few days away at this point.

I will soon be boarding a jet bound for Seattle for a week full of all things SQL.… Read more