Thursday, January 13, 2011

SQL Server 2008 Features

Microsoft SQL Server 2008 provides a number of enhancements and new functionality, building on previous versions. Administration, database maintenance, manageability, availability, security, and performance, among others, all fall into the roles and responsibilities of the database administrator. This Post provides the top ten new features of SQL Server 2008 (referenced in alphabetical order) that can help DBAs fulfill their responsibilities.
1. Activity Monitor
2. SQL Server Audit
3. Backup Compression 
4. Central Management Servers
5. Data Collector & Management Data Ware House
6. Data Compression
7. Policy Based Management
8. Predictable Performance & Concurrency
9. Resource Governor
10. Transparent Data Encryption
To see the full description of features please explore the below given link: 

No comments:

Post a Comment