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.
Bien, por hacer disponible material tecnico valioso de forma gratuita. En hora buena.
i am interesting in the book thanks
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.
I would like to know more about the new sql Server Release
Useful, informational, I enjoy reading it!
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. email@example.com UTILIZO GMAIL PUES EL HOTMAIL YA ES MAS FACIL HAKEAR Y ME INSULTARON PRO MUCHO TIEMPO A MIS CONTACTOS Y E ROBARON INFORMACION .
Great book, thanks!!!
ottima iniziativa, è una buona referenza.
Excellent initiative, the book is a very good reference.
great sharing,can't wait for another ebook,thnx
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 ...
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
Come on Microsoft Press move to .mobi/.epub for your ebooks!
Very interesting, i was looking for a book like this.
what is the diffrence b/w sql server2008 and 2008 r2????