Introduction
Adding SQL Server 2008 R2 Service Pack features using Slipstream technology
Designing a best practice approach to upgrading to SQL Server 2008 R2
Working with Data-Tier applications
Designing and adopting SQL Server 2008 R2 solutions
Designing applications to use federated servers
Chapter 2: Administrating the Core Database Engine
Introduction
Designing automated administration practices
Implementing Security feature enhancements
Implementing Availability feature enhancements
Implementing, Monitoring, and Tuning for performance
Administering SQL Server workloads with Resource Governor
Designing SQL Server Agent scheduled jobs for ETL processes
Troubleshooting multi-server instances with utility administration
Administering SQL Server Replication processes
Chapter 3: Managing the Core Database Engine
Introduction
Implementing Central Management feature enhancements
Designing Multi-server management from SQL Server 2008 R2
Managing the Utility Control Point data warehouse database
Implementing Utility & Non-utility collection sets
Designing and refreshing a Scalable Shared database
Managing SQL Server Replication processes
Implementing security for SQL Server Agent jobs management
Multiserver Management Using Utility Explorer
Chapter 4: Administering Core Business Intelligence Services
Introduction
Preparing and installing SQL Server Analysis Services
Implementing Scale-Out of SQL Server Analysis Services
Administering SQL Server Reporting Services
Implementing Scale-Out deployment of SQL Server Reporting Services
Preparing and installing SQL Server Integration Services
Managing the ETL process efficiently
Chapter 5: Managing Core SQL Server 2008 R2 Technologies
Introduction
Planning and implementing Self-Service Business Intelligence services
Implementing Microsoft StreamInsight Technologies Platform
Implementing SQL Azure connectivity features
Installing and configuring a Master Data Services Solution
Designing and deploying framework to use Master Data Services
Chapter 6: Improving Availability and enhancing Programmability
Introduction
Preparing new Failover Cluster features
Installing and configuring Failover Cluster Services
Recovering and troubleshooting Failover Cluster Failure
Implementing Database Mirroring features and performance enhancements
Managing Database Mirroring in a Failover Cluster environment
Managing Log Shipping scenarios in a Database Mirroring environment
Improving Replication scalability at multiple sites
Implementing compressed storage features for tables and indexes
Designing a storage solution for unstructured data and new collations
Designing data partitioning solutions for tables and indexes
Implementing sparse columns and wide table features
Designing spatial data storage methods
Deploying and managing data-tier applications
Chapter 7: Implementing New Manageability Features and Practices
Introduction
Implementing auditing and service level security features
Managing server-level securable and database-level permissions
Implementing backup compression for a VLDB environment
Designing change tracking methodology
Implementing Policy-Based Management features
Implementing and running PowerShell for SQL Server features
Implementing the SQL Server Best Practices Analyzer
Designing Transparent Data Encryption features
Chapter 8: Maintenance and Monitoring
Introduction
Implementing performance baseline practices
Monitoring resource usage with Extended Events
Implementing Management Data Warehouse features
Designing maintenance tasks on a mission-critical environment
Implementing Piecemeal restore strategies
Planning and designing of a Disaster Recovery environment
Implementing sustainable index maintenance practices for a VLDB & 24/7 environment
Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment
Configuring a server storage system for scalability
Configuring SQL server storage architecture for quick recovery
Managing a storage system for analyzing bottlenecks
Chapter 9: Troubleshooting
Introduction
Implementing systematized monitoring methods for data platform optimization
Designing a filtered indexes and statistics feature
Implementing table hints for advanced query tuning performance
Implementing query hints for optimized performance
Designing sustainable locking methods to improve concurrency
Implementing parallel query processing methods
Implementing the plan guide to enhance compile-time and run-time execution plans
Configuring and managing storage systems for optimized defragmentation processes
Building best usage processes of Dynamic Management Views
Implementing a benchmarking framework on multiple instances
Chapter 10: Learning the Tricks of the Trade
Introduction
Automated administration across an enterprise
Administrating resource health policies
Administrating multiple Analysis Services using Tools
Managing events capture to troubleshoot problems
Appendix: More DBA Manageability Best Practices
Index