Free ebook: Introducing Microsoft SQL Server 2008 R2

9780735693883f We’re thrilled to publish another free ebook: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner!

The book contains 10 chapters and 216 pages, like so:

PART I   Database Administration

CHAPTER 1   SQL Server 2008 R2 Editions and Enhancements 3
CHAPTER 2   Multi-Server Administration 21
CHAPTER 3   Data-Tier Applications 41
CHAPTER 4   High Availability and Virtualization Enhancements 63
CHAPTER 5   Consolidation and Monitoring 85

PART II   Business Intelligence Development

CHAPTER 6   Scalable Data Warehousing 109
CHAPTER 7   Master Data Services 125
CHAPTER 8   Complex Event Processing with StreamInsight 145
CHAPTER 9   Reporting Services Enhancements 165
CHAPTER 10   Self-Service Analysis with PowerPivot 189

Here’s more info about the book:


Our purpose in Introducing Microsoft SQL Server 2008 R2 is to point out both
the new and the improved in the latest version of SQL Server. Because this
version is Release 2 (R2) of SQL Server 2008, you might think the changes are
relatively minor—more than a service pack, but not enough to justify an entirely
new version. However, as you read this book, we think you will find that there are a
lot of exciting enhancements and new capabilities engineered into SQL Server 2008 R2
that will have a positive impact on your applications, ranging from improvements
in operation to those in management. It is definitely not a minor release!

Who Is This Book For?

This book is for anyone who has an interest in SQL Server 2008 R2 and wants to
understand its capabilities. In a book of this size, we cannot cover every feature
that distinguishes SQL Server from other databases, and consequently we assume
that you have some familiarity with SQL Server already. You might be a database
administrator (DBA), an application developer, a power user, or a technical
decision maker. Regardless of your role, we hope that you can use this book to
discover the features in SQL Server 2008 R2 that are most beneficial to you.

How Is This Book Organized?

SQL Server 2008 R2, like its predecessors, is more than a database engine. It is a
collection of components that you can implement either separately or as a group
to form a scalable data platform. In broad terms, this data platform consists of
two types of components—those that help you manage data and those that help
you deliver business intelligence (BI). Accordingly, we have divided this book into
two parts to focus on the new capabilities for each of these areas.

Part I, “Database Administration,” is written with the DBA in mind and introduces
readers to the numerous innovations in SQL Server 2008 R2. Chapter 1, “SQL
Server 2008 R2 Editions and Enhancements,” discusses the key enhancements,
what’s new in the different editions of SQL Server 2008 R2, and the benefits of
running SQL Server 2008 R2 on Windows Server 2008 R2. In Chapter 2, “Multi-
Server Administration,” readers learn how centralized management capabilities
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 management.
Chapter 3, “Data-Tier Applications,” focuses on how to streamline deployment
and manage and upgrade database applications with the new data-tier application
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 Monitoring,”
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 opportunities,
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 significant 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 components.
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 benefit
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.

You can download the ebook in XPS format here and in PDF format here.