SQL Server 2008 R2 introduces StreamInsight, a comprehensive development platform for building event-driven applications. While typical relational database applications are query-driven, event-driven applications are characterized by high event data rates, continuous standing queries, and millisecond latency requirements that make it impractical to store the data in a relational database for processing.

Event driven application workloads are common in many different industries, including manufacturing, oil and gas, utilities, financial services, health care, retail, web analytics, and data center monitoring. Developers turn to complex event processing (CEP) technology like StreamInsight to query, monitor and identify patterns and relationships from huge volumes of seemingly unrelated events, then trigger response actions when specific conditions are met.

Lessons

  • clip_image002

Hands On ​Lab: ​Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight​using LINQ

This Hands On Lab covers how to query events in SQL Server 2008 R2 StreamInsight using LINQ (Language Integrated Query).

  • clip_image004

Hands On ​Lab: ​Working ​with an ​End-to-End ​Stream​Insight​Application

In this lab, you will explore the DiagnosticVersion edition of the Highway Monitor sample application, as an example of an end-to-end StreamInsight application. This will help you to get started with developing your own solutions, as you will likely start your own solutions by adapting the ideas…

  • clip_image006

Hands On ​Lab: ​Working ​with the ​SQL Server ​2008 R2 ​Stream​Insight​Event Flow ​Debugger

This Hands On Lab covers how to use the SQL Server 2008 R2 StreamInsight Event Flow Debugger.

  • clip_image008

Demo: ​Introducing ​SQL Server ​2008 R2 ​Stream​Insight

This demo covers the Highway Monitor simulation application and how to execute standing queries in SQL Server 2008 R2 StreamInsight.

  • clip_image002[1]

Demo: ​Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight

This demo shows how how to execute the more common forms of LINQ queries when working against SQL Server 2008 R2 StreamInsight.

  • clip_image010

Demo: ​Advanced ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Queries

This demo shows how how to execute the more advanced forms of LINQ queries when working against SQL Server 2008 R2 StreamInsight.

  • clip_image012

Demo: ​Working ​with SQL ​Server 2008 ​R2 Stream​InsightCTI ​Events and ​Advance ​Time ​Settings

This demo describes how to use the CTI (current time increment) and Advance Time Setting when processing events with SQL Server 2008 R2 StreamInsight.

  • clip_image014

Demo: ​Creating a ​SQL Server ​2008 R2 ​Stream​Insight​Input ​Adpater

This demo covers the basics for creating an input adapter that feeds events into the SQL Server 2008 R2 StreamInsight runtime engine.

  • clip_image016

Demo: ​Working ​with a SQL ​Server 2008 ​R2 Stream​Insight​Development ​Model

This demo walks you through the Implicit Development Model that could be used when building a complex event processing application with SQL Server 2008 R2 StreamInsight.

  • clip_image018

Demo: ​Using the ​SQL Server ​2008 R2 ​Stream​Insight​Event Flow ​Debugger

This demo shows how to use the SQL Server 2008 R2 StreamInsight Event Flow Debugger to capture trace activity from a running system.

  • clip_image019

Presentatio​n:​Introducing ​SQL Server ​2008 R2 ​Stream​Insight

This presentation provides an overview of SQL Server 2008 R2 StreamInsight and Complex Event Processing.

  • clip_image020

Presentatio​n:Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight

This presentation provides an overview of how to query events with SQL Server 2008 R2 StreamInsight, including architecture, writing standing queries with LINQ and advanced query options.

  • clip_image021

Presentatio​n:Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters

This presentation covers how to design event models and adapters for SQL Server 2008 R2 StreamInsight.

  • clip_image022

​Presentatio​n:​Installing, ​Deploying ​and ​Maintaining ​the SQL ​Server 2008 ​R2 Stream​Insight​Runtime ​Engine

This presentation covers how to install, deploy and maintain the SQL Server 2008 R2 StreamInsight runtime engine.

  • clip_image024

​Presentatio​n:​Introducing ​SQL Server ​2008 R2 ​Stream​Insight​(Part I)

Overview of complex event processing solution scenarios and competitive landscape. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image026

​Presentatio​n:​Introducing ​SQL Server ​2008 R2 ​Stream​Insight​(Part II) ​

Overview of SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image028

Demo: ​Introducing ​SQL Server ​2008 R2 ​Stream​Insight

This demo covers the HighwayMonitor simulation application and how to execute standing queries in SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image030

​Presentatio​n:Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight​(Part I)

Part I of this presentation covers the basics of how to write queries for SQL Server 2008 R2 StreamInsight using LINQ. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image032

Demo: ​Querying ​SQL Server ​2008 R2 ​Stream​Insight​Using LINQ ​

This demo covers the basics of querying SQL Server 2008 R2 StreamInsight using LINQ. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image034

​Presentatio​n:Querying ​Events in ​SQL Server ​2008 R2 ​Stream​Insight​(Part II) ​

Part II of this presentation covers how to use advanced query options when designing queries for SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image036

Demo: ​Advanced ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Queries

This demo shows how to build advanced SQL Server 2008 R2 StreamInsight standing queries using LINQ. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image038

​Presentatio​n:Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part I)

Part I of this presentation covers how to design an event model with SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image040

​Presentatio​n:Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part II) ​

Part II of this presentation covers how to use CTI (current time increment) entries to maintain query responsiveness in SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image042

Demo: ​Working ​with SQL ​Server 2008 ​R2 Stream​InsightCTI ​Events and ​Advance ​Time ​Settings

This demo describes how to use the CTI (current time increment) and Advance Time Setting when processing events with SQL Server 2008 R2 StreamInsight.

  • clip_image044

​Presentatio​n:Designing ​SQL Server ​2008 R2 ​Stream​Insight​Event ​Models and ​Adapters ​(Part III) ​

Part III of this presentation covers building input and output adapters for SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image046

Demo: ​Creating a ​SQL Server ​2008 R2 ​Stream​Insight​Input ​Adapter

This demo covers the basics for creating an input adapter that feeds events into the SQL Server 2008 R2 StreamInsight runtime engine. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image048

​Presentatio​n:​Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part I)

Part I of this presentation covers how to choose between the implicit server and explicit server development models offered in SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image050

​Presentatio​n:​Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part II) ​

Part II of this presentation covers SQL Server 2008 R2 StreamInsight deployment models. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image052

Demo: ​Choosing a ​SQL Server ​2008 R2 ​Stream​Insight​Development ​Model

This demo compares the various development model choices available when building a complex event processing application with SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image054

​Presentatio​n:​Installing, ​Deploying ​and ​Maintaining ​SQL Server ​2008 R2 ​Stream​Insight​(Part III) ​

Part III of this presentation covers installing, monitoring and maintaining SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

  • clip_image056

Demo: ​Using the ​SQL Server ​2008 R2 ​Stream​Insight​Event Flow ​Debugger

This demo shows how to use the SQL Server 2008 R2 StreamInsight Event Flow Debugger to capture trace activity from a running system and how to access diagnostic views via Powershell. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.

Digg This