
Contents
CHAPTER 1 SQL Server 2008 R2 Editions and Enhancements
- SQL Server 2008 R2 Enhancements for DBAs.
- Application and Multi-Server Administration Enhancements
- Additional SQL Server 2008 R2 Enhancements for DBAs
- Advantages of Using Windows Server 2008 R2 .
- SQL Server 2008 R2 Editions.
- Premium Editions
- Core Editions
- Specialized Editions
- Hardware and Software Requirements.
- Installation, Upgrade, and Migration Strategies.
- The In-Place Upgrade
- Side-by-Side Migration
CHAPTER 2 Multi-Server Administration 21
- The SQL Server Utility.
- SQL Server Utility Key Concepts
- UCP Prerequisites
- UCP Sizing and Maximum Capacity Specifications
- Creating a UCP .
- Creating a UCP by Using SSMS
- Creating a UCP by Using Windows PowerShell
- UCP Post-Installation Steps
- Enrolling SQL Server Instances.
- Managed Instance Enrollment Prerequisites
- Enrolling SQL Server Instances by Using SSMS
- Enrolling SQL Server Instances by Using Windows PowerShell
- The Managed Instances Dashboard
- Managing Utility Administration Settings
- Connecting to a UCP
- The Policy Tab
- The Security Tab
- The Data Warehouse Tab
CHAPTER 3 Data-Tier Applications
- Introduction to Data-Tier Applications.
- The Data-Tier Application Life Cycle
- Common Uses for Data-Tier Applications
- Supported SQL Server Objects
- Visual Studio 2010 and Data-Tier Application Projects.
- Launching a Data-Tier Application
- Project Template in Visual Studio 2010
- Importing an Existing Data-Tier
- Application Project into Visual Studio 2010
- Extracting a Data-Tier Application with
- SQL Server Management Studio.
- Installing a New DAC Instance with the
- Deploy Data-Tier Application Wizard.
- Registering a Data-Tier Application.
- Deleting a Data-Tier Application.
- Upgrading a Data-Tier Application.
CHAPTER 4 High Availability and Virtualization Enhancements
- Enhancements to High Availability with Windows Server 2008 R2.
- Failover Clustering with Windows Server 2008 R2.
- Traditional Failover Clustering
- Guest Failover Clustering
- Enhancements to the Validate A Configuration Wizard
- The Windows Server 2008 R2 Best Practices Analyzer
- SQL Server 2008 R2 Virtualization and Hyper-V.
- Live Migration Support Through CSV
- Windows Server 2008 R2 Hyper-V System Requirements
- Practical Uses for Hyper-V and SQL Server 2008 R2
- Implementing Live Migration for SQL Server 2008 R2.
- Enabling CSV
- Creating a SQL Server VM with Hyper-V
- Configuring a SQL Server VM for Live Migration
- Initiating a Live Migration of a SQL Server VM
CHAPTER 5 Consolidation and Monitoring
- SQL Server Consolidation Strategies.
- Consolidating Databases and Instances
- Consolidating SQL Server Through Virtualization
- Using the SQL Server Utility for Consolidation and Monitoring .
- Using the SQL Server Utility Dashboard.
- Using the Managed Instances Viewpoint .
- The Managed Instances List View Columns
- The Managed Instances Detail Tabs
- Using the Data-Tier Application Viewpoint .
- The Data-Tier Application List View
- The Data-Tier Application Tabs
CHAPTER 6 Scalable Data Warehousing
- Parallel Data Warehouse Architecture .
- Data Warehouse Appliances
- Processing Architecture
- The Multi-Rack System
- Hub-and-Spoke Architecture
- Data Management.
- Shared Nothing Architecture
- Data Types
- Query Processing
- Data Load Processing
- Monitoring and Management.
- Business Intelligence Integration.
- Integration Services
- Reporting Services
- Analysis Services and PowerPivot
CHAPTER 7 Master Data Services
- Master Data Management .
- Master Data Challenges
- Key Features of Master Data Services
- Master Data Services Components.
- Master Data Services Configuration Manager
- The Master Data Services Database
- Master Data Manager
- Data Stewardship .
- Model Objects
- Master Data Maintenance
- Business Rules
- Transaction Logging
- Integration.
- Importing Master Data
- Exporting Master Data
- Administration.
- Versions
- Security
- Model Deployment
- Programmability.
- The Class Library
- Master Data Services Web Service
- Matching Functions
CHAPTER 8 Complex Event Processing with StreamInsight
- Complex Event Processing.
- Complex Event Processing Applications
- StreamInsight Highlights
- StreamInsight Architecture.
- Data Structures
- The CEP Server
- Deployment Models
- Application Development.
- Event Types
- Adapters
- Query Templates
- Queries
- Query Template Binding
- The Query Object
- The Management Interface.
- Diagnostic Views
- Windows PowerShell Diagnostics
CHAPTER 9 Reporting Services Enhancements
- New Data Sources.
- Expression Language Improvements.
- Combining Data from More Than One Dataset
- Aggregation
- Conditional Rendering Expressions
- Page Numbering
- Read/Write Report Variable
- Layout Control.
- Pagination Properties
- Data Synchronization
- Text Box Orientation
- Data Visualization.
- Data Bars
- Sparklines
- Indicators
- Maps
- Reusability.
- Shared Datasets
- Cache Refresh
- Report Parts
- Atom Data Feed
- Report Builder 3.0.
- Edit Sessions
- The Report Part Gallery
- Report Access and Management.
- Report Manager Improvements
- Report Viewer Improvements
- Improved Browser Support
- RDL Sandboxing
- SharePoint Integration.
- Improved Installation and Configuration
- RS Utility Scripting
- SharePoint Lists as Data Sources
- SharePoint Unified Logging Service
CHAPTER 10 Self-Service Analysis with PowerPivot
- PowerPivot for Excel.
- The PowerPivot Add-in for Excel
- Data Sources
- Data Preparation
- PowerPivot Reports
- Data Analysis Expressions
- PowerPivot for SharePoint.
- Architecture
- Content Management
- Data Refresh
- Linked Documents
- The PowerPivot Web Service
- The PowerPivot Management Dashboard.