Adam Jorgensen - Professional Microsoft SQL Server 2012 Administration

CONTENTS

Professional Microsoft SQL Server 2012 Administration

Published by

John Wiley & Sons, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Copyright 2012 by John Wiley & Sons, Inc., Indianapolis, Indiana

Published simultaneously in Canada

ISBN: 978-1-118-10688-4

ISBN: 978-1-118-28684-5 (ebk)

ISBN: 978-1-118-28218-2 (ebk)

ISBN: 978-1-118-28388-2 (ebk)

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions .

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Web site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com . For more information about Wiley products, visit www.wiley.com .

Library of Congress Control Number: 2012933629

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. Microsoft and SQL Server are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc., is not associated with any product or vendor mentioned in this book.

Id like to dedicate this book to my Lord and Savior Jesus Christ, and my parents who always stressed the importance of the All-important question. This time the answer is yes!

Adam Jorgensen

To my wonderful team at Pragmatic Works, who inspire me to always take myself to the next level.

Brian Knight

To my parents, for being the pillars of the person that I am now, and to the three greatest loves of my life: my queen Madeline and my two princesses, Sofia and Stephanie, for filling my life with love, tenderness, and joy.

Jose Chinchilla

To my beautiful wife Jessica. I love you and thank you for all your patience, love, understanding, and support.

Jorge Segarra

To my dad Chris A. R. Swanepoel. I owe everything I am to you. You are my hero.

Gareth Swanepoel

ABOUT THE AUTHORS

ADAM JORGENSEN ( http://www.adamjorgensen.com ) is the president of Pragmatic Works Consulting, a Director for the Professional Association of SQL Server (PASS), SQL Server MVP, and a well-known speaker, author, and executive mentor. His focus is on helping companies realize their full potential by using their data in ways they may not have previously imagined. Adam is involved in the community as the Director at large for the Professional Association of SQL Server (PASS) and delivers more than 75 community sessions per year. He is based in Jacksonville, FL, and has written and contributed to five previous books on SQL Server, analytics, and SharePoint.

STEVEN WORT has been working with SQL Server since 1993, starting with version 4.2 running on OS2. He has more than 30 years of experience developing applications in the IT industry, working in a wide range of industries. Steven joined Microsoft in 2000 as an escalation engineer on the Systems Integration Engineering (SIE) team, where he co-authored multiple workshops on debugging Windows and .NET. In 2004, he moved to the SQL Server team to work on scalability for SQL Server 2005. After a short spell in the Windows group, spent working on scaling large database systems, he is now back in SQL Server where he is a Lead Engineer on the SQL Server Appliance Engineering Team, responsible for the Microsoft Database Consolidation Appliance. Steven has co-authored several books on SQL Server Administration, troubleshooting, and performance tuning.

ROSS LOFORTE is a technology architect at the Microsoft Technology Center Chicago focused on Microsoft SQL Server solutions. Ross has more than 20 years of business development, project management, and SQL architecture solutions. For the past 11 years, Ross has been working with the Microsoft Technology Centers and has led architecture design and proof-of-concept engagements for Microsofts largest and most strategic customers to design enterprise, mission-critical SQL Server solutions. Ross is a SQL Server instructor at DePaul University in Chicago, and regularly presents at TechEd, SQL PASS, Gartner, TDWI, and Microsoft internal conferences. Ross is a published author and has been active with the Professional Association for SQL Server, the Chicago SQL Server Users Group, and the SQL Server community for many years.

BRIAN KNIGHT , SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of BIDN.com , SQLServerCentral.com , and SQLShare.com . He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of a dozen SQL Server books. Brian has spoken at conferences such as PASS, SQL Connections and TechEd, SQL Saturdays, Code Camps, and many pyramid scheme motivational sessions. You can find his blog at http://www.bidn.com . Brian lives in Jacksonville, FL, where he has been baking at 350 degrees for the past 35 years.