One of the most common things people want to know about spatial support in SQL Server is when they can get their hands on it. While I don't manage the final CTP schedule, I can say that all of the bits are in (modulo a few DCRs and the inevitable bug or two) and will be in the next CTP. I'd expect it in about a month.
I'll be posting more information and tackling common questions here. In addition, you can check out the spatial forum on MSDN. Also, if you happen to be in Las Vegas in November, you can come to my talk at SQL Connections.