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.
SQL Server 2008 and SQL Server 2008 R2 have a flurry of manageability features in the database administration arena. In this chapter, we will go through the important features such as auditing, security, compression, change tracking, policy-based management, data-tier applications, and SQL Server PowerShell Provider Cmdlets
.