Menu
Microsoft releases SQL Server 2005 Service Pack 2

Microsoft releases SQL Server 2005 Service Pack 2

Microsoft is emphasizing new business intelligence capabilities inside Service Pack 2 for SQL Server 2005, a free upgrade available for download on Tuesday.

Microsoft released Service Pack 2 (SP2) for SQL Server 2005 on Tuesday, a free upgrade available for download, in addition to new virtualization licensing for the database.

Microsoft said it will allow unlimited virtual instances of the SQL Server SP2 database to run on servers that are fully licensed for SQL Server 2005 Enterprise Edition.

Enterprises are exploring virtualization technology -- which allow multiple copies of an OS to run on one piece of hardware -- to reduce the number of physical servers and increase their utilization.

The free upgrade for the company's popular database product also includes better interoperability with other vendors. One SQL Server 2005 feature, called Report Builder, can build customized reports drawn on data held in Oracle products and Hyperion Solutions's Essbase database, Microsoft said.

SQL Server 2005 SP2 will be the only release of the database that Microsoft will support for its Windows Vista OS and upcoming Longhorn server, due for a final release in the second half of this year.

Other features of SP2 include:

-- Add-ins for Office 2007 programs such as Excel and Visio -- a drawing and diagramming application -- will enable data mining using SQL Server Analysis Services, the database's online analytical processing component.

-- SQL Server Reporting Services -- a tool for creating and managing reports -- is integrated with SharePoint, the company's portal building and document-sharing software.

-- New management tools include improved database maintenance, enhanced management repots and a new copy database wizard.

Microsoft also announced new management reports for SQL Server Express Edition, the free version of the database, and SQL Compact Edition, an embedded database for mobile devices such as tablet PCs and smart phones.


Follow Us

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Featured

Slideshows

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners

This year’s Reseller News 30 Under 30 Tech Awards were held as an integral part of the first entirely virtual Emerging Leaders​ forum, an annual event dedicated to identifying, educating and showcasing the New Zealand technology market’s rising stars. The 30 Under 30 Tech Awards 2020 recognised the outstanding achievements and business excellence of 30 talented individuals​, across both young leaders and those just starting out. In this slideshow, Reseller News honours this year's winners and captures their thoughts about how their ideas of leadership have changed over time.​

Meet the Reseller News 30 Under 30 Tech Awards 2020 winners
Reseller News Exchange Auckland: Beyond the myths — how partners can master cloud security

Reseller News Exchange Auckland: Beyond the myths — how partners can master cloud security

This exclusive Reseller News Exchange event in Auckland explored the challenges facing the partner community on the cloud security frontier, as well as market trends, customer priorities and how the channel can capitalise on the opportunities available. In association with Arrow, Bitdefender, Exclusive Networks, Fortinet and Palo Alto Networks. Photos by Gino Demeer.

Reseller News Exchange Auckland: Beyond the myths — how partners can master cloud security
Reseller News welcomes industry figures at 2020 Hall of Fame lunch

Reseller News welcomes industry figures at 2020 Hall of Fame lunch

Reseller News welcomed 2019 inductees - Leanne Buer, Ross Jenkins and Terry Dunn - to the fourth running of the Reseller News Hall of Fame lunch, held at the French Cafe in Auckland. The inductees discussed the changing face of the IT channel ecosystem in New Zealand and what it means to be a Reseller News Hall of Fame inductee. Photos by Gino Demeer.

Reseller News welcomes industry figures at 2020 Hall of Fame lunch
Show Comments