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:

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 (83)

  1. victor labastida says:

    looks awesome, i need to learn more about SQL Server 2008 R2, thanks a lot

  2. wofat68 says:

    what about a real ebook format?

  3. MSDN Archive says:

    Two great SQL experts and authors! Can’t believe you’re giving this away.

  4. Ross Mistry says:

    Feel free to follow the authors and ask quesitons on Twitter.

    @RossMistry

    @StaciaMisner

  5. claire edgson says:

    been really enjoying the mapping on R2.

  6. Sean Kenney says:

    Really looking forward to the MDS section…

  7. Sean Kenney says:

    I am really looking forward to the MDS section.  I am very interested in what they did with the Stratature purchase….

  8. pratap says:

    to check how the book is and what new concepts have been introduced.

  9. Daniel De Rama says:

    i would like to know the difference between sql 2005 and the latest 2008

  10. Daniel De Rama says:

    i would like to know the difference between sql 2005 and the latest 2008

  11. R Johal says:

    Just the information, and good its free

  12. R Johal says:

    Just the information I was looking for and its free

  13. Rohan Joackhim says:

    Just started browsing through.Uptodate stuff.

    Creating a SQL Server VM with Hyper-V-not many  books written before about this.

  14. ERNESTO says:

    to check how the book is and what new concepts have been introduced.

  15. Great initiative, i hope all Microsoft Press books will come available as free ebooks.

  16. Introducing Microsoft SQL Server 2008 R2 says:

    I am Oracle DBA on a SQL server trainning next week.

  17. sri says:

    i need to know the difference between 2005 and 2008 versions

  18. Brian Jung says:

    My company, MSS Technologies, is a provided of Microsoft SQL Server Data Warehouse Services.

  19. Carl Walden says:

    wonderful written and well explained, many thanks for such a good book.

  20. gromas says:

    We plan migrate to SQL Server 2008 R2. Thank you for the book.

  21. Adrian Najera says:

    I need the book for learning issues. Tks a lot

  22. I would like to have this book

  23. Hola, agradeceré su apoyo en mi capacitación sobre el aprovechamiento de SQL Server 2008, al facilitarme ese libro.

  24. Jody L Meyer says:

    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!

  25. i like read, enjoy and learn this book

    thanks

    ing william enciso

  26. Jon Foulkes says:

    Thanks I’m sure this will be very useful.

  27. chris says:

    Great book, will i get time to read it?

  28. Jovita says:

    thanks for sharing this book.. 🙂

  29. naciso says:

    me parece muy bueno y super instructivo

  30. naciso says:

    me pacere buenisimo y instructivo

  31. homar says:

    Bien, por hacer disponible material tecnico valioso de forma gratuita. En hora buena.

  32. i am interesting in the book thanks

  33. 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

  34. dave Tuegel says:

    I would like to know more about the new sql Server Release

  35. Celina Kan says:

    Useful, informational,  I enjoy reading it!

  36. GINA says:

    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 .

  37. elvermg says:

    Great book, thanks!!!

  38. Marco Angelucci says:

    ottima iniziativa, è una buona referenza.

    Excellent initiative, the book is a very good reference.

  39. Mina says:

    wonderful

  40. andre says:

    great sharing,can't wait for another ebook,thnx

  41. kishore says:

    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 …

  42. Atdhe Buja says:

    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

  43. Richard says:

    Come on Microsoft Press move to .mobi/.epub for your ebooks!

  44. @dolus says:

    Very interesting, i was looking for a book like this.

  45. shah gour says:

    what is the diffrence b/w sql server2008 and 2008 r2????

  46. Salman says:

    thank you

  47. soho says:

    Thanks for the eBook. And free too!

  48. marya perez says:

    thanks…

  49. Thanks! This is a very useful book!!

  50. Reecha Mishra says:

    Thanks a ton !!! I can't express how much this helped me..

  51. sundar rajan says:

    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!

  52. Carlos Lijeron says:

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

  53. The link not function. The free ebook can´t lower in both pdf format as xps.

  54. TRX says:

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

  55. stardestroyer says:

    THANK YOU!

  56. Eralper says:

    Thanks for publishing this book free for SQL Server Administrators and developers

  57. BI says:

    what about SQL Server 2012?

  58. Marcus Guedes says:

    Thank you so much.

  59. Jordon Asio says:

    Best for the developers. Excellent!  

  60. sanjay negi says:

    plz sir wiindows server books 2k8 with graphics.

  61. jay says:

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

  62. John says:

    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!

  63. komal sharma says:

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

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

  65. how do i download a .pdf version ?

  66. superego says:

    pdf & xps failing on download

  67. Lucas Castro says:

    That's great! Incredible!

  68. SAM says:

    i cant download ur ebook

    pls send me the link for free download

  69. Carlos H says:

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

  70. Tameshwar Deshmukh says:

    Great, all microsoft ebooks available as for free ebooks.

  71. Krishna says:

    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.  

  72. António Roque says:

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

  73. wilson chavez chota says:

    Por favor si tuvieran el manual en castellano…

  74. Rajat Garg says:

    Will love to figure out how we can use it for http://www.shimply.com/books

  75. Er Sohaib Najmul Hasan says:

    Awesome, Great Initiative,Thanks a lot.

  76. anonymous says:

    I would like to archive child table along with parent table in ssis 2008r2 version how can I do this.

  77. Rishi says:

    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.

  78. Rishi says:

    It?s really a great and useful piece of information. I?m happy that you just shared this helpful information with us.

  79. Ruth Triana says:

    gracias por compartir este libro gran ayuda

  80. siva says:

    please send me the book