Implementing New Manageability Features and Practices - Microsoft SQL Server 2008 R2 Administration - page 263

7

Implementing New
Manageability
Features and
Practices

In this chapter, we will cover:

F Implementing auditing and service level security features
F Managing server-level securable and database-level permissions
F Implementing backup compression for a VLDB environment
F Designing change tracking methodology
F Implementing Policy-Based Management features
F Implementing and running PowerShell for SQL Server features
F Implementing SQL Server Best Practices Analyzer
F Designing Transparent Data Encryption features

Introduction

Manageability is highly essential to optimize database management. Since SQL Server
2005, manageability has been integrated as a management tool suite with support for the
automation of day-to-day tasks. There are multiple features within the core database engine,
and the SQL Server Management Studio tool provides integrated management, proactive
health monitoring, and improved performance techniques.