SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: April 2007

Powered Down

We had a blizzard on Tuesday in Denver. Apr 24 and we got nearly a foot of snow out at the ranch.

We also lost power, which was a rude awakening. We had full laptop batteries, but no connectivity. I was taking kids to school and by the time I…

Read more

0 comments, 1,398 reads

Posted in The Voice of the DBA on 25 April 2007

Post SP2 Fixes

    I saw Brian's post on Microsoft's post on post sp2-fixes. Say that 10 times quickly.

They do a good job explaining it and I'm actually releasing a link Monday to it so people can understand what's going on and what they should install to be current.

The one thing…

Read more

0 comments, 1,336 reads

Posted in The Voice of the DBA on 13 April 2007

Not 4GB

Windows doesn't see 4GB. If you have a 32bit OS with 4GB of RAM, Windows can't see it all.

I saw this very interesting post from Hilton Locke at Microsoft on the issue. Apparently it's mostly hardware, depending on what you have, and an architectural decision that there are memory…

Read more

0 comments, 1,400 reads

Posted in The Voice of the DBA on 13 April 2007

The Data Warehouse Lifecycle Toolkit

    On a recommendation, I picked up this book by Ralph Kimball. I remember it coming out years ago and I saw a speech by one of the co-authors, Margy Ross. She was great and I thought DW would be great. Then I got sidetracked into the OLTP world with…

Read more

0 comments, 1,384 reads

Posted in The Voice of the DBA on 6 April 2007


I wrote a small commentary on quality control today and I'm surprised it didn't get more reaction.

I'm not a great tester and I'm sure I'd have missed these things as well, but there's no excuse for Microsoft, with a SQL Server team of hundreds, to not regression check everything…

Read more

0 comments, 1,402 reads

Posted in The Voice of the DBA on 6 April 2007

Hot Fixes

I wrote about Hot Fixes being inclusive of previous hot fixes. Someone questioned this and so I went back to Simon's blog and checked his source. He's a SQL Server MVP (and a great guy, I got to meet him at the Summit last year) and he got it from…

Read more

0 comments, 1,378 reads

Posted in The Voice of the DBA on 3 April 2007