Microsoft StreamInsight 2.3 for SQL Server 2014

To coincide with the release of Microsoft SQL Server 2014, Microsoft StreamInsight has been updated to version 2.3. StreamInsight 2.3 is strictly a licensing update to version 2.1 that allows you to use StreamInsight with a SQL Server 2014 license. Any code written against StreamInsight 2.1 works the same in version 2.3. You can get…

1

StreamInsight: More Than Just an API

If you’re evaluating StreamInsight you should know that it’s more than just an API for writing streaming queries. Included with the StreamInsight installation are powerful tools that allow you to manage, monitor, tune, and troubleshoot your streaming data applications. These tools range from diagnostic methods and properties built into the API to a full graphical…

0

What Is StreamInsight? A Primer for Non-Programmers

Are you trying to figure out whether StreamInsight might be something you could use, but you’re having trouble sifting through all the programming jargon that’s used to describe it? StreamInsight is, ultimately, a set of programming tools, and at some point it takes a programmer to implement a StreamInsight solution. But it really should be…

5

Getting Started with StreamInsight 2.1

If you’re just beginning to get familiar with StreamInsight, you may be looking for a way to get started. What are the basics? How can I get my first StreamInsight application running so I can see how it works? Where is the ‘front door’ that will get me going? If that describes you, then this…

1

StreamInsight will not push feature releases through Microsoft Update going forward

Until now, we’ve released StreamInsight through the Microsoft Download Center, and also released it out through Microsoft Update. Going forward, we will only release new StreamInsight versions through the Microsoft Download Center and only use MU to release service packs and security fixes (should any be needed). As a result of this decision, we are…

0

Using Subjects to Deploy Queries Dynamically

In the previous blog posting, we showed how to construct and deploy query fragments to a StreamInsight server, and how to re-use them later. In today’s posting we’ll integrate this pattern into a method of dynamically composing a new query with an existing one. The construct that enables this scenario in StreamInsight V2.1 is a…

1

Parameterized StreamInsight Queries

The changes in our APIs enable a set of scenarios that were either not possible before or could only be achieved through workarounds. One such use case that people ask about frequently is the ability to parameterize a query and instantiate it with different values instead of re-deploying the entire statement. I’ll demonstrate how to…

0

A Hitchhiker’s Guide to StreamInsight 2.1 Queries

Back in 2010 we released the first version of an educational guide to StreamInsight Queries to help developers mind shift into the new paradigm. With the release of StreamInsight 2.1 and introducing the New Programming Model, we thought this was the right time to freshen up this document. The format and the storyline stay mostly…

0

Dangers of time travel

I tend to partition StreamInsight operators into three classes: the basic “temporal/relational” operators; the “time travel” operators, and; the “elephant” operators. The basic operators illustrate the rules. The time travel operators bend the rules. The scan operators break them altogether. While I’d like to focus on time travel today, we can’t bend the rules before…

0

StreamInsight 2.1, meet LINQ

Someone recently called LINQ “magic” in my hearing. I leapt to LINQ’s defense immediately. Turns out some people don’t realize “magic” is can be a pejorative term. I thought LINQ needed demystification. Here’s your best demystification resource: http://blogs.msdn.com/b/mattwar/archive/2008/11/18/linq-links.aspx. I won’t repeat much of what Matt Warren says in his excellent series, but will talk about…

0