Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

SQL Server 2008 R2 November 2009 CTP3 now available

Posted by denglishbi on November 11, 2009

Yesterday the November CTP3 of SQL Server 2008 R2 was released to the MSDN and TechNet subscribers.  Tomorrow the public release will be made available on the R2 site here – http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx.  So what has changed since the August release?  Well some of the big items are with SSRS with the addition on the Report Part Gallery, shared datasets, additional data visualizations with the sparklines, data bars, and indicators, and support for 2008 and 2008 R2 deployments in BIDS and the other thing will be the additional of Master Data Services and then PowerPivot for SharePoint 2010 and SharePoint management.

Master Data Services is a separate install in folder at the root of the install image.


Here is the link to the BOL documentation for all of the new features, enhancements, and the untouched items:

What’s New (SQL Server 2008 R2) – http://msdn.microsoft.com/en-us/library/bb500435(SQL.105).aspx

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.

New in this Release

  • Master Data Services
    Master Data Services is comprised of a database, configuration tool, Web application, and Web service that you use to manage your organization’s master data and maintain an auditable record of that data as it changes over time. You use models and hierarchies to group and organize data to prepare it for further use in business intelligence and reporting tools, data warehouses, and other operational systems. Master Data Services integrates with source systems and incorporates business rules to become the single source of master data across your organization.
  • PowerPivot for SharePoint
    PowerPivot for Excel and PowerPivot for SharePoint are client and server components that integrate Analysis Services with Excel and SharePoint. You use PowerPivot for Excel to create PowerPivot workbooks that assemble and relate large amounts of data from different sources. On a SharePoint farm, PowerPivot for SharePoint adds shared services and infrastructure for querying and managing PowerPivot workbooks that you publish to SharePoint.
  • Multi-Server Administration and Data-Tier Application
    The SQL Server Utility forms a central repository for performance data and management policies that tailor the operation of instances of the Database Engine that have been enrolled in the utility. It also includes a Utility Explorer for centralized management, and dashboards that report the state of the managed instances. A data-tier application (DAC) forms a single unit for developing, deploying, and managing the database objects used by an application.

Enhanced in this Release

  • What’s New in SQL Server Installation
  • What’s New (Database Engine)
  • What’s New (Reporting Services)
    Reports can now include maps, Sparklines, 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, SharePoint lists as data sources, and local mode report viewing with Access Services and SharePoint lists.

Unchanged in this Release

Some blogs to check out in regards to the SSRS new features are:

I still haven’t seen the download or release of the PowerPivot components, probably waiting for the public release of Office 2010 and SharePoint 2010, so stay tuned.

UPDATE (11/11/2009): The public download is now available on the MSDN downloads here:



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: