Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Service Pack 4

By Steve Jones,

http://cdn-viper.demandvideo.com/media/963df1a3-07c1-4fb8-ae80-71bbcc6108f9/jpeg/b3c110fa-cbb7-498b-85db-961d9d392898_22.jpgJust last week I noticed that Cumulative Update 7 for Service Pack 3 was released by Microsoft, along with CU 17 for SP2. I was slightly surprised since I thought that the idea was for the SQL Server Release Services team to release one Service Pack a year while a product was being supported. With SP3 being released on Dec 15, 2008, I was assuming that an SP4 was in the works for about this time frame.

However I haven't heard a thing about either an SP4 for SQL Server 2005 or a SP2 for SQL Server 2008. With a (semi-) new version of SQL Server coming in about six months I can understand that SP4 might be a low priority, but I'd have expected to hear something about an SP2 around now dropping into Beta or CTP for some people to test.

I am slightly concerned that Microsoft, like many corporations, is quietly cutting budgets on items that don't drive revenue, and that we won't be seeing more service packs. I wouldn't be surprised to have them bail on SP2 for SQL Server 2008 as well, and quietly just push SQL Server 2008 R2 as "the solution" for people to use.

I don't think that's acceptable and neither should you. Already so many people believe that they shouldn't install a Microsoft product, including SQL Server, until SP1 is released. While the quality of the product goes up, forgoing additional service packs will give people more reasons to look to other products instead of SQL Server.

Release Services has done a great job of getting CUs out every other month. However many companies can't test all those, and they don't want to install lightly tested patches. The KB itself for CU7 says (emphasis mine)

"A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2005 service pack that contains the hotfixes in this cumulative update package. "

To me that implies that there is another service pack coming. So where is it? Every product from Microsoft that receives CUs and SPs should end with a final service pack before it goes out of mainstream support. If SQL Server 2005 is going to drop out of support, shouldn't there be one final Service Pack that rolls up all patches?

If you want SP4 for SQL Server 2005, go ahead and vote for it on this Connect item. If you want to be sure that your SQL Server 2008 systems continue to be properly patched, vote for SP2 for SQL Server 2008 here on Connect.

Steve Jones

Total article views: 662 | Views in the last 30 days: 2
 
Related Articles
BLOG

Microsoft Releases SQL Server 2008 SP3 RTM

Microsoft has released the final, RTM version of SQL Server 2008 Service Pack 3. This is build 10.00...

BLOG

Microsoft SQL Server Denali CTP 3 Product Guide

Microsoft has released a Product Guide for SQL Server Denali CTP3, which has datasheets, white paper...

BLOG

SQL Server 2012 Service Pack 1 Released

Microsoft has released SQL Server 2012 Service Pack 1 for general availability. SQL Server 2012 SP1 ...

ARTICLE

Service Pack 2 for SQL Server 2000 Released

Here we go again! Microsoft has released service pack 2 this week, which is much more tame than serv...

BLOG

SQL Server 2005 Service Pack 4 RTM Released

Last Friday afternoon (December 17, 2010), Microsoft released the final RTM build of Service Pack 4 ...

Tags
database weekly    
editorial    
service packs    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones