Microsoft® SQL Server® StreamInsight full changelog

· Microsoft StreamInsight 2.1 introduces a new object model that is more clear and consistent than in earlier versions, eliminating the need for complex input and output adapters. This new model allows you to provision, name, and manage data sources and sinks in the StreamInsight server, and you can checkpoint over temporal streams and across multiple processes. Moreover, this version of StreamInsight allows to tightly integrate reactive (Rx) and temporal queries within the same hosting model.

· Resiliency against planned and unplanned downtime through checkpointing. Custom solutions to work around the problem of resiliency have typically been expensive to implement, and limited in their ability to prevent data loss and guarantee correctness of output after recovery. The new resiliency features in StreamInsight let you run your critical applications with tolerance to system failures and minimal operational downtime. StreamInsight resiliency supports recovering query state from the failure checkpointing system state at specific points in time during normal operations. After a failure, the query is made operational again by recovering the query state from this persisted store.
· Better support for predictive modeling and pattern matching scenarios through new user-defined stream operators. A user-defined stream operator, or UDSO as the team affectionately calls them, lets the user interact with the event stream in a procedural way.