This is the Trace Id: f6920bf680edd8d60501d62729e5f11d
Skip to main content Microsoft 365 Office Azure Copilot Windows Xbox Support Windows Apps OneDrive Outlook Moving from Skype to Teams OneNote Microsoft Teams Shop Xbox Accessories Xbox games Microsoft AI Microsoft Security Azure Dynamics 365 Microsoft 365 for business Microsoft Power Platform Windows 365 Digital Sovereignty Microsoft Developer Microsoft Learn Support for AI marketplace apps Microsoft Tech Community Microsoft Marketplace Software companies Visual Studio Free downloads & security Education Gift cards Licensing View Sitemap

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

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.

Important! Selecting a language below will dynamically change the complete page content to that language.

Download
  • Version:

    1.0

    Date Published:

    7/15/2024

    File Name:

    WhatsNewNovemberCTP.doc

    File Size:

    74.5 KB

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