Tech giant, Microsoft has finally released the Service Pack 2 for its most successful database software, SQL Server 2008. The service pack has been now made available to public after months of testing by the Microsoft Community. According to Microsoft, the SQL Server 2008 SP2 has registered major improvements which now include integration of reporting services with SharePoint products, improvements based from SQL Server community, and hotfix solutions provided in SQL Server 2008 SP1 Cumulative update 1 to 8.
Some key improvements made in Microsoft SQL Service 2008 Service Pack 2 include:
1. Reporting Services in SharePoint Integrated Mode:
The SQL Server 2008 SP2 now provides updates for Reporting Services integration with SharePoint products. The report servers would now be able to integrate with the SharePoint 2010 products. A new add-in has been added which supports the integration with SharePoint 2007 products also.
2. SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008:
After updating your SQL Server 2008 with Service Pack 2, the database engine can be enrolled with SQL Server 2008 Utility Control Point as a managed instance. It also enables organizations to extend the value of the Utility Control Point to instances of SQL Server 2008 SP2 with having to upgrade the servers.
The upgrade now offers support to Data-tier Application which supports instances of SQL Server 2008 Database Engine with all DAC operations. You can easily deploy, upgrade, register, extract and delete the DACs. The data-tier application is an entity which contains all of the database objects and instance objects used by an application.
Download SQL Server 2008 SP2 [here]
Download SQL Server 2008 SP2 Express [here]
Download SQL Server 2008 SP2 Feature Packs [here]