Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 563 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, 546 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, 552 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, 536 reads

Posted in The Voice of the DBA on 6 April 2007

QA/QC

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, 566 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, 589 reads

Posted in The Voice of the DBA on 3 April 2007