LatenightDBA

SQL2008 Cumulative Update 1

2008-09-24T09:33:25Z

Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008.
Note This build of the cumulative update package is also known as build 10.00.1763.00.

Reference Article ID: 956717

http://support.microsoft.com/kb/956717/en-us

SQL2008 - RTM - Install woes

2008-08-06T18:21:41Z

Well the wait is over. SQL2008 is now RTM.

Now the fun begins, installation on my development machine. And would you know it - Failure :-(

Unable to to install SQL2008 as it was failing the VSShellInstalledRule setup check. NOTE:This error was also catching me even when BIDS was not selected from the setup options.

This rule checks for a previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008. Well I did install SP1 (Beta) and yes I did get caught out by the message "Install failed - rolling back" as documented on the download page.

Going through the SQL setup error logs I found where this was failing

Slp: Sco: Attempting to get registry value kind for value SP
Slp: Found Microsoft Visual Studio 2008 edition IDE, language 1033, SP level 1.

Perfect I thought, see I did install SP1 what's your problem...keep looking through error log and found this gem

Slp: Sco: Attempting to get registry value kind for value SP
Slp: Found Microsoft Visual Studio 2008 edition VSTS, language 1033, SP level 0.
Slp: Microsoft Visual Studio 2008 edition VSTS, language 1033 does not have required SP level. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008.

Ahh...the error I'm getting...It appears to me that SP1 & my 'playing' around only updates the reg key for the standard studio not team suite which is what I have installed.

So, updating the registry with the same values from the IDE Hive into the VSTS hive

SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0\VSTS

...re-run SQL final installation check & all things now progressing well. Time now to get going & setup my policies, some geo coding data and other good things SQL2008 has to offer....

Select @@version -- Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34

Microsoft Certified Master - SQL Server 2008

2008-07-04T05:49:39Z

Personally I have to say, it is better to be known as a Master than an Architect :-)

This certification is not for everyone and is not just a level above MCDBA. It is also not for the faint hearted, This is a course that does test you, 7 days a week, just like real life.

I totally enjoyed (in the same way a DBA enjoys a server crash - it's a challenge) my time during the 4 weeks at Redmond. I was fortunate enough to have a great collection of fellow students from around the globe that brought fantastic war stories and varied real world experiences. The course itself was delivered from veterans of the product itself not just another MCT (not to belittle MCT people & courses), the depth of content and of the questions being asked was not something that one could just gather from a text book and repeating from MOC. It is this part that will challenge the people running the program to enable it to scale to be available throughout the world.