• Article

New and Updated Content in SQL Server 2008 R2 Books Online

The following technologies and categories have had new topics added or existing topics updated with significant changes in SQL Server 2008 R2 Books Online or related content of different types has been created.

  • Analysis Services (Data Mining)

  • Analysis Services (PowerPivot)

  • Database Engine

  • Integration Services

  • Master Data Services

  • Replication

  • Reporting Services

  • SQL Server

Database Engine

New Topics

Creating Linked Servers (SQL Server Database Engine)

dbo.sysdac_packages (Transact-SQL)

Moving a TDE Protected Database to Another SQL Server

dbo.sysdac_parts (Transact-SQL)

Updated Topics

cdc.<capture_instance>_CT (Transact-SQL)

Configuring Web Synchronization

Deprecated Database Engine Features in SQL Server 2008 R2

DBCC CHECKDB (Transact-SQL)

Deprecated Management Tools Features in SQL Server 2008 R2

How to: Allow Database Mirroring to Use Certificates for Outbound Connections (Transact-SQL)

How to: Allow Non-Administrators to Use Replication Monitor (SQL Server Management Studio)

How to: Delete a Data-tier Application

How to: Deploy a Data-tier Application

How to: Extract a DAC From a Database

How to: Register a Database As a DAC

How to: Upgrade a Data-tier Application

Isolation Levels in the Database Engine

Obtaining Changes by Using the Change Tracking Functions

Partitioned Table and Index Concepts

Rebuilding System Databases

Replicating Partitioned Tables and Indexes

SQL Server Management Studio Database Engine Query Editor Window

sysdac_history_internal (Transact-SQL)

sys.sp_cdc_stop_job (Transact-SQL)

transform noise words Option

Understanding Data-tier Applications

Master Data Services

New Topics

Annotations (Master Data Services)

How to: Annotate a Member (Master Data Services)

How to: Annotate a Transaction (Master Data Services)

How to: Reverse a Transaction (Master Data Services)

Model Deployment Package XML Schema (Master Data Services)

Navigational Access (Master Data Services)

Reserved Words (Master Data Services)

Troubleshooting Master Data Manager Security

Transactions (Master Data Services)

Updated Topics

Troubleshooting Installation and Configuration Issues (Master Data Services)

Database Logins, Users, and Roles (Master Data Services)

How Permissions Are Determined (Master Data Services)

How to: Change a Version Name (Master Data Services)

Overlapping Model and Member Permissions (Master Data Services)

Overlapping User and Group Permissions (Master Data Services)

System Settings (Master Data Services)

User-Defined Metadata (Master Data Services)

Web Application Requirements (Master Data Services)

New TechNet Wiki Articles

Troubleshooting Master Data Services Database Restore

Reporting Services

New Topics

PowerPivot Connection Type (SSRS)

Creating the Report Server Project and the AdventureWorks2008R2_Base Report (SSRS)

Lesson 1: Creating Shared Datasets and Configuring Report Parameters (SSRS)

Lesson 2: Adding Line and Sparkline Charts (SSRS)

Lesson 3: Adding a Matrix, Variables, and Indicators as KPIs (SSRS)

Lesson 4: Adding Column and Databar Charts (SSRS)

Report Design Tips (Report Builder 3.0 and SSRS)

Tutorial: Introducing Expressions

Where to find the Reporting Services add-in for SharePoint Products

Updated Topics

Considerations for Upgrading Reporting Services

Creating a Report Model Project

Creating the Customers_Near_Stores_2008R2 Report (SSRS)

Creating the Employee_Sales_Summary_2008R2 Report (SSRS)

Creating the Sales_by_Region_2008R2 Report (SSRS)

Creating the Sales_Order_Detail_2008R2 Report (SSRS)

Creating the Store_Contacts_2008R2 Report (SSRS)

Deployment Topologies for Reporting Services in SharePoint Integrated Mode

Exporting to Microsoft Excel (Report Builder 3.0 and SSRS)

Exporting to Microsoft Word (Report Builder 3.0 and SSRS)

Finding, Viewing, and Managing Reports (Report Builder 3.0 and SSRS)

How to: Configure Report Builder Access

How to: Connect to a Report Server in Management Studio

How to: Install a SharePoint Web Front-end on a Report Server Computer

How to: Install and Configure SharePoint Integration on a Stand-alone Server

How to: Install and Configure SharePoint Integration on Multiple Servers

How to: Install a SharePoint Web Front-end on a Report Server Computer

How to: Install or Uninstall the Reporting Services Add-in

HTML Device Information Settings

Lesson 3: Defining a Data Source View for Your Report Model

Overview of Reporting Services and SharePoint Technology Integration

RSReportServer Configuration File

Security Overview for Reporting Services in SharePoint Integrated Mode

Setting Time-out Values for Report and Shared Dataset Processing (SSRS)

Troubleshooting (SSRS in SharePoint Integrated Mode)

Troubleshooting (SSRS)

Troubleshooting Concepts (Reporting Services)

Tutorials (Report Builder 3.0)

Tutorials: Creating AdventureWorks 2008R2 Sample Reports (SSRS)

Where to find the Reporting Services add-in for SharePoint Products

New Samples

Embedded Reporting: ReportViewer Samples

(SSRS) Reporting Services Samples on CodePlex

New TechNet Wiki Articles

How to rebuild the report server performance counters (SSRS)

SQL Server Reporting Services (SSRS): A list of general troubleshooting topics

SQL Server Reporting Services (SSRS): A list of troubleshooting topics specific to SharePoint integrated mode

Troubleshooting SQL Server 2008 R2 Reporting Services AdventureWorks Sample Reports