22-25 April 2026 
Introduction of MS StreamInsight
2009TL; DR
StreamInsight is Microsoft's technology for Stream Data Processing and Complex Event Processing (CEP). In this session you will get an overview of what CEP is, what problems it tries to solve and how StreamInsight tries to do it.
Session Details
Complex Event Processing (CEP) based applications are becoming increasingly important. These types of applications are characterized by high event data rates, standing queries, and millisecond latency requirements that make it impractical to persist the data in a database before it is processed. You find requirements for these types of applications in quite a few vertical markets: financial trading, manufacturing, health care etc.
In this session we will look at a new technology from Microsoft which covers these requirements; StreamInsight. We will look in-depth how StreamInsight allows us to build these types of applications and also see the main components of StreamInsight.
3 things you'll get out of this session
Speakers
Rob Farley's previous sessions
The stuff about Joins they didnt teach you in school
Logical v Physical, Semi Joins, Lookup Joins, Redundant Joins - there is so much more to joins than you may have considered, and yet they are so fundamental to almost every query you ever write.
Where the bl**dy h*** are you? (Spatial Data Visualisation)
A look at spatial data visualisation, including the maps in SSRS 2008 R2, handling shapefiles for those of us who have to deal with maps outside the USA, geocoding addresses with Bing, using the Silverlight Bing Maps control, and even PivotViewer.
Understanding SARGability (to make your queries run faster)
SARGability relates to the ability to search through an index for a value, but many DB Pros don’t really get it – especially in regard to joins – leading to queries which don’t run as well as they should. No slides here, just demos...