Đang chuẩn bị liên kết để tải về tài liệu:
Pro SQL Server 2012 Practices

Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance—but also branching into release management, auditing, and other issues—the book helps you deliver the most value for your company’s investment in Microsoft’s flagship database system | THE EXPERT S VOICE IN SQL SERVER CAREER-BUILDING INSIGHTS INTO SQL SERVER DATABASE ADMINISTRATION AND PERFORMANCE OPTIMIZATION Bradley Ball TJay Belt Glenn Berry Jes Borland Carlos Bossy Louis Davidson Ben DeBow Grant Fritchey Jonathan Gardner Jesper Johansen Jeremy Lowell Wendy Pastrick Kellyn Pot vin Mladen Prajdic Herve Roggero Chris Shaw Gail Shaw and Jason strate - Apress For your convenience Apress has placed some of the front matter material after the index. Please use the Bookmarks and Contents at a Glance links to access them. Apress www.it-ebooks.info Contents at a Glance About the Authors.xiv About the Technical Reviewers.xix Acknowledgments.xxi Introduction.xxiii Chapter 1 Be Your Developer s Best Friend.1 Chapter 2 Getting It Right Designing the Database for Performance.17 Chapter 3 Hidden Performance Gotchas.43 Chapter 4 Dynamic Management Views.71 Chapter 5 From SQL Trace to Extended Events.101 Chapter 6 The Utility Database.135 Chapter 7 Indexing Outside the Bubble.161 Chapter 8 Release Management.197 Chapter 9 Compliance and Auditing.221 Chapter 10 Automating Administration.235 Chapter 11 The Fluid Dynamics of SQL Server Data Movement.271 Chapter 12 Windows Azure SQL Database for DBAs.293 Chapter 13 I O The Untold Story.313 Chapter 14 Page and Row Compression.335 Chapter 15 Selecting and Sizing the Server.361 Chapter 16 Backups and Restores Using Availability Groups.375 Chapter 17 Big Data for the SQL Server DBA.395 Chapter 18 Tuning for Peak Load.429 Index.465 iv .