2 min read

StreamInsight 1.2 – New in SQL Server Code Name “Denali” CTP3

With Microsoft StreamInsight in SQL Server 2008 R2, we started to make Complex Event Processing capabilities available in Microsoft’s data platform. We are excited that the upcoming SQL Server Code Name “Denali”
release will include key improvements for StreamInsight. In this video, I will go over the highlights of the following four areas that are also available as part of SQL Server Code Name “Denali” CTP3:

     Resiliency against planned and unplanned downtime through checkpointing
The new resiliency features in StreamInsight let you run your mission-critical applications with tolerance to system failures and minimal operational downtime. It supports query recovery from failure by periodically checkpointing query state during normal operations. After the outage, the query recovers its query state from the last persisted checkpoint.

     Improved development experience through support for nested event type structures and additional LINQ expressions
Previously, StreamInsight event types needed to be flat lists of payload fields. The new version of StreamInsight enables users to express event types as nested structures, reducing the friction between your native event schemas and their representation in StreamInsight. A number of other improvements – like n-way joins, nested queries, and support for query macros – enhance the developer experience.

     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 the feature, lets you interact with an event stream in a procedural way. Unlike previous extensibility interfaces, UDSOs are not bound to StreamInsight windows, and can maintain their own state.

     Improved administrator experience through performance counters
and event log
In previous versions, StreamInsight runtime diagnostics were only available through StreamInsight’s diagnostic views. In this release, StreamInsight introduces support for diagnostics through the standard Windows performance counter infrastructure. This makes it easy to monitor the health and performance of StreamInsight applications using well-established tools, such as Performance Monitor. The new administrative event log in turn records administrative events and errors, which can be discovered, explored, and used via system tools such as Windows Event Viewer.

Get SQL Server Code Name “Denali” CTP 3 and StreamInsight 1.2 today!

Download SQL Server Code Name “Denali” CTP3 at: http://www.microsoft.com/denali
Download StreamInsight 1.2 directly at:

We’d love to hear your feedback on how the new features are working for you! 

Torsten Grabs
Program Manager
Microsoft StreamInsight Team