Advanced SQL Server 2008 R2 StreamInsight Query Design Techniques

Download this episode

Download Video

Description

SQL Server 2008 R2 StreamInsight makes it possible to build standing queries that monitor huge volumes of events in real time and take action when certain thresholds are met. In this session you will learn advanced StreamInsight query design techniques, including projection, filtering, joins, unions and aggregations. You will also learn how to use event windows to perform computations within an interval, including hopping, tumbling, snapshot and count windows. Advanced query concepts such as TopK, group and timestamp modification will also be covered.
For more information, check out this course on Microsoft Virtual Academy:

Day:

40

Code:

DAT302

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.