This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     

Introduction to StreamInsight

27th February 2013 - 28th February 2013

Who is it for?

This course is designed for BI professionals, analysts and database developers.  No experience of real-time processing and analysis of data is necessary.

What you will learn

The course outline, in detail, is as follows:   

Day 1

  • What is StreamInsight, what is Event Stream Processing and why would I use it?
  • Understanding the StreamInsight architecture and objects
  • StreamInsight Concepts
  • Streaming Data
  • Temporal Streams
  • Working with Time.
  • Working with Event Sources and Event Sinks.
  • Writing queries over Historic and Live data.
  • Projection
  • Filtering
  • Joins
  • Unions
  • Group and Apply
  • Time Stamp Modifications
  • User-Defined Functions
  • User-Defined Stream Operators
  • Using Event Windows

Day 2

  • Durability
  • Deploying StreamInsight applications
  • Debugging a StreamInsight Application
  • Labs: write analytical queries against a live/historic data source 

Key Benefits

Upon completion of this course attendees will have a solid understanding of SQL Server StreamInsight. This course will start from the fundamentals and build rapidly enabling attendees to understand what StreamInsight is, to start to write their first queries and deploy their applications.

Cost: £499 to Dec 31 2012, 549 from 1 Jan 2013 +VAT



A SQL Server MVP since 2004, Allan Mitchell is a very active member of the SQL Community, he presents regularly around the world and is a member of the SQLBits organising committee. He has helped author books on SSIS and is passionate about data quality and data integration using products such as SSIS, DQS and StreamInsight.



LMG Training and Development
15 Risborough Street

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration decoration decoration decoration