Microsoft Download Center Archive

What's New in SQL Server 2008 R2 November Community Technology Preview (CTP)

  • Published:
  • Version: 1.0
  • Category: Document
  • Language: English

This document describes what's new in the November CTP of Microsoft SQL Server® 2008 R2. Analysis Services, Database Engine, Reporting Services, and Service Broker all have new or enhanced features in this release. Master Data Services is a new component in this release.

  • SQL Server 2008 R2 November CTP has numerous new and enhanced features. This document provides the information you need to fully take advantage of these features.

    For Analysis Services, numerous enhancements have been added to the PowerPivot field list. These include automatic relationship detection when columns from unrelated tables are used in a PivotTable; support for searching fields by name; and support for named sets. Targeted support for additional data sources has also been added.

    For the Database Engine, manageability enhancements have been made. These include the ability to connect to SQL Azure; data-tier application upgrades; enhanced functionality for SQL Server Utility features; and deprecation of the VIA protocol. For Reporting Services, SharePoint integration has several new features. Additional enhancements include shared datasets and cache refresh plans; new data visualization report items; enhancements to Reporting Services features that were included in previous releases of SQL Server 2008; Business Intelligence Development Studio support for SQL Server 2008 reports and report server objects; and a new Web Service endpoint that can support management operations of the report server in both native mode and SharePoint integrated mode.

    For Service Broker, you now have the option to turn poison message handling on and off.

    Master Data Services is a new component. You use Master Data Services to manage your organization's master data, and to maintain a record of that data.


Status: Live

This download is still available on The downloads below will come directly from the Microsoft Download Center.

FileSHA1 HashSize
WhatsNewNovemberCTP.doc9269d1d294ed3b70706e403023f59bfb2ebfe3aa45 KB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows 7, Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Server 2008 R2, Windows Vista Service Pack 2, Windows XP Service Pack 3

  • • Supported Operating Systems: Windows 7; Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Server 2008 R2; Windows Vista Service Pack 2; Windows XP Service Pack 3

    • Microsoft Word 2003 or a later version.

Installation Instructions

  • 1. Click the Download button on this page to open the File Download dialog box.
    2. To open the file immediately, click Open. To save the file to a location on your hard disk, click Save.