ProfessionalMicrosoftSQLServer2012Administration

作者: Jorgensen, Adam; Wort, Steven; Loforte, Ross An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team ofPROFESSIONALMICROSOFT SQL SERVER 2012 ADMINISTRATIONNTRODUCTIONCHAPTER 1 SQL Server 2012 ArchitectureCHAPTER 2 Installing sQL server 2012 Best Practices21CHAPTER 3 Upgrading SQL Server 2012 Best PracticesCHAPTER 4 Managing and troubleshooting the database engineCHAPTER 5 Automating sQl server105CHAPTER 6 Service broker in sql server 2012147CHAPTER 7 SQL Server CLR Integration....167CHAPTER 8 Securing the Database Instance.18CHAPTER 9 Change Management197CHAPTER 10 Configuring the Server for Optimal Performance233CHAPTER 11 Optimizing SQL Server 2012....,273CHAPTER 12 Monitoring Your sQL server317CHAPTER 13 Performance Tuning T-SQL399CHAPTER 14 Indexing Your Database449CHAPTER 15 Replication....473CHAPTER 16 Clustering SQL Server 2012509CHAPTER 17 Backup and Recovery547CHAPTER 18 SQL Server 2012 Log Shipping607CHAPTER 19 Database Mirroring.641CHAPTER 20 Integration Services Administration and Performance Tuning695CHAPTER 21 Analysis Services Administration and Performance Tuning729CHAPTER 22 SQL Server Reporting Services Administration765CHAPTER 23 SQL Server 2012 Share Point 2010 Integration....815CHAPTER 24 SQL Azure Administration and Configuration837CHAPTER 25 AlwaysOn Availability Groups857INDEX,∴,,∴,,,,,885PROFESSIONALMicrosoft sqL server 2012AdministrationPROFESSIONALMicrosoft sQL Server 2012AdministrationAdam JorgensenSteven wortRoss LoForteBrian KnightWILEYJohn wiley sons, incProfessional microsoft@ sql server@ 2012 AdministrationPublished brJohn Wiley Sons, Inc10475 Crosspoint BoulevardIndianapolis, IN 46256www.wiley.comCopyright@ 2012 by John Wiley Sons, Inc, Indianapolis, IndianaPublished simultaneously in CanadaISBN:978-1-118-10688-4ISBN:978-1-118-28684-5(ebk)ISBN:978-1-118-28218-2(ebk)ISBN:978-1-118-28388-2(ebk)Manufactured in the United States of america10987654321No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any meanselectronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorizationthrough payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, DanversMA01923, (978)750-8400, fax(978)646-8600. Requests to the Publisher for permission should be addressed to thePermissions Department, John Wiley Sons, Inc, 111 River Street, Hoboken, NJ 07030,(201)748-6011,fax(201)748-6008,oronlineathttp://www.wileycom/go/permissionsLimit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties withrespect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, includingwithout limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales orpromotional materials. The advice and strategies contained herein may not be suitable for every situation. This workis sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professionalservices. If professional assistance is required, the services of a competent professional person should be sought. Neitherthe publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site isreferred to in this work as a citation and/or a potential source of further information does not mean that the author or thepublisher endorses the information the organization or Web site may provide or recommendations it may make Furtherreaders should be aware that Internet Web sites listed in this work may have changed or disappeared between when thiswas written and when it is readFor general information on our other products and services please contact our Customer Care Department within theUnited States at (877)762-2974, outside the United States at (317)572-3993 or fax (317)572-4002Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included withstandard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to mediasuch as a CD or Dvd that is not included in the version you purchased, you may download this material athttp://booksupport.wileycomFormoreinformationaboutWileyproductsvisitwww.wiley.comLibrary of Congress Control Number: 2012933629Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related trade dressare trademarks or registered trademarks of John Wiley Sons, Inc and/or its affiliates, in the United States and othercountries, and may not be used without written permission. Microsoft and SQL Server are registered trademarks ofMicrosoft Corporation. All other trademarks are the property of their respective owners. John Wiley sons, Inc, is notassociated with any product or vendor mentioned in this bookI'd like to dedicate this book to my lord and saviorJesus Christ, and my parents who always stressed theimportance of the " All-important question. "This timethe answer is yes!ADAM JORGENSENTo my wonderful team at Pragmatic Works, whoinspire me to always take myself to the next levelBRIAN KNIGHTTo my parents, for being the pillars of the person thatI am now, and to the three greatest loves of my lifemy queen Madeline and my two princesses, Sofia andStephanie, for filling my life with love, tenderness,-JOSE CHINCHILLATo my beautiful wife Jessica. I love you and thankyou for all your patience, love, understandingand support.-JORGE SEGARRATo my dad Chris A. R Swanepoel. I owe everythingi am to you. You are my heroGARETH SWANEPOEL