Introduction to MS SQL Server 2008 R2

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.