The slide deck from the session on SQL Server 2008 Spatial Queries I did at the North East Scotland .NET User Group is available for downloading from my website.
As requested on the night here is the link to the February 2008 CTP of SQL Server 2008 (aka CTP6).
The Blog of Colin Mackay 