SQL Server 2008 R2 StreamInsight
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
Hands On Lab: Querying Events in SQL Server 2008 R2 StreamInsightusing LINQ
This Hands On Lab covers how to query events in SQL Server 2008 R2 StreamInsight using LINQ (Language Integrated Query).
Hands On Lab: Working with an End-to-End StreamInsightApplication
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…
Hands On Lab: Working with the SQL Server 2008 R2 StreamInsightEvent Flow Debugger
This Hands On Lab covers how to use the SQL Server 2008 R2 StreamInsight Event Flow Debugger.
Demo: Introducing SQL Server 2008 R2 StreamInsight
This demo covers the Highway Monitor simulation application and how to execute standing queries in SQL Server 2008 R2 StreamInsight.
![clip_image002[1]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/00/35/88/metablogapi/2553.clip_image0021_0DEB7426.gif "clip_image002[1]")
Demo: Querying Events in SQL Server 2008 R2 StreamInsight
This demo shows how how to execute the more common forms of LINQ queries when working against SQL Server 2008 R2 StreamInsight.
Demo: Advanced SQL Server 2008 R2 StreamInsightEvent Queries
This demo shows how how to execute the more advanced forms of LINQ queries when working against SQL Server 2008 R2 StreamInsight.
Demo: Working with SQL Server 2008 R2 StreamInsightCTI 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.
Demo: Creating a SQL Server 2008 R2 StreamInsightInput Adpater
This demo covers the basics for creating an input adapter that feeds events into the SQL Server 2008 R2 StreamInsight runtime engine.
Demo: Working with a SQL Server 2008 R2 StreamInsightDevelopment 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.
Demo: Using the SQL Server 2008 R2 StreamInsightEvent 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.
Presentation:Introducing SQL Server 2008 R2 StreamInsight
This presentation provides an overview of SQL Server 2008 R2 StreamInsight and Complex Event Processing.
Presentation:Querying Events in SQL Server 2008 R2 StreamInsight
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.
Presentation:Designing SQL Server 2008 R2 StreamInsightEvent Models and Adapters
This presentation covers how to design event models and adapters for SQL Server 2008 R2 StreamInsight.
This presentation covers how to install, deploy and maintain the SQL Server 2008 R2 StreamInsight runtime engine.
Presentation:Introducing SQL Server 2008 R2 StreamInsight(Part I)
Overview of complex event processing solution scenarios and competitive landscape. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Presentation:Introducing SQL Server 2008 R2 StreamInsight(Part II)
Overview of SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Introducing SQL Server 2008 R2 StreamInsight
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.
Presentation:Querying Events in SQL Server 2008 R2 StreamInsight(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.
Demo: Querying SQL Server 2008 R2 StreamInsightUsing LINQ
This demo covers the basics of querying SQL Server 2008 R2 StreamInsight using LINQ. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Presentation:Querying Events in SQL Server 2008 R2 StreamInsight(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.
Demo: Advanced SQL Server 2008 R2 StreamInsightEvent 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.
Presentation:Designing SQL Server 2008 R2 StreamInsightEvent 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.
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.
Demo: Working with SQL Server 2008 R2 StreamInsightCTI 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.
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.
Demo: Creating a SQL Server 2008 R2 StreamInsightInput 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.
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.
Part II of this presentation covers SQL Server 2008 R2 StreamInsight deployment models. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Choosing a SQL Server 2008 R2 StreamInsightDevelopment 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.
Part III of this presentation covers installing, monitoring and maintaining SQL Server 2008 R2 StreamInsight. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Using the SQL Server 2008 R2 StreamInsightEvent 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.