Administrating the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 35

2

Administrating the
Core Database Engine

In this chapter, we will cover:

F Designing automated administration practices
F Implementing Security feature enhancements
F Implementing Availability feature enhancements
F Implementing Monitoring and Tuning for performance
F Administering SQL Server workloads with Resource Governor
F Designing SQL Server Agent scheduled jobs for ETL processes
F Troubleshooting multi-server instances with utility administration
F Administering SQL Server Replication processes

Introduction

SQL Server administration is one of the key responsibilities for every DBA to keep up the
availability, performance, and scalability of the data platform. This chapter will cover all the
aspects of database administration.

SQL Server 2008 R2 features include important elements as part of a toolkit to automate the
core database development and administration functionalities. To be a competent Developer
and Database Administrator, the user needs to have a firm understanding of the tools,
features and architecture of the system.