PacktLib: Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

Credits

Foreword

About the Author

Acknowledgment

About the Reviewers

www.PacktPub.com

Preface

Getting Started with SQL Server 2008 R2

Introduction

Adding SQL Server 2008 R2 Service Pack features using Slipstream technology

Designing a best practice approach to upgrading to SQL Server 2008 R2

There's more.

Working with Data-Tier applications

Designing and adopting SQL Server 2008 R2 solutions

Designing applications to use federated servers

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

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

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

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

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

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

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

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

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

More DBA Manageability Best Practices