Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

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

Brief Description
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.

On This Page

Quick Details
File Name:WhatsNewNovemberCTP.doc
Version:1.0
Date Published:11/9/2009
Language:English
Download Size:75 KB
Estimated Download Time: 1 min 56K

Change Language:
  

Overview

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.

 Top of page

System Requirements

  • 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
• 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.

 Top of page

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.

 Top of page

 Top of page


© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement