SQL Server 2008 SP1 setup is a little confused

Of course, it is always annoying when we have to restart a machine or stop a service to service software.  I get annoyed when little updates to non-integral pieces of Windows prompt me to reboot; leave me alone and force me to reboot when you actually need those files.  Or […]

SQL Server 2008 Service Pack 1 : CTP is available!

Yes, you read that right; for those of you waiting to try SQL Server 2008 until SP1 is available, we are one step closer.  You can download the CTP from the following URL: http://microsoft.com/downloads/details.aspx?FamilyID=6f26fc45-f0ca-49cf-a6ee-840c7e8bb8af The CTP will bring your instance to build # 10.00.2520. Thumbs up on finally adding slipstream […]

The XP SP3 / MSXML6 SP2 / SQL Server debacle

I see fingers pointing all over the place.  The Windows team blames the SQL team for making setup packages that can't bypass when a newer version of a file already exists on the target system.  The SQL team blames Windows for unceremoniously plopping the core MSXML files into the Windows […]

SQL Server 2005 : Comparing SP2 CU#12 and SP3 CU#2

The recent release of security fixes for SQL Server 2000 and 2005 (the issue did not impact SQL Server 2008) announced in MS09-004 seemed to spur two SQL Server 2005 cumulative updates (CUs) earlier this week — one for those on SP2, and one for those on SP3.  (This typically […]

Requesting your input on Resource Governor

I am writing a whitepaper, and planning more presentations, on using Resource Governor in SQL Server 2008, and am looking for your feedback on making both of these more complete and relevant to real-world implementations — since 99% of my usage of the feature so far has been mostly academic.  […]

SQL Server 2008 Books Online update, January 2009, is available

An update to SQL Server 2008 Books Online has been published to TechNet and MSDN.  It will show up on Microsoft Update within a few weeks.  You can see the list of new and updated topics here: http://msdn.microsoft.com/en-us/library/dd408738.aspx And if you don't want to wait for Windows Update, you can […]