Monthly Archives: February 2007

Useful New SQL Server 2005 SP2 Feature

Posted on February 19, 2007 by Glenn Berry

One new feature in SQL Server 2005 SP2 is Scripting Options. If you look under Tools, Options in SQL Server Management Studio (SSMS), you will see the dialog shown below: This lets you target SQL 2000 or 2005, and you … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Surviving WWII German Tanks

Posted on February 19, 2007 by Glenn Berry

Someone has compiled a nice PDF document showing photos and short explanations for nearly all the the known surviving Panther family tanks that are in various museums and collections around the world. Here is a link with a list of … Continue reading →

Posted in Hobbies | 7 Comments

SQL Server 2005 BPA CTP

Posted on February 19, 2007 by Glenn Berry

Microsoft’s Paul Mestemaker posted today about how the CTP for the SQL Server 2005 Dest Practices Analyzer (BPA) will be available "soon".  I certainly hope so. The SQL Server 2000 BPA was a great tool. I have heard that the … Continue reading →

Posted in SQL Server 2005 | 3 Comments

Microsoft Releases SQL Server 2005 SP2

Posted on February 19, 2007 by Glenn Berry

As Mary Jo Foley predicted on Friday, Microsoft released SQL Server 2005 SP2 for download today. The x86 version is 282MB and the x64 version is 339MB.  This updates SQL Server 2005 to version 9.0.3042. The KB 921896 article with the … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Lots of SQL Server Product Team blogs

Posted on February 18, 2007 by Glenn Berry

  Microsoft’s Paul Randal has compiled a list of over 40 public blogs from the SQL Server Product team. Lots of good stuff! Technorati Tag: SQL Server

Posted in SQL Server 2005 | Leave a comment

Lies heard at Best Buy

Posted on February 18, 2007 by Glenn Berry

I was at my local Best Buy today, looking at laptop computers, since I saw a few fairly attractive looking deals in the Sunday ad insert. While I was checking some of the systems, I overheard a few interesting "facts" from … Continue reading →

Posted in Windows Vista | Leave a comment

More Worst President Ever

Posted on February 16, 2007 by Glenn Berry

It turns out that USA Today founder Al Neuharth agrees with my assessment that George W. Bush is the worst President ever.

Posted in News and politics | Leave a comment

SQL Server 2005 SP2 on February 19?

Posted on February 16, 2007 by Glenn Berry

Mary Jo Foley is reporting that word is out that SQL Server 2005 SP2 will "most likely be available" on February 19. Her stated source is Russell Christopher’s blog. A lot of the focus for SP2 was on improving Analysis … Continue reading →

Posted in SQL Server 2005 | Leave a comment

High Volume Update Performance Benchmarks

Posted on February 16, 2007 by Glenn Berry

Microsoft’s SQL Server Performance Blog has a very interesting post today about different methods for updating several VARCHAR columns and one DATETIME column on a 500 million row table, using a very beefy 16 CPU server with 128GB of RAM. It … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Tulsa CPU (Xeon 7140) Goodness is Here!

Posted on February 16, 2007 by Glenn Berry

After literally months of justification and begging, I finally see the picture below:   This is properly known and the Intel Xeon MP 7140 CPU, which runs at 3.4GHz, and has two 1024K L2 caches, and a 16MB L3 cache. … Continue reading →

Posted in SQL Server 2005 | 5 Comments