Sqlserver : como ser un dba

Introducing
Microsoft
®

SPECIAL EXCERPT Complete book available Spring 2012

SQL Server

®

Code Name “Denali”
PREVIEW CONTENT

Ross Mistry and Stacia Misner

PREVIEW CONTENT This excerpt provides early content from a book currently in development, and is still in draft, unedited format. See additional notice below.

This document supports a preliminary release of asoftware product that may be changed substantially prior to final commercial release. This document is provided for informational purposes only and Microsoft makes no warranties, either express or implied, in this document. Information in this document, including URL and other Internet Web site references, is subject to change without notice. The entire risk of the use or the results from the useof this document remains with the user. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted in examples herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. Complying with allapplicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property. © 2011 Microsoft Corporation. Allrights reserved.

Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of their respective owners.

About the Authors

Ross Mistry is a Principal Enterprise Architect with Microsoft, working out of the Microsoft Technology Center inSilicon Valley. He designs solutions for Microsoft largest customers and specializes in SQL Server high availability, appliances, consolidation, virtualization, and private cloud. Ross is also an author, community champion, and seasoned architect. He has a tremendous amount of experience designing and deploying technology solutions for Internet startups and fortune 100 organ­ izations locatedin the Silicon Valley. He is known in the world-wide community for his expertise in SQL Server, Windows, Exchange, Virtualization, and Private Cloud. Ross frequently speaks at technology conferences around the world and has published many books, whitepapers, and magazine articles. His recent books include Introducing SQL Server 2008 R2 (Microsoft Press), Windows Server 2008 R2 Un­ leashed(SAMS) and SQL Server 2008 Management and Administration (SAMS). You can follow him on Twitter @RossMistry.

Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solu­ tions since 1999. During that time, she has authored or co-authored multiple books about BI. Stacia provides consulting and custom education services through Data Inspirations andspeaks frequently at conferences serving the SQL Server community. She writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.

CONTENTS
CHAPTER 2 High Availability and Disaster Recovery Enhancements 1

SQL Server AlwaysOn: An Integrated Solution...........................................................................1
AlwaysOn Availability...