Home / Microsoft EBooks / Introduction to MS SQL Server 2008 R2

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.
Download E-Book
Download E-Book

Leave a Reply

Your email address will not be published. Required fields are marked *

X
X