Tip

SQL Server 2005 Service Pack 2 debugs and adds features

There's more to SQL Server 2005 Service Pack 2 than meets the eye. Microsoft has long struggled to find a way to add new features without releasing an entirely new version of the product. In Service Pack 1, we saw Microsoft fix database mirroring — a new feature for the 2005 release. It's debatable whether it was ultimately a new feature or simply servicing a current feature. The important issue is that Microsoft is changing the game from just servicing current features to servicing current features plus releasing new ones -- and that sends a mixed message to database administrators. The service pack should be fixing bugs and that's it. Now, they're fixing bugs and adding features, which may add more issues to fix down the road in yet another service pack.

There are 61 bugs being handled by Service Pack 2. A number of the bugs have been identified and handled by hot fixes. Some of the bugs are rather deep down and not very visible, while others are quite the opposite and problematic. I applaud Microsoft for handling so many bugs and working to increase product quality. But, at the same time, those of us on the frontlines will have to wade through the service packs and hope our systems remain functional. I don't think you should wait for the service pack to RTM before testing it.

Take a look at these resources to find out all the details about SP2:

  • Download

    Requires Free Membership to View

Besides the generally large number of bug fixes, Microsoft has made the service of the editions a bit more complex — especially with regard to SQL Server 2005 Express and SQL Server Express Advanced Edition. Since these two versions have a reduced set

Address more SQL Server 2005 upgrade concerns here:

of features, Microsoft chose to provide separate installers for each. At this time, Microsoft hasn't provided separate "What's new page/files" for each of these versions. It's easy enough to figure out though -- so the code base is the same.

Beyond the routine bug fixes, Microsoft has started releasing new features in the service packs. While most of the feature changes are small improvements, one change that will surely get noticed by organizations conforming to the Common Criteria will be the new sp_configure flag for "common criteria compliance enabled." This feature is only available to SQL Server Enterprise Edition users, but it signifies a major goal of the SQL Server product group -- to get SQL Server 2005 tested by the common criteria organization. I would look for Microsoft to make a PR splash about this at Service Pack 2's RTM.

And watch out. It looks like Microsoft is planning a new feature pack, as you'll see here under Database Engine.

Microsoft makes mention of a new feature pack to be released after SP2. The company really plans to keep IT pros on their feet.

With this latest service pack, Microsoft is biting off a lot. I expect many folks will hold off on deploying SP2, as if no application is experiencing the issues this service pack addresses. For many customers, the process of applying service packs is a challenge. If your organization is planning on an across-the-board upgrade to Office 2007 — including the MOSS (Microsoft Office SharePoint Server) 2007 technology — SP2 is a must have.

My resource at Microsoft tells me that SP2 will be delivered after Office 2007's RTM, so don't hold your breath … just keep swimming.

ABOUT THE AUTHOR:
Eric Brown is a senior consultant in the Business Intelligence national practice for Quilogy Inc. He works on emerging technologies and SQL Server 2005 and is the author of SQL Server 2005 Distilled (Microsoft Windows Server). Brown's career began in 1996 at Multiple Zones International. While there he realized the next big wave would be e-commerce and he raced to get a job at a dot-com. After working for three such companies, his acumen for databases and passion for technology landed him on the SQL Server Product Team at Microsoft, during which he ran Yukon readiness. Eventually, Brown wrote a book about SQL Server 2005. He has presented at Microsoft TechEd and has written several papers as well as a column in SQL Server Magazine.
Copyright 2006 TechTarget

This was first published in December 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.