Microsoft StreamInsight

Official blog of the development team of StreamInsight.

TechEd 2010 StreamInsight Session and Demo

TechEd 2010 StreamInsight Session and Demo

  • Comments 9

It was great to meet you all in New Orleans at TechEd North America 2010. For those of you looking for my session “Microsoft SQL Server 2008 R2 StreamInsight: Come See the Value of Real-Time Data Management”, you can find the content here:

- Session video: http://www.msteched.com/2010/NorthAmerica/DAT204
- Slide deck: http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/DAT204.pptx

In the attached ZIP file, you can also find the code for the Market Monitoring demo with the Silverlight UI for the stock trend lines and the SQL output that I was demoing in the session. Please look for the Word document called “TechEd2010 Demo Script.docx” in the solution folder: it describes the prerequisites and the steps to run the demo.

Regards,
Torsten

Attachment: TechEdUS2010.zip
  • Hi Torsten!

    This file is corrupted

    Please fix it

    Thanks

  • Thanks for pointing this out - please try again.

    Regards,

    The StreamInsight Team

  • Thanks, Thanks, Thanks ...

  • "Start StreamInsight Engine" works. But "Listen to Output Adapter" and "Stop StreamInsight Engine" don't. What could be the problem?

  • Dan,

    Can you give us more information about your problem? What happens if you click on the said buttons? Do you see any exception? Is the server console window showing any output when you click on those buttons?

    Regards,

    Roman

  • Roman,

    Thanks for your help on this. When I click on "Start StreamInsight Engine", the server console continuously shows the output events. So, WCFDuplexTextClient is talking to WCFDuplexServer and the engine starts and works fine. When I then click on "Listen to Output Adapter", the text box displays "Listening to StreamInsight engine output now." But no output event is displayed there and the trend line chart remains empty. I finally click on "Stop StreamInsight Engine". The text box displays "Stopping StreamInsight engine." However, the server console continues to show output events.

    Dan

  • Roman,

    Thanks for your help on this:

    (1) When I click on "Start StreamInsight Engine", the server console continuously displays output events.

    (2) When I then click on "Listen to Output Adapter", the text box displays "Listening to StreamInsight engine output now." But the output events are not displayed and the trend line chart remains empty.

    (3) When I then click on "Stop StreamInsight Engine", the text box displays "Stopping StreamInsight engine." But the server console continue to display output events.

    There is no exception thrown.

    Dan

  • The zip download does nothing.

  • There is a known issue with this demo on StreamInsight 1.2. A simple workaround is to tweak the query in Queries.cs as follows (just adding the casts at the end):

               return from oneMinReading in quoteStream

                      group oneMinReading by new

                      {

                          oneMinReading.Ticker,

                          oneMinReading.AssetClass,

                          oneMinReading.Market,

                          oneMinReading.Country,

                          oneMinReading.Region

                      }

                      into oneGroup

                      from eventWindow in oneGroup.HoppingWindow(TimeSpan.FromSeconds(5), TimeSpan.FromSeconds(1), HoppingWindowOutputPolicy.ClipToWindowEnd)

                      select new RandomQuoteResult

                      {

                          Ticker = oneGroup.Key.Ticker,

                          AssetClass = oneGroup.Key.AssetClass,

                          Market = oneGroup.Key.Market,

                          Country = oneGroup.Key.Country,

                          Region = oneGroup.Key.Region,

                          AvgLast = eventWindow.Avg(e => e.Last),

                          AvgBid = eventWindow.Avg(e => e.Bid),

                          AvgAsk = eventWindow.Avg(e => e.Ask),

                          AvgVolume = (double) eventWindow.Avg(e => e.Volume),

                          AvgBidSize = (double) eventWindow.Avg(e => e.AskSize),

                          AvgAskSize = (double) eventWindow.Avg(e => e.BidSize),

                      };

Page 1 of 1 (9 items)
Leave a Comment
  • Please add 6 and 2 and type the answer here:
  • Post