Here is a good summary of cool new features as per latest Community Technology Preview (CTP) for SQL Server 2008.

Article here