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