I am currently writing a book for Simple-Talk Press on the top 10 new features in SQL Server 2008 that are of the most interest to DBA administrators. As you probably know, there are many more than 10 new features, and picking the top 10 is not an easy task. Below is a list of what I consider are some of the top new features, and I want to know what you think. Take a look at the following list, and then post your comments, letting me know what your top 10 favorites are. I have listed more than 10 below because I still haven't made a final decision on which 10 features to include in the book. Policy-Based Management Performance Data Collection with Performance Studio Data Compression Resource Governor New Data Types Transparent Data Encryption Database Mirroring Auditing Change Tracking and Change Data Capture LINQ Multi-server script execution Intellisense Extended events Integrated Full-Text Search Sparse columns New index types PowerShell integration If I have not listed your favorite new feature of SQL Server 2008, please let me know what it is.