Microsoft SQL Server 2008 R2 Unleashed- P10:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 44 CHAPTER 2 What s New in SQL Server 2008 sources. PowerPivot for SharePoint extends SharePoint 2010 and Excel Services to add server-side processing collaboration and document management support for the PowerPivot workbooks that you publish to SharePoint. Together the PowerPivot client add-in and server components provide an end-to-end solution that furthers business intelligence data analysis for Excel users on the workstation and on SharePoint sites. For more information on PowerPivot see Chapter 51 Analysis Services. New Reporting Services Features SQL Server 2008 R2 introduces a number of new features for Reporting Services. The Reporting Services enhancements are probably the most significant aspect of the R2 release. One of the key changes in SQL Server 2008 R2 is an updated version of the Report Manager. The SQL Server 2008 R2 Report Manager provides an improved user experience via interface changes including an updated color scheme and layout in an effort to provide easier navigation for managing report properties and Report Server items. Following are some of the key enhancements to Report Manager in R2 An improved workflow for viewing and managing reports and Report Server items through the use of a new drop-down menu to access various configuration options for each report or Report Server item in a folder Elimination of the need to render a report before accessing and configuring report properties when in default view Increased screen space for the Report Viewer when rendering reports An updated Report Viewer toolbar which includes some updates to the toolbar controls as well as the capability to export report data to an Atom service document and data feeds The set of new and enhanced features in SQL Server 2008 R2 for Reporting Services includes Report parts You can store these reusable report items on a Report Server or on a SharePoint site that is integrated with a Report Server. Sparklines and data bars These simple charts convey a lot of .
