Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Chapter 3. Managing the Core Database Engine

In this chapter, we will cover:

  • Implementing Central Management feature enhancements

  • Designing Multi-server management from SQL Server 2008 R2

  • Managing Utility Control Point data warehouse database

  • Implementing Utility and Non-utility collection sets

  • Designing and refreshing Scalable Share database features and enhancements

  • Managing SQL Server Replication processes

  • Implementing security for SQL Server Agent jobs management

  • Using Utility Explorer to manage multiple instances