News Stay informed about the latest enterprise technology news and product updates.

New service pack coming for SQL Server 2005

The Microsoft SQL Server product team has promised a cumulative rollup for its current database release.

IT shops running SQL Server 2005 Service Pack 2 can expect to see a third service pack sometime later this year.

According to Francois Ajenstat, Microsoft's director of SQL Server marketing, the company agreed to release another service pack sometime after the release of SQL Server 2008 in the third quarter of this year.

Unlike previous SQL Server service packs, which offered major features on occasion, SQL Server 2005 SP3 will merely roll up numerous cumulative updates.

SQL Server 2008 will include business intelligence features, but the main attraction for IT managers is likely to be a feature that lets administrators set one application policy across all servers, versus performing such tasks on each particular instance of a database, according to the company.

More on SQL Server
SQL Server 2008 aims to simplify the mundane
Microsoft showcased SQL Server 2008 in February during the launch of Windows Server 2008. Some of its other features include a data mining add-in tool that can be used directly from Excel. SQL Server Reporting Services will be integrated with SharePoint.

One expert said that Microsoft's decision to release a new service pack for SQL Server 2005 is great news for the thousands of companies not yet ready to advance to SQL Server 2008.

"While SQL Server 2008 has many compelling features [for IT executives to] seriously consider migrating from SQL Server 2005, many companies cannot justify the cost and effort to move to the new platform, especially if they only recently migrated to 2005," said Roman Rehak, a SQL Server MVP and president of the Vermont SQL Server User's Group.

SQL Server 2005 SP3 will also be helpful for IT shops and third-party vendors in terms of their receipt of third-party support. Often, whether or not an IT shop is running the latest service pack is the criteria for receiving support from those vendors, said Rick Heiges, senior solutions consultant for Scalability Experts Inc., a consulting firm based in Coppell, Texas.

"Microsoft has issued seven cumulative updates [for SQL Server 2005]," Heiges said. "[Third-party vendors] don't treat them with as much authority as a [service pack] release."

Dig Deeper on Windows client management

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.