Archive

Archive for the ‘SQL Server Updates’ Category

SQL Server 2005 CU6 and SQL Server 2008 CTP6

February 19th, 2008 No comments

Microsoft just released SQL Server 2005 CU6, build 9.00.3228 (KB: 946608). Also a new community preview (CTP6) of the SQL Server 2008, build 10.00.1300.13,  is going to be available sometime this week from the Microsoft Connect web site (check often this link).

Categories: SQL Server Updates Tags:

SQL Server 2008 new RTM date

January 30th, 2008 No comments

It’s official. SQL Server 2008 RTM date slipped to Q3 CY2008. See details here. That means that with SQL Server 2000 mainstream support ending in April, SQL Server 2005 will be the only supported version for several months. I know that some SQL Server shops were planning so called ‘version-skip’ migration, i.e. go directly to SQL Server 2008 from 2000 (and SQL Server 2008 will support direct migration from SQL Server 2000). If you want to stay under Microsoft support that’s not an option anymore with the new RTM date.

Categories: SQL Server Updates Tags:

SQL Server 2008 CTP5 is available for download

November 20th, 2007 No comments

Latest version of the Microsoft SQL Server 2008 pre-release became available for download yesterday (11/19/2007).

Go ahead and get it from Microsoft Connect web site

Categories: SQL Server Updates Tags:

Microsoft SQL Server Books Online updates

November 18th, 2007 No comments

Microsoft issues updates to the SQL Server documentation, SQL Server Books Online (BOL), on a separate schedule than service packs and critical updates packages, here are the latest ones:

Categories: SQL Server Updates Tags:

Complete SQL Server builds list

November 11th, 2007 1 comment

This is a follow up to the previous post. There are several web sites that used to track SQL Sever build numbers. You can find one list for the SQL Server 2000 here and another, for the SQL Server 2005, here. There is a different source of the SQL Server 2005 builds here. These lists has not been updated for a long time, but are interesting from a historical perspective. Microsoft now maintains information about most recent builds at their support web site, so here they are:

2000 post-SP4 builds list: http://support.microsoft.com/kb/894905

2005 post-SP2 builds list: http://support.microsoft.com/kb/937137

This Microsoft support article, 321185, tells how to identify version of the installed SQL Server and also lists version build numbers for the SQL Server starting from version 6.5.

Categories: SQL Server Updates Tags:

How to install latest build of the SQL Server

November 9th, 2007 No comments

In used to be a very simple answer to the question, install Microsoft SQL Server RTM version (internal Microsoft name for the release version of the product – Release To Manufacturing), and on top of it install latest server pack. It’s not that simple any more if you would like to use the latest version on the product.

Current Microsoft policy for the SQL Server updates described at this KB article: http://support.microsoft.com/kb/935897 and is called an ISM (Incremental Servicing Model). In short there are GDR/CU (general distribution release/cumulative update) and OD/COD (on-demand/critical on-demand) incremental updates. GDR include service packs. GDR (2000 and 2005) and CU (2000 only) are normally available for free via Microsoft download center while CU, OD and COD (2005) have to be requested via support web site (it’s free and do not require support contract with Microsoft) and OD and COD (2000) are available from here and do require support contract with Microsoft.

In short:

SQL Server 2005:

SQL Server 2000:

With no SQL Server 2000 SP5 and SQL Server 2005 SP3 dates available yet, ISM is the only option to stay on top of SQL Server updates. Ones again a word of advise: test, test, test every update on you QA/Test server, before deploying in production.

I track latest CU builds form both SQL Server 2000 and 2005 with links to KB support articles, so come back often to stay on top of changes.

Categories: SQL Server Updates Tags: