Microsoft Corp has released a new service pack for its SQL Server 2005 database that will enable business intelligence customers to take advantage of new capabilities in the Vista operating system and Office 2007 desktop suite.
Key enhancements provided in the SP2 include new data mining add-ins for Office 2007 and tighter integration between SQL Server Reporting services and Office SharePoint Server 2007. The performance and scalability of SQL Server’s OLAP engine has also been fine-tuned.
The add-ins allow data-mining functionality included in SQL Server’s Analysis Services OLAP module to be accessed directly from Excel 2007 and Visio 2007 desktop tools. BI users can also tap into SharePoint Server’s ReportCenter module for sharing or reports.
Other enhancements offered by SP2 focus on data-compression, management, and interoperability.
A management-reporting capability has been added to SQL Server Express Edition, and links between SQL Server’s Report Builder and Oracle Corp and Hyperion Solutions Corp environments have also been tightened up. Users can now use Reporting Services to build reports on top of Hyperion’s Essbase OLAP database system.
As part of its SP2 launch, Microsoft is also expanding the virtualization capabilities of its database allowing for unlimited virtual instances on SQL Server 2005 Enterprise Edition server licenses.