Freigeben über

PDC Demos

  • Artikel

Many of you asked for the demos we showed at PDC. Attached is a .zip file containing two applications of StreamInsight that Torsten presented in his talk:

SimpleMonitor:

  • Simple example of a StreamInsight query with a WHERE clause to filter out stock quotes from a random stock quote feed.
  • The feed currently just generates "IBM" and "MSFT" quotes. You can play with the WHERE clause in the LINQ query and filter on "IBM" or "MSFT" as the symbol.

MarketMonitor:

  • More sophisticated StreamInsight application that uses multiple StreamInsight queries and outputs live results into Excel.
  • The random quotes feed is the same as in the SimpleMonitor. Use "MSFT" or "IBM" for the Ticker Symbol and "Stock", "NASDAQ", "US", and "NA" as values for the other filter expressions in the Workbench UI.

As a reminder, here are the links to the recordings and decks of our PDC talks, providing the context for these applications:

Introduction to Microsoft SQL Server 2008 R2 StreamInsight (level 200)

Advanced Microsoft SQL Server 2008 R2 StreamInsight (level 400)

StockMonitorPDC2009.zip

Comments

  • Anonymous
    December 02, 2009
    I had been playing around with StreamInsight and felt a little lost. Both talks were great. I look forward to using it.

  • Anonymous
    December 10, 2009
    So far I have seen nothing about StreamInsight with VB. Does it work in VB?

  • Anonymous
    August 18, 2010
    I am having trouble finding the IOBSERVABLE class in the existing StreamInsight framework can u hlp me to download it write to me at p.piyush@live.com

  • Anonymous
    August 18, 2010
    Piyush, IObservable was not included in StreamInsight RTM - see also this posting: blogs.msdn.com/.../observable-adapter.aspx Roman

  • Anonymous
    August 26, 2010
    Thanks for the response.Sorry for delay in mine. Actually I was unable to run the sample shared here without Obsevable Dll. Can u suggest an alternate.

  • Anonymous
    August 26, 2010
    Thanks team for your quick response and sorry for delay in mine. Actually I was trying to run the sample link given on this page. Can u suggest me an alternate to run this sample as it is not working without Observable dll Thanks

  • Anonymous
    April 18, 2013
    RussTodd, I can confirm that StreamInsight does work with Vb.Net. As a DBA, I find it quite useful to be able to use StreamInsight to analyse a SQL Trace in real time using a Vb.Net console application. Ajit Ananthram Blog - ajitananthram.wordpress.com