CONTENTS
Chapter 1: SQL Server 2012 Architecture
New Important Features in 2012
Chapter 2: Installing SQL Server 2012 Best Practices
Installing PowerPivot for SharePoint
Troubleshooting a Failed Install
Chapter 3: Upgrading SQL Server 2012 Best Practices
Why Upgrade to SQL Server 2012?
SQL Server Component Considerations
Chapter 4: Managing and Troubleshooting the Database Engine
Configuration and Administration Tools
Chapter 5: Automating SQL Server
Automating SQL Server with SQL Server Agent
Chapter 6: Service Broker in SQL Server 2012
Configuring SQL Server Service Broker
Using SQL Server Service Broker
Chapter 7: SQL Server CLR Integration
Chapter 8: Securing the Database Instance
Creating Solutions and Projects
Chapter 10: Configuring the Server for Optimal Performance
What Every DBA Needs to Know About Performance
What the Developer DBA Needs to Know About Performance
What the Production DBA Needs to Know About Performance
Chapter 11: Optimizing SQL Server 2012
The Silent Killer: I/O Problems
Memory Considerations and Enhancements
Chapter 12: Monitoring Your SQL Server
Choosing the Appropriate Monitoring Tools
Monitoring with Dynamic Management Views and Functions
SQL Server Best Practice Analyzer
Chapter 13: Performance Tuning T-SQL
Physical Query Processing Part One: Compilation and Recompilation
Physical Query Processing Part Two: Execution
Chapter 14: Indexing Your Database
Noteworthy Index-Related Features in SQL Server
Partitioned Tables and Indexes
Improving Query Performance with Indexes
Chapter 16: Clustering SQL Server 2012
Clustering and Your Organization
Upgrading SQL Server Clustering
Getting Prepared for Clustering
Clustering Windows Server 2008
Clustering Microsoft Distributed Transaction Coordinator
Managing and Monitoring the Cluster
Troubleshooting Cluster Problems
Chapter 17: Backup and Recovery
Overview of Backup and Restore
Developing and Executing a Backup Plan
Backup and Restore Performance
Chapter 18: SQL Server 2012 LOG Shipping
Log Shipping Deployment Scenarios
Monitoring and Troubleshooting
Integrating Log Shipping with Other High-Availability Solutions
Upgrading to SQL Server 2012 Log Shipping
Chapter 19: Database Mirroring
Overview of Database Mirroring
Operating Modes of Database Mirroring
Database Mirroring and SQL Server 2012 Editions
Database Mirroring Catalog Views
Database Mirroring Role Change
Database Availability Scenarios
Troubleshooting Database Mirroring
Preparing the Mirror Server for Failover
Database Mirroring and Other High-Availability Solutions
Mirroring Event Listener Setup
Chapter 20: Integration Services Administration and Performance Tuning
A Tour of Integration Services
Administration of the Integration Services Service
Administration of Integration Services Packages in Package Deployment Model
Administration of Integration Services Packages in Project Deployment Model
Applying Security to Integration Services
Chapter 21: Analysis Services Administration and Performance Tuning
Administering Analysis Services Server
Administering Analysis Services Databases
Analysis Services Performance Monitoring and Tuning
Management of Analysis Services MOLAP Model Storage
Applying Security to Analysis Services in the MOLAP Model
Chapter 22: SQL Server Reporting Services Administration
SQL Server Reporting Services Configuration Manager
Chapter 23: SQL Server 2012 Sharepoint 2010 Integration
Chapter 24: SQL Azure Administration and Configuration
Chapter 25: Alwayson Availability Groups
Active Secondary for Secondary Read-Only
Backup on the Secondary Replica