This is excellent news. I've been looking forward to these features for ages. Because I live in a place that's on the half hour (Adelaide is GMT+0930) and has daylight savings opposite to the northern hemisphere (spending Christmas ahead an hour, not July), I've been particularly keen on the new datetimeoffset type.
There is a great page showing which features have been added to this CTP, at https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470. And you can download the latest CTP from http://connect.microsoft.com/sql.
Considering that the product release date is set to February 27, 2008 – less than 7 months away, I want all the features to appear as soon as possible, so I can present on them to my user-group, at Code Camps, etc.