Advanced SQL Server 2008 R2 StreamInsight Query Design Techniques

Sign in to queue

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

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

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.