For all those friends who are interested in integrating CEP with BizTalk, check out the white paper by Jesus Rodriguez at :
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6c1da607-4785-4668-a274-6898c38ea603StreamInsight is part of SQL 2008R2. You have to read on StreamInsight before checking out this paper.
This paper is very conceptual and does not provide any code snippets. If you are looking for some code samples, then use the samples that come with StreamInsight download and extend them.