Microsoft SQL Server 2008 R2 Specifications download pdf (Page 18)

xviii Introduction

are improved with the introduction of the SQL Server Utility Control Point. Step-

by-step instructions show DBAs how to quickly designate a SQL Server instance as

a Utility Control Point and enroll instances for centralized multi-server manage-

ment. Chapter 3, “Data-Tier Applications,” focuses on how to streamline deploy-

ment and manage and upgrade database applications with the new data-tier ap-

plication feature. Chapter 4, “High Availability and Virtualization Enhancements,”

covers high availability enhancements and includes step-by-step implementations

for ensuring business continuity with SQL Server 2008 R2, Windows Server 2008

R2, and Hyper-V Live Migration. Finally, in Chapter 5, “Consolidation and Moni-

toring,” a discussion on consolidation strategies teaches readers how to improve

resource optimization. This chapter also explains how to use the new dashboard

and viewpoints to gain insight into application and database utilization, and it also

covers how to use capacity policy violations to help identify consolidation oppor-

tunities, maximize investments, and ultimately maintain healthier systems.

In Part II, “Business Intelligence Development,” readers discover components

new to the SQL Server data platform, as well as signicant enhancements to the

reporting component. Chapter 6, “Scalable Data Warehousing,” introduces the

data warehouse appliance known as SQL Server 2008 R2 Parallel Data Warehouse

by explaining its architecture, reviewing data layout strategies for optimal query

performance, and describing the integration points with SQL Server BI com-

ponents. In Chapter 7, “Master Data Services,” readers learn about master data

management concepts and the new Master Data Services component. Chapter 8,

“Complex Event Processing with StreamInsight,” describes scenarios that benet

from complex event analysis, and it illustrates how to develop applications that

use the SQL Server StreamInsight engine for complex event processing. Chapter

9, “Reporting Services Enhancements,” reviews all the new features available in

SQL Server 2008 R2 Reporting Services that support self-service reporting and

address common report design problems. Last, Chapter 10, “Self-Service Analysis

with PowerPivot,” continues the theme of self-service by explaining how users can

integrate disparate data for analysis by using SQL Server PowerPivot for Excel, and

how to centralize and share the results of this analysis by using SQL Server Power-

Pivot for SharePoint.

Pre-Release Software

To help you get familiar with SQL Server 2008 R2 as early as possible after its

release, we wrote this book using examples that work with the Release Candidate

0 (RC0) version of the product. Consequently, the nal version might include new

features, and features we discuss might change or disappear. Refer to the “What’s

1 2 ... 13 14 15 16 17 18 19 20 21 22 23 ... 235 236

Microsoft SQL Server 2008 R2 Specifications Page 18