SQL Server2008功能简介(Summary of Useful Features in SQL Server 2008)

SQL Server2008功能简介(Summary of Useful Features in SQL Server 2008)

SQL Server 2008 will be coming out sometime this summer (in theory). At last week's TechFuse event in Minneapolis, and in blogs I sometimes read, I've started to pick up on a number of useful features and improvements that should make one strongly consider upgrading when the Release to Market (RTM) is ready (certainly this is not all-inclusive):

Encryption at rest

Whole databases can be encrypted with a master key (which can be stored in an HSM), rather than encrypting by each column. No code changes are required, hence this feature is called Transparent Data Encryption. It gives true encryption of data at rest, included backup files.

• Blog: SQL Server 2008 Transparent Data Encryption
• Books Online: Understanding Transparent Data Encryption (TDE)

Filtered indexes

An index can be created with a filter (i.e. index all rows where MyDateField is not null), thus making much more meaningful indexes &rarrow; improved performance.

• Blog: SQL Server 2008 filtered indexes in 5 minutes
• Books Online: Filtered Index Design Guidelines