Microsoft SQL Server 2008 R2 Administration Cookbook电子书

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

Getting ready

How to do it...

How it works...

Implementing table hints for advanced query tuning performance

How to do it...

How it works...

Implementing query hints for optimized performance

How to do it...

How it works...

Designing sustainable locking methods to improve concurrency

How to do it...

How it works...

Implementing parallel query processing methods

Getting ready

How to do it...

How it works...

There's more...

See also

Implementing the plan guide to enhance compile-time and run-time execution plans

How to do it...

How it works...

There's more...

Configuring and managing storage systems for optimized defragmentation processes

Getting ready

How to do it...

How it works...

Building best usage processes of Dynamic Management Views

How to do it...

How it works...

Implementing a benchmarking framework on multiple instances

Getting ready

How to do it...

How it works...

There's more...

10. Learning the Tricks of the Trade

Introduction

Automated administration across an enterprise

Getting ready

How to do it...

How it works...

There's more...

See also

Administrating resource health policies

Getting ready

How to do it...

How it works...

Administrating multiple Analysis Services using Tools

How to do it...

How it works...

Managing events capture to troubleshoot problems

How to do it...

How it works...

See also

A. More DBA Manageability Best Practices

Index