What's New (SQL Server 2008 R2)
In Microsoft SQL Server 2008 R2, several components have new or improved features. Other components have not changed since SQL Server 2008. Those components offer features that were new or enhanced in that release.
For a list of topics that have been recently added or updated to Books Online, see New and Updated Content in SQL Server 2008 R2 Books Online.
Reports can now include maps, sparklines, data bars, and indicators to depict data. Report parts enable collaboration through shared datasets, report items, and data regions that are centrally stored and managed. Dataset query results can be cached on first use or by schedule. SharePoint integration supports multiple SharePoint Zones, SharePoint Universal Logging, and local mode report viewing with Access Services and SharePoint lists. SharePoint lists, SQL Server 2008 R2 Parallel Data Warehouse, and SQL Azure Database can be used as data sources for reports.