Sqlhghghghg Jghj
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2010 by Microsoft Corporation
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means
without the written permission of the publisher.
Library of Congress Control Number: 2010925075
Printed and boundin the United States of America.
1 2 3 4 5 6 7 8 9 WCT 5 4 3 2 1 0
Distributed in Canada by H.B. Fenn and Company Ltd.
A CIP catalogue record for this book is available from the British Library.
Microsoft Press books are available through booksellers and distributors worldwide. For further infor mation about
international editions, contact your local Microsoft Corporation office or contactMicrosoft Press International directly
at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress. Send comments to mspinput@microsoft.com.
Microsoft, Microsoft Press, Access, ActiveX, DirectX, Expression, Expression Blend, Hotmail, IntelliSense, Internet
Explorer, MS, MSDN, MS-DOS, MSN, SharePoint, Silverlight, SQL Server, Visual Basic, Visual C#, Visual Studio,
Win32, Windows,Windows Live, Windows NT, Windows Server, and Windows Vista are either registered trademarks
or trademarks of the Microsoft group of companies. Other product and company names mentioned herein may be the
trademarks of their respective owners.
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events
depicted herein are fictitious. Noassociation with any real company, organization, product, domain name, e-mail address,
logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without any
express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will
be heldliable for any damages caused or alleged to be caused either directly or indirectly by this book.
Acquisitions Editor: Devon Musgrave
Developmental Editor: Karen Szall
Project Editor: Maria Gargiulo
Editorial Production: Online Training Solutions, Inc.
Technical Reviewer: Rozanne Whalen; Technical Review Services provided by Content Master, a member of CM Group, Ltd.
Cover: Tom Draper DesignI dedicate this book to my wife and children, who make it all
worthwhile.
—Ross MistRy
I dedicate this book to my husband and best friend, Gerry.
—stacia MisneR
Contents at a Glance
Introduction
xvii
PART I
DATABASE ADMINISTRATION
CHAPTER 1
SQL Server 2008 R2 Editions and Enhancements
CHAPTER 2
Multi-Server Administration
21
CHAPTER 3
Data-TierApplications
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
165CHAPTER 10
Self-Service Analysis with PowerPivot
189
3
Contents
Introduction
PART I
xvii
DATABASE ADMINISTRATION
CHAPTER 1 SQL Server 2008 R2 Editions and Enhancements
3
SQL Server 2008 R2 Enhancements for DBAs . . . . . . . . . . . . . . . . . . . . . . . . . 3
Application and Multi-Server Administration Enhancements
4
AdditionalSQL Server 2008 R2 Enhancements for DBAs
8
Advantages of Using Windows Server 2008 R2 . . . . . . . . . . . . . . . . . . . . . . 10
SQL Server 2008 R2 Editions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Premium Editions
12
Core Editions
12
Specialized Editions
13
Hardware...
Regístrate para leer el documento completo.