StreamInsight and SQL 2008 R2 should be RTM in May 2010. See this article for more info about the release.

I'm excited about the great new features! It's a good time to be a SQL Server user!

Jon