SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Regular Service

By Steve Jones,

http://www.automotivetraveler.com/images/stories/blogs/brandys/081121-02-GM_Check_Oil.jpgI'm fairly consistent in getting my cars serviced. I get the oil changed regularly, tires rotated, and try to keep up any maintenance items that I think will help the car run safely for a long time. It just seems like a good idea to me, despite the fact that I don't always see a direct benefit from changing the oil or moving tires from one end of the car to the other.

I was having a mini-debate recently with a few people about Service Pack 2 for SQL Server 2008. No, you haven't missed anything. It's not out yet, but I had commented that it was late. With Service Pack 1 being released in February of 2009, I was expecting Service Pack 2 to come out in February or March of this year. Seeing as how it's late April and there hasn't been a beta or CTP, I'm not expecting SP2 until later this year, which to me, is late.

A few people responded that they didn't think it much mattered. There were no critical bugs in place and if you needed something patched you could use a Cumulative Update (CU). After all, those are stable, aren't they?

I've heard quite a few people inside and outside of Microsoft say they trust the CUs are well written and stable. If CUs are stable, then how hard is it to roll them up and run regression tests? If it's hard, then are they that stable? It was the plan for Microsoft to just continue to release CUs for SQL Server 2005 until you voted 1100 times that you'd like to see SP4 for SQL | Server 2005.

My feeling is that we ought to get regular servicing from Microsoft on their products, especially with the end-of-support for various SP levels. We all know that the product is not completely finished and polished when it is released, and Service Packs are the way that many of us use to perform that regular servicing.

Or are they?

I'm wondering if those of you out there working with instances, do you want regular service packs? Or do you not worry about patches and just apply CUs if something breaks? Do you think that Microsoft should commit, in writing, when we fork over the money for their products, to provide yearly service packs? Take 10 seconds and let us know. I'm happy to admit I'm wrong if you disagree. I just don't think I am.

Take 2 minutes and let us know what you want.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Total article views: 93 | Views in the last 30 days: 1
Related Articles

Reg. Upgrade Sql Server 2005 RTM to stable version

Upgrade RTM to Stable version


Technical Podcasts I Listen To

There are a few podcasts I tend to listen to as I have time. Since I work with a wide...


Podcast Announcements

Podcast Feeds


Microsoft Analysis Service Issue

Microsoft Analysis Service Issue


How Stable is SQL Server 2005?

I've been calling for Service Pack 3 and I've been debating the need, the criticality, and even the ...

service packs