Alastair Aitchison has started a series on doing spatiotemporal analysis using StreamInsight and the SQL Server spatial library over on his blog. I’ll certainly be watching how he makes out.

To answer one question he asks in his post: StreamInsight doesn’t require SQL Server Compact, but if you use it for you use it for your metadata provider, then the server metadata (applications, queries, and the like) will be persisted across restarts. This is required if you want to use resiliency for fairly obvious reasons.

Cheers,
-Isaac