diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


StreamInsight 1.2 Now Available In SQL Server Code Name “Denali” CTP3

With Microsoft StreamInsight in SQL Server 2008 R2, Microsoft started to make Complex Event Processing capabilities available in Microsoft’s data platform. The SQL Server team announced that the upcoming SQL Server Code Name “Denali” release will include key improvements for StreamInsight:

  • 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.

You can download StreamInsight 1.2 directly from Microsoft Download Center.

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...