THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

SQL Server 2008 R2: What is StreamInsight used for

This blog has moved! You can find this content at the following new location:

Published Monday, January 11, 2010 4:16 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Giammarco Schisani said:

Interesting, but I am not really sure I see the need for such system. It sounds like it is used to "check something and do some decision" on, for example, an INSERT statement that is being executed against the database. I have the feeling that this approach is completely wrong and that such feature is completely unnecessary. If you want to "check something", then you should do that before executing the query. If you cannot do that, then you should be executing the query against a temporary table and then "check something" on that temporary table.

It's another one of those systems that I'll do my best never to use.

January 11, 2010 4:41 AM

Greg Low said:

When you say you should "check it before executing the query", I suspect you're assuming that the query is a database query. It's not. It's a standing LINQ query in .NET. This is done well before it goes anywhere near the database. The data is being queried in-flight in a .NET layer.

January 11, 2010 4:48 AM

Anonymous said:

I think Giammarco's question is indicative of what we're going to see a LOT of: the fact that this product is being released as part of SQL Server is going to confuse a lot of people. This probably should have been released as a separate product or through some .NET channel. Although perhaps there is no appropriate ship vehicle on that end? Maybe part of Windows itself would have been better?

January 11, 2010 9:50 AM

noeldr said:

+1 with Adam.

       Why is this bundled with SQL Server at all?

January 11, 2010 11:46 AM

Greg Low said:

I think Visual Studio would have been the correct channel for shipping it but I imagine it's gone into SQL Server as it's a channel that can be monetized. (Just my guess)

January 11, 2010 7:15 PM

Kalen Delaney said:

Thanks Adam... I was really going nuts thinking I was missing some crucial aspect of what StreamInsight was all about... I just could not see the SQL Server connection!

February 17, 2010 1:16 PM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement