Microsoft SQL Server 2008 R2 Administration Cookbook -- Table of Contents -- Microsoft SQL Server 2008 R2 Administration Cookbook -- Credits -- Foreword -- About the Author -- Acknowledgment -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- SQL Server 2008 R2 Prologue -- SQL Server 2008 R2 new enhancements -- SQL Server 2008 R2 DataCenter -- SQL Server 2008 R2 Parallel Data Warehouse -- SQL Server 2008 R2 Core Editions Enhancements -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Getting Started with SQL Server 2008 R2 -- Introduction -- Adding SQL Server 2008 R2 Service Pack features using Slipstream technology -- Getting Ready -- How to do it... -- How it works... -- There's more... -- Designing a best practice approach to upgrading to SQL Server 2008 R2 -- Getting Ready -- How to do it... -- How it works... -- Backward Compatibility-Deprecate & Discontinued features -- There's more. -- Working with Data-Tier applications -- Getting ready -- How to do it... -- How it works... -- There's more... -- Designing and adopting SQL Server 2008 R2 solutions -- Getting ready -- How to do it... -- How it works... -- There's more... -- Designing applications to use federated servers -- Getting ready -- How to do it... -- How it works... -- 2. Administrating the Core Database Engine -- Introduction -- Designing automated administration practices -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Implementing Security feature enhancements -- Getting ready -- How to do it... -- How it works... -- See Also.

Implementing Availability feature enhancements -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Implementing, Monitoring, and Tuning for performance -- Getting ready -- How to do it... -- How it works... -- Administering SQL Server workloads with Resource Governor -- Getting ready -- How to do it... -- How it works... -- There's more... -- Designing SQL Server Agent scheduled jobs for ETL processes -- Getting ready -- How to do it... -- How it works... -- There's more -- Troubleshooting multi-server instances with utility administration -- Getting ready -- How to do it... -- How it works... -- Administering SQL Server Replication processes -- Getting ready -- How to do it... -- How it works... -- See Also -- 3. Managing the Core Database Engine -- Introduction -- Implementing Central Management feature enhancements -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Designing Multi-server management from SQL Server 2008 R2 -- Getting ready -- How to do it... -- How it works... -- Managing the Utility Control Point data warehouse database -- How to do it... -- How it works... -- Implementing Utility & Non-utility collection sets -- Getting ready -- How to do it... -- How it works... -- Designing and refreshing a Scalable Shared database -- Getting ready -- How to do it... -- How it works... -- There's more… -- Managing SQL Server Replication processes -- How to do it... -- How it works… -- Implementing security for SQL Server Agent jobs management -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Multiserver Management Using Utility Explorer -- Getting ready -- How to do it... -- How it works... -- 4. Administering Core Business Intelligence Services -- Introduction -- Preparing and installing SQL Server Analysis Services.

Getting ready -- How to do it... -- How it works... -- There's more… -- Implementing Scale-Out of SQL Server Analysis Services -- Getting ready -- How to do it... -- How it works... -- Administering SQL Server Reporting Services -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Implementing Scale-Out deployment of SQL Server Reporting Services -- Getting ready -- How to do it... -- How it works... -- There's more… -- See Also -- Preparing and installing SQL Server Integration Services -- Getting ready -- How to do it... -- How it works... -- Managing the ETL process efficiently -- How to do it... -- How it works... -- 5. Managing Core SQL Server 2008 R2 Technologies -- Introduction -- Planning and implementing Self-Service Business Intelligence services -- Getting ready -- How to do it... -- How it works... -- There's more… -- Implementing Microsoft StreamInsight Technologies Platform -- Getting ready -- How to do it... -- How it works... -- Implementing SQL Azure connectivity features -- Getting ready -- How to do it... -- How it works... -- There's more… -- Installing and configuring a Master Data Services Solution -- Getting ready -- How to do it... -- How it works... -- Designing and deploying framework to use Master Data Services -- Getting ready -- How to do it... -- How it works... -- 6. Improving Availability and enhancing Programmability -- Introduction -- Preparing new Failover Cluster features -- Getting ready -- How to do it... -- How it works... -- Installing and configuring Failover Cluster Services -- Getting ready -- How to do it... -- How it works... -- Recovering and troubleshooting Failover Cluster Failure -- Getting ready -- How to do it... -- How it works... -- See also -- Implementing Database Mirroring features and performance enhancements -- Getting ready -- How to do it...

How it works... -- See also -- Managing Database Mirroring in a Failover Cluster environment -- Getting ready -- How to do it... -- How it works... -- Managing Log Shipping scenarios in a Database Mirroring environment -- Getting ready -- How to do it... -- How it works... -- Improving Replication scalability at multiple sites -- Getting ready -- How to do it... -- How it works... -- Implementing compressed storage features for tables and indexes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Designing a storage solution for unstructured data and new collations -- Getting ready -- How to do it... -- How it works... -- There's more... -- Designing data partitioning solutions for tables and indexes -- Getting ready -- How to do it... -- How it works... -- Implementing sparse columns and wide table features -- Getting ready -- How to do it... -- How it works... -- Designing spatial data storage methods -- Getting ready -- How to do it... -- How it works... -- Deploying and managing data-tier applications -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 7. Implementing New Manageability Features and Practices -- Introduction -- Implementing auditing and service level security features -- Getting ready -- How to do it... -- How it works... -- Managing server-level securable and database-level permissions -- Getting ready -- How to do it... -- How it works... -- Implementing backup compression for a VLDB environment -- Getting ready -- How to do it... -- How it works... -- Designing change tracking methodology -- Getting ready -- How to do it... -- How it works... -- Implementing Policy-Based Management features -- Getting ready -- How to do it... -- How it works... -- There's more... -- Implementing and running PowerShell for SQL Server features -- Getting ready -- How to do it...

How it works... -- There's more... -- Implementing the SQL Server Best Practices Analyzer -- Getting ready -- How to do it... -- How it works... -- Designing Transparent Data Encryption features -- Getting ready -- How to do it... -- How it works... -- There's more... -- 8. Maintenance and Monitoring -- Introduction -- Implementing performance baseline practices -- Getting ready -- How to do it -- How it works... -- There's more. -- See Also -- Monitoring resource usage with Extended Events -- Getting ready -- How to do it... -- How it works... -- There's more -- Implementing Management Data Warehouse features -- Getting ready -- How to do it… -- How it works... -- There's more... -- Designing maintenance tasks on a mission-critical environment -- Getting ready -- How to do it... -- How it works. -- Implementing Piecemeal restore strategies -- Getting ready… -- How to do it... -- How it works... -- There's more... -- Planning and designing of a Disaster Recovery environment -- Getting ready -- How to do it... -- How it works... -- Implementing sustainable index maintenance practices for a VLDB & 24/7 environment -- Getting ready -- How to do it... -- How it works... -- Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment -- Getting ready… -- How to do it... -- How it works... -- Configuring a server storage system for scalability -- Getting ready… -- How to do it... -- How it works... -- Configuring SQL server storage architecture for quick recovery -- Getting ready -- How to do it... -- How it works... -- Managing a storage system for analyzing bottlenecks -- Getting ready -- How to do it... -- How it works... -- 9. Troubleshooting -- Introduction -- Implementing systematized monitoring methods for data platform optimization -- Getting ready -- How to do it... -- How it works...

Designing a filtered indexes and statistics feature.