Fixing a gap in a prior post – Finding the Top Category with a Tumbling Window

In a prior blog post – http://blogs.msdn.com/b/appfabriccat/archive/2010/11/03/streaminsight-query-pattern-find-the-top-category-using-order-by-take-and-applywithunion.aspx– I discussed how to determine the top category in a set of events using order by and take.  However, I only covered non-overlapping aggregate windows (i.e. Tumbling windows).  I did not cover how you have to adjust your query definition for overlapping (Hopping) windows.  Since this question came…

0

Rounding up a few StreamInsight blog posts

Wanted to throw together a quick list of a few recent blog posts on the AppFabric CAT team blog (where most of my more ‘technical’ articles end up), as well as some of my favorite articles that I’ve come across lately. Working with LINQPad StreamInsight- Creating a LINQPad data context (the short version) StreamInsight- Creating…

0

Adventures in performance tuning

Been a bit quiet on this blog lately, as most of my postings have ended up on the AppFabric CAT team blog.  As part of a recent effort to build a canned LINQPad data context to use with StreamInsight, I went through a few rounds of performance testing to create an application that could (in…

0

See you at PASS next week – presenting on StreamInsight and real-time analytics

While a pile of folks are off in Europe delivering some great content at TechED Europe with some great sessions: DAT301 – Introduction to Complex Event Processing with SQL Server 2008 R2 StreamInsight DAT301-LNC – Building Operational Intelligence Solutions with Microsoft SQL Server and StreamInsight DAT302 – Advanced SQL Server 2008 R2 StreamInsight Query Design…

0

Two new blog posts on StreamInsight over on the AppFabric CAT Blog

Two new blog posts over on the AppFabric CAT blog on StreamInsight: StreamInsight: Obscure LINQ error – The field ‘Key’ of type ‘IKey`1’ either contains a nested member, or is a type that is not supported as event type field.  A walkthrough of resolving a little issue I ran into while building out a project…

0

StreamInsight and reference data (lists, databases, etc)

Using reference data in StreamInsight is a very common scenarios; some examples would be: Monitoring process control event streams for values that exceed a given threshold (for example, a valve’s pressure exceeding a certain safety threshold). Enriching utility usage information in a smart metering scenario with user and geography information (for example, to allow visualization…

5

101’ish LINQ Samples for StreamInsight (part 1 – filtering and aggregation)

Following in the great tradition of other learn through example LINQ example pages, such as 101 LINQ Samples, here’s the first in a series of posts on StreamInsight query examples.  This will first show up on this blog, then get migrated over to a centralized site on the StreamInsight developer center.  We’ve got a fairly…

0

Creating a basic logging wrapper for StreamInsight adapters/applications using log4net

There are many different ways of implementing logging on the Microsoft .NET platform (Trace, ETW, etc).  To provide for a range of flexibility (not necessary for this post.. just setting the stage) let’s go ahead and put together a generic logging interface that we’ll use throughout various applications (all of the code samples I post…

2

Building your First End to End StreamInsight Application (Going Deep on Adapters)

So you’ve heard about this shiny StreamInsight thing, perhaps from my last post, and want to build something for yourself and understand how all of this stuff fits together.  At this point you should have your Visual Studio environment up and running, along with StreamInsight installed (if you don’t, have a look at this post). …

1