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

Another Take on SP3 & Service Packs In General

Had lunch with a friend in the business yesterday that is involved with vulnerability scans for a large company and one of the things he discussed was that service packs are hard for them. On many of their servers they apply fixes of any type only if critical or fix an issue that is actually causing them pain, they prefer to avoid the remainder to reduce time and risk. The decision about whether to force users to apply a service pack is dependent on the security fixes rather than just being a standard/best practice, but that means they have to research the service pack deeply to figure out if security is involved or not.

The value in service packs regardless of platform is it quickly brings you close to being current. Slipstreaming the service pack into the install package makes installing go faster, one less step as the service pack is already applied. Aside from pure packaging, wouldn't a Windows Update mechanism work just as well? With Windows Update we can pick and choose our updates, but for the most part they just get applied. Are server updates any less risky than applying a patch to SQL? Do we expect everyone to more or less apply all the fixes that get generated for SQL? Some type of policy based application feels right. Let me set a policy based on criticality and whether it involves security, configure a delay before it's applied, and set a standard time to apply them. Would also be nice to know which patches require a reboot, those might get grouped differently.


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


Posted by duda on 24 February 2009

If one has an answer to this it would be valuable as I want to go to SP3 but I think it might be worth going 2k8. This is based on the fact that SP3 is still BETA(i might be wrong here)

Leave a Comment

Please register or log in to leave a comment.