Monday, October 24, 2011

Service Pack 2 for MS Sql 2008 is it worth it?

What's New:
Reporting Services in SharePoint Integrated
Mode. SQL Server 2008 SP2 provides updates for Reporting Services
integration with SharePoint products. SQL Server 2008 SP2 report servers can
integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new
add-in to support the integration of SQL Server 2008 R2 report servers with
SharePoint 2007 products. For more information see the “What’s New in SharePoint
Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What's New (Reporting
Services)
.
SQL Server 2008 R2 Application and Multi-Server Management Compatibility
with SQL Server 2008.
SQL Server 2008 Instance Management.With SP2 applied, an instance of
the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2
Utility Control Point as a managed instance of SQL Server. For more information,
see Overview of SQL
Server Utility
in SQL Server 2008 R2 Books Online.
Data-tier Application (DAC) Support.Instances of the SQL Server 2008
Database Engine support all DAC operations delivered in SQL Server 2008 R2 after
SP2 has been applied. You can deploy, upgrade, register, extract, and delete
DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You
must use the SQL Server 2008 R2 client tools, such as SQL Server Management
Studio, to perform DAC operations. A data-tier application is an entity that
contains all of the database objects and instance objects used by an
application. A DAC provides a single unit for authoring, deploying, and managing
the data-tier objects. For more information, see Designing and Implementing
Data-tier Applications.

No comments:

Post a Comment