Topic: SQL Server

Professional Microsoft SQL Server 2012 Administration (1118286847) cover image

Professional Microsoft SQL Server 2012 Administration

Adam Jorgensen, Steven Wort, Ross LoForte, Brian Knight
ISBN: 978-1-118-28684-5
E-book
960 pages
March 2012
Other Available Formats: Paperback
Electronic Version: US $32.99 Purchase This E-book

About This Title  |  Errata
Table of Contents
INTRODUCTION xxxvii

CHAPTER 1: SQL SERVER 2012 ARCHITECTURE 1

CHAPTER 2: INSTALLING SQL SERVER 2012 BEST PRACTICES 21

CHAPTER 3: UPGRADING SQL SERVER 2012 BEST PRACTICES 53

CHAPTER 4: MANAGING AND TROUBLESHOOTING THE DATABASE ENGINE 71

CHAPTER 5: AUTOMATING SQL SERVER 105

CHAPTER 6: SERVICE BROKER IN SQL SERVER 2012 147

CHAPTER 7: SQL SERVER CLR INTEGRATION 167

CHAPTER 8: SECURING THE DATABASE INSTANCE 181

CHAPTER 9: CHANGE MANAGEMENT 197

CHAPTER 10: CONFIGURING THE SERVER FOR OPTIMAL PERFORMANCE 233

CHAPTER 11: OPTIMIZING SQL SERVER 2012 273

CHAPTER 12: MONITORING YOUR SQL SERVER 317

CHAPTER 13: PERFORMANCE TUNING T-SQL 399

CHAPTER 14: INDEXING YOUR DATABASE 449

CHAPTER 15: REPLICATION 473

CHAPTER 16: CLUSTERING SQL SERVER 2012 509

CHAPTER 17: BACKUP AND RECOVERY 547

CHAPTER 18: SQL SERVER 2012 LOG SHIPPING 607

CHAPTER 19: DATABASE MIRRORING 641

CHAPTER 20: INTEGRATION SERVICES ADMINISTRATION AND PERFORMANCE TUNING 695

CHAPTER 21: ANALYSIS SERVICES ADMINISTRATION AND PERFORMANCE TUNING 729

CHAPTER 22: SQL SERVER REPORTING SERVICES ADMINISTRATION 765

CHAPTER 23: SQL SERVER 2012 SHAREPOINT 2010 INTEGRATION 815

CHAPTER 24: SQL AZURE ADMINISTRATION AND CONFIGURATION 837

CHAPTER 25: ALWAYSON AVAILABILITY GROUPS 857

INDEX 885