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
Analysis Services (Data Mining)
New Topics
Capacity Specifications (Analysis Services - Data Mining)
Configure HTTP Access to SQL Server Analysis Services on IIS 7.0
Updated Topics
Cross-Validation Report (Analysis Services - Data Mining)
Cross-Validation (Analysis Services - Data Mining)
Filtering a Nested Table in a Mining Model (Intermediate Data Mining Tutorial)
Lesson 2: Adding Mining Models to the Time Series Mining Structure
Lesson 3: Processing the Time Series Structure and Models
Lesson 5: Extending the Time Series Model
Microsoft Clustering Algorithm Technical Reference
Microsoft Time Series Algorithm Technical Reference
Model Filter Syntax and Examples (Analysis Services - Data Mining)
Analysis Services (PowerPivot)
Updated Topics
Enable and Configure PowerPivot Data Refresh
Configure and Use the PowerPivot Unattended Data Refresh Account
Configure and Use the Stored Credentials for PowerPivot Data Refresh
New Videos
Database Engine
New Topics
Creating Linked Servers (SQL Server Database Engine)
dbo.sysdac_instances (Transact-SQL)
Updated Topics
cdc.<capture_instance>_CT (Transact-SQL)
Configuring Web Synchronization
Deprecated Database Engine Features in SQL Server 2008 R2
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: Upgrade a Data-tier Application (Database Engine)
Isolation Levels in the Database Engine
Obtaining Changes by Using the Change Tracking Functions
Partitioned Table and Index Concepts
Replicating Partitioned Tables and Indexes
SQL Server Management Studio Database Engine Query Editor Window
sysdac_history_internal (Transact-SQL)
Integration Services
Updated Topics
Adding Data Flow Components Programmatically
Behavior Changes to Integration Services Features in SQL Server 2008 R2
How to: Use the Values of Parent Variables in a Child Package
Introducing Business Intelligence Development Studio
New TechNet Wiki Articles
New Whitepapers
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)
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)
New TechNet Wiki Articles
Replication
New Topics
Updated Topics
Reporting Services
New Topics
PowerPivot Connection Type (SSRS)
Creating the Report Server Project and the AdventureWorks2008R2_Base Report
Lesson 1: Creating Shared Datasets and Configuring Report Parameters
Lesson 2: Adding Line and Sparkline Charts
Lesson 3: Adding a Matrix, Variables, and Indicators as KPIs
Lesson 4: Adding Column and Databar Charts
Report Design Tips (Report Builder 3.0 and SSRS)
Updated Topics
Considerations for Upgrading Reporting Services
Creating a Report Model Project
Creating the Customers_Near_Stores_2008R2 Report
Creating the Employee_Sales_Summary_2008R2 Report
Creating the Sales_by_Region_2008R2 Report
Creating the Sales_Order_Detail_2008R2 Report
Creating the Store_Contacts_2008R2 Report
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
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 Concepts (Reporting Services)
Tutorials (Report Builder 3.0)
Tutorials: Creating AdventureWorks 2008R2 Sample Reports
Where to find the Reporting Services add-in for SharePoint Products
New Samples
New TechNet Wiki Articles
SQL Server