Free ebook: Introducing Microsoft SQL Server 2008 R2

  • Article

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!

Comments

  • Anonymous
    April 14, 2010
    looks awesome, i need to learn more about SQL Server 2008 R2, thanks a lot

  • Anonymous
    April 14, 2010
    what about a real ebook format?

  • Anonymous
    April 15, 2010
    Two great SQL experts and authors! Can't believe you're giving this away.

  • Anonymous
    April 15, 2010
    Feel free to follow the authors and ask quesitons on Twitter. @RossMistry @StaciaMisner

  • Anonymous
    April 15, 2010
    been really enjoying the mapping on R2.

  • Anonymous
    April 15, 2010
    Really looking forward to the MDS section...

  • Anonymous
    April 15, 2010
    I am really looking forward to the MDS section.  I am very interested in what they did with the Stratature purchase....

  • Anonymous
    April 15, 2010
    to check how the book is and what new concepts have been introduced.

  • Anonymous
    April 15, 2010
    i would like to know the difference between sql 2005 and the latest 2008

  • Anonymous
    April 15, 2010
    i would like to know the difference between sql 2005 and the latest 2008

  • Anonymous
    April 15, 2010
    Just the information, and good its free

  • Anonymous
    April 15, 2010
    Just the information I was looking for and its free

  • Anonymous
    April 16, 2010
    Just started browsing through.Uptodate stuff. Creating a SQL Server VM with Hyper-V-not many  books written before about this.

  • Anonymous
    April 17, 2010
    to check how the book is and what new concepts have been introduced.

  • Anonymous
    April 17, 2010
    Great initiative, i hope all Microsoft Press books will come available as free ebooks.

  • Anonymous
    April 18, 2010
    I am Oracle DBA on a SQL server trainning next week.

  • Anonymous
    April 18, 2010
    i need to know the difference between 2005 and 2008 versions

  • Anonymous
    April 19, 2010
    My company, MSS Technologies, is a provided of Microsoft SQL Server Data Warehouse Services.

  • Anonymous
    April 19, 2010
    wonderful written and well explained, many thanks for such a good book.

  • Anonymous
    April 20, 2010
    We plan migrate to SQL Server 2008 R2. Thank you for the book.

  • Anonymous
    April 20, 2010
    I need the book for learning issues. Tks a lot

  • Anonymous
    April 21, 2010
    I would like to have this book

  • Anonymous
    April 22, 2010
    Hola, agradeceré su apoyo en mi capacitación sobre el aprovechamiento de SQL Server 2008, al facilitarme ese libro.

  • Anonymous
    April 22, 2010
    I would love to get this free book. As the president of a user group... it's a great way to stay informed and not cost a bundle.  :O)  Thank you!

  • Anonymous
    April 23, 2010
    i like read, enjoy and learn this book thanks ing william enciso

  • Anonymous
    April 25, 2010
    Thanks I'm sure this will be very useful.

  • Anonymous
    April 26, 2010
    Great book, will i get time to read it?

  • Anonymous
    April 29, 2010
    thanks for sharing this book.. :)

  • Anonymous
    April 30, 2010
    me parece muy bueno y super instructivo

  • Anonymous
    April 30, 2010
    me pacere buenisimo y instructivo

  • Anonymous
    May 07, 2010
    Bien, por hacer disponible material tecnico valioso de forma gratuita. En hora buena.

  • Anonymous
    May 09, 2010
    i am interesting in the book thanks

  • Anonymous
    May 10, 2010
    Hi, I actually wonder the StreamInsight solution. I believe with such improvements SQL2008R2 has been the best product on the market for database professionals. I also wonder if any  un-mentioned t-sql enhancements for t-sql developers. I hope to find answers with this ebook. Great, thanks

  • Anonymous
    May 11, 2010
    I would like to know more about the new sql Server Release

  • Anonymous
    May 26, 2010
    Useful, informational,  I enjoy reading it!

  • Anonymous
    June 08, 2010
    SALUDOS DESDE MEXICO, DESEO MAS INFORMACION SOBRE ESTE GRAN LIBRO QUE DESOE ADQUIRIR. ESPERO Y ME PEUDAN PROPORCIONAR ALGUNA DIRECCION EN MEXICO PARA PODERLA ADQUIRIR ESTA GUIA DE VISUAL PUES EN MI PAIS O EN MI REGION ES CASI IMPOSIBLE ENCONTRAR ALGO DE PROGRAMACION Y MAS DE VISUAL QUE LO CUAL YO ESTOY ESTUDIANDO PERO EN INTERNET SOLOL SALEN PAGINAS DONDE ME HAKEAN MI PC EN DONDE ME CONECTE.  capturagina@gmail.com UTILIZO GMAIL PUES EL HOTMAIL YA ES MAS FACIL HAKEAR Y ME INSULTARON PRO MUCHO TIEMPO A MIS CONTACTOS Y E  ROBARON INFORMACION .

  • Anonymous
    June 22, 2010
    Great book, thanks!!!

  • Anonymous
    October 10, 2010
    ottima iniziativa, è una buona referenza. Excellent initiative, the book is a very good reference.

  • Anonymous
    October 26, 2010
    wonderful

  • Anonymous
    November 20, 2010
    great sharing,can't wait for another ebook,thnx

  • Anonymous
    November 22, 2010
    Hi dis is kishore Can any one help me out that i just had done wit mcp certification ... and i dont have any idea on sql so . is it possible to learn sql server 2008 ...

  • Anonymous
    December 05, 2010
    To know more SQL Server in its depths, and that science in itself that are very helpful in reaching the peak of knowledge or knowledge of SQL Server 2008. Thank you Microsoft

  • Anonymous
    February 08, 2011
    Come on Microsoft Press move to .mobi/.epub for your ebooks!

  • Anonymous
    March 01, 2011
    Very interesting, i was looking for a book like this.

  • Anonymous
    March 03, 2011
    what is the diffrence b/w sql server2008 and 2008 r2????

  • Anonymous
    March 07, 2011
    thank you

  • Anonymous
    March 15, 2011
    Thanks for the eBook. And free too!

  • Anonymous
    March 16, 2011
    thanks...

  • Anonymous
    April 26, 2011
    Thanks! This is a very useful book!!

  • Anonymous
    May 11, 2011
    Thanks a ton !!! I can't express how much this helped me..

  • Anonymous
    May 26, 2011
    I want to learn the basics of sql server mgt and that is why I am dowloading this..what is better than hearing from the lion's mouth!

  • Anonymous
    June 15, 2011
    Thanks so much for providing this material; it is a great help when preparing to learn about the product while on a strict budget !!!    

  • Anonymous
    July 02, 2011
    The link not function. The free ebook can´t lower in both pdf format as xps.

  • Anonymous
    August 17, 2011
    Hello, I feel this site may be very useful for me, Love it so much, thanks for the recommendation <a href="www.123ebookdownload.com/.../">Electronic Commerce</a>

  • Anonymous
    August 29, 2011
    THANK YOU!

  • Anonymous
    October 04, 2011
    Thanks for publishing this book free for SQL Server Administrators and developers

  • Anonymous
    January 31, 2012
    what about SQL Server 2012?

  • Anonymous
    February 06, 2012
    Thank you so much.

  • Anonymous
    February 14, 2012
    how can i download it?

  • Anonymous
    March 20, 2012
    Best for the developers. Excellent!  

  • Anonymous
    March 28, 2012
    plz sir wiindows server books 2k8 with graphics.

  • Anonymous
    May 06, 2012
    the pdf file appears to be corrupt, it won't load

  • Anonymous
    May 20, 2012
    The comment has been removed

  • Anonymous
    May 31, 2012
    i want chap querying and filtering data of sql in detail....

  • Anonymous
    June 27, 2012
    Thank you Microsoft for Providing these Great stuffs free of cost...

  • Anonymous
    June 27, 2012
    how do i download a .pdf version ?

  • Anonymous
    June 28, 2012
    pdf & xps failing on download

  • Anonymous
    June 28, 2012
    thank for freekaamaal.com/.../freebie-round-up-top-ongoing-freebies-shared-by-our-forum-fans

  • Anonymous
    July 03, 2012
    <a href="http://www.google.com">google</a>

  • Anonymous
    October 29, 2012
    That's great! Incredible!

  • Anonymous
    December 26, 2012
    The comment has been removed

  • Anonymous
    March 24, 2013
    Sincerely I recomend these ebook for everybody! Especialy if you are a student. Congratulations MS!

  • Anonymous
    July 19, 2013
    Great, all microsoft ebooks available as for free ebooks.

  • Anonymous
    August 09, 2013
    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.  

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

  • Anonymous
    March 27, 2014
    Por favor si tuvieran el manual en castellano...

  • Anonymous
    October 29, 2014
    Will love to figure out how we can use it for http://www.shimply.com/books

  • Anonymous
    December 16, 2014
    Awesome, Great Initiative,Thanks a lot.

  • Anonymous
    August 09, 2015
    I would like to archive child table along with parent table in ssis 2008r2 version how can I do this.

  • Anonymous
    August 27, 2015
    Good site! I really love how it is nice on my eyes it is. I am wondering how I could be notified when a new post has been made.

  • Anonymous
    October 18, 2015
    It?s really a great and useful piece of information. I?m happy that you just shared this helpful information with us.

  • Anonymous
    April 06, 2016
    gracias por compartir este libro gran ayuda

  • Anonymous
    May 13, 2016
    please send me the book

  • Anonymous
    October 17, 2016
    Good afternoonThis completed a post graduate degree in database and my course completion work is on SQL Server 2008 optimization, I need a lot of this book, I will be very grateful to you if they provide. Thank you.

  • Anonymous
    October 18, 2017
    Awesome, Please write more book...on Sql