Free ebook: Introducing Microsoft SQL Server 2008 R2


Free ebook: Introducing Microsoft SQL Server 2008 R2

  • Comments 76

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:

Introduction

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.

Enjoy!

  • plz sir wiindows server books 2k8 with graphics.

  • the pdf file appears to be corrupt, it won't load

  • I didnt read much and I dont know much so I want to know more.

    Introduction

    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.

    Enjoy!

  • i want chap querying and filtering data of sql in detail....

  • Thank you Microsoft for Providing these Great stuffs free of cost...

  • how do i download a .pdf version ?

  • pdf & xps failing on download

  • thank

    for

    freekaamaal.com/.../freebie-round-up-top-ongoing-freebies-shared-by-our-forum-fans

  • <a href="http://www.google.com">google</a>

  • That's great! Incredible!

  • i cant download ur ebook

    pls send me the link for free download

  • Sincerely I recomend these ebook for everybody! Especialy if you are a student. Congratulations MS!

  • Great, all microsoft ebooks available as for free ebooks.

  • With the interest to learn MS SQL server 2008 R2 was able to get a second hand book "MS SQL server 2008 R2 Unleashed" however failed to get the accompanying CD ROM with the example files/ extra study notes. Could any of you let me know where I would be able to get a iso image of the the CD ROM. Happy to receive the url.  

  • Grato,  estava para comprar o livro em hardware mais com este na parte loggica estou tranquilo.

Page 5 of 6 (76 items) «23456
Leave a Comment
  • Please add 8 and 7 and type the answer here:
  • Post