Monthly Archive: December 2008

More updates for SQL Server 2005 Service Pack 3

More updates for SQL Server 2005 Service Pack 3

As promised, upon return from a trip to the frozen tundra of Northern Ontario, I am posting the latest updates from last week's release of SQL Server 2005 Service Pack 3.  For those who...

More info on SQL Server 2005 SP3 + Cumulative Updates

More info on SQL Server 2005 SP3 + Cumulative Updates

I recently posted about the availability of SQL Server 2005 SP3.  I have a bit more information about cumulative updates and the service pack, for those of you who might be confused about the...

SQL Server does not care about the order of your bulk file!

SQL Server does not care about the order of your bulk file!

I have seen several people make this assumption over the past few weeks, and thought I should write up a little something to drive the point home.  Primarily people are expecting to take a...

Pushing for more disclosure in DMVs

Pushing for more disclosure in DMVs

I have been involved in several discussions over the past week involving getting more diagnostic information out of the DMVs in SQL Server 2008 and beyond. Yesterday, I asked for procedure recompiles to be...

SQL Server 2005 SP3 is available!

SQL Server 2005 SP3 is available!

UPDATE 2008-12-16, from the team, regarding SP3 CU1: CU#1 on SP3 is nothing but a rollup of fixes from SP2 CU#10 and SP2 CU#11 that did not make it into SP3 release as these...

SQL Quiz : Career Challenges

SQL Quiz : Career Challenges

I was tagged by Denis Gobo to write a bog post about career challenges and how I overcame them.  I'm not going to tag anyone else because I can't seem to find anyone that...

SQL Server 2005 Books Online update (December 2008) now available

SQL Server 2005 Books Online update (December 2008) now available

Don't be fooled by the poor title on the page, which still says "SQL Server 2005 Books Online (September 2007)" (clearly a leftover from an earlier BOL update). The text under the overview section...

CU2 for SQL Server 2008 is missing!

CU2 for SQL Server 2008 is missing!

UPDATE 2008-12-03 The download packages for the database engine have returned to the download page.  Make sure you download the file labeled "SQL_Server_2008_Cumulative_Update_2" to apply to machines where the SQL Server engine is present,...