Experience SQL Server 2005 Service Pack 2!

  • Article

 

-
Yesterday Microsoft has announced the release of SQL Server 2005 Service Pack 2.

  •  

  • SP2 is an important deliverable for SQL Server, providing support for Windows Vista and the 2007 Office System in addition to delivering important enhancements for customers.

  •  

  • What is new:

  •  

  • For a complete list on new or improved features in Analysis Services, Database Engine, Integration Services, Reporting Services, and Shared Tools, go to https://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm.

  •  

  • What's new Highlits:

  •  

  • Data Mining Add-ins for the 2007 Microsoft Office system enable data mining functionality from SQL Server Analysis Services (SSAS) to be used directly within Excel® 2007 and Visio® 2007.

    SQL Server Reporting Services (SSRS) compatibility with Microsoft Office SharePoint® Server 2007 provides integration with the Report Center in SharePoint, enabling the seamless consumption and management of SSRS reports within SharePoint.

    SQL Server Analysis Services improvements for Excel 2007 and Excel Services relate to performance and functionality.

    Data compression (varDecimal) is an important feature for data warehousing scenarios, requiring less disk storage of decimal data and increasing overall performance.

    Manageability enhancements, based on customer feedback, provide management capabilities for database administrators such as improvements in database maintenance plans, enhanced management reports and a new copy database wizard.

    Management reports added to SQL Server Express Edition enable customers to get insights into the performance of their Express Edition and SQL Server Compact Edition databases.

    Interoperability improvements including Oracle support in the Report Builder feature enable customers to use its functionality on top of Oracle data sources. Customers also have access to SQL Server Reporting Services to build reports on top of Hyperion’s Essbase cubes.

  •  

  • To update SQL Server 2005 with Service Pack 2, go to https://www.microsoft.com/sql/sp2.mspx.

  •  

  • I'll do it today, and keep you up to date with my SQL Server 2005 SP2 experience!