Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 87

3

Managing the Core
Database Engine

In this chapter, we will cover:

F Implementing Central Management feature enhancements
F Designing Multi-server management from SQL Server 2008 R2
F Managing Utility Control Point data warehouse database
F Implementing Utility and Non-utility collection sets
F Designing and refreshing Scalable Share database features and enhancements
F Managing SQL Server Replication processes
F Implementing security for SQL Server Agent jobs management
F Using Utility Explorer to manage multiple instances

Introduction

The goal of this chapter is to design, implement, and manage an effective core database
engine to produce a resilient data platform. The core database engine is the main platform
for managing all of the business data for your organization-both archived and current-in a
relational database management system. The physical and logical architecture we choose
for SQL Server can have a dramatic impact on the system's ability to stand as mission-critical
databases that are flexible and scalable. As a DBA and advanced user of SQL Server 2008
R2, you have to develop best practices that combine a streamline of services for deployment,
migration, and management of your data platform.