Assessing DB Changes

One of the things I teach in our admin course is that it's not enough to just be the gatekeeper/central...

Deleting Duplicates without a unique key

The following was sent to me by my friend and colleague Dave Miller:

Dave's Email:
Wanted to pass along something I hadn't...

Kindle - On the clock

In a week and a half, I start on the first of my four trips this year for work, and...

Taking Care of Employees - Storms

As I write this a tropical storm is passing over Orlando and has turned out to be milder than expected...

[Off Topic] The Big Apple

I got my first opportunity to visit New York City last week.  I was actually sitting in on a training...

SQLSaturday #8 in Orlando - Update (Aug 21)

Registration has been open for only a few weeks and we've got 110 registered so far, a nice start! We...

Troubleshooting High Connections & What's The Application Name?

I was visiting with a client recently when they asked me to come take a look at an incident in...

Notes on My Visit to the St Louis SQL Group

Actually it was subset of the group, but Kathi & Julie from the St Louis SQL Server User Group did a...

Speaker workshop

Andy Warren made a trip to St. Louis this past weekend to put on a speaker workshop for our user...

What every DBA that manages a large number of SQL Servers should know about SQL 2008!!

Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that...