There is a growing need for real-time analytics in a wide array of scenarios, including monitoring, fraud detection, logistics, clickstream analysis, and many others. While traditional tools like relational databases are extraordinarily effective at storing and querying data, they have their limitations: data have to hit disk before they are analyzed; streaming, continuously changing data are hard to deal with; and time-series queries are notoriously difficult to express in SQL. StreamInsight gives you a new tool, combining powerful temporal semantics with the ability to handle high volumes of real-time streaming data. This session will explore and demonstrate StreamInsight, show how it can be integrated into CLR applications to provide real-time analytic processing, and will include the first public preview of new features that will be release in StreamInsight 2.1.
Presented by Isaac Kunen at SQLBits X