Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag StreamInsight Rss

   Items 1 to 18 of 18   
 

Stairway to StreamInsight

Microsoft StreamInsight™ is designed to assist in developing Complex Event Processing (CEP) applications in .NET This is appropriate for stream sources tsuch as those in manufacturing applications or financial trading applications. StreamInsight provides the means to monitor, manage, and mine several sources simultaneously for conditions,trends, exceptions, opportunities, and defects almost instantly. It is ideal for performing low-latency analytics on the events and triggering response actions, and for mining historical data to continuously refine and improve definitions of alerting conditions. Johan provides a simple explanation of the system in a series of practical articles.  Read more...

Testing the StreamInsight Service for Windows Azure

Getting 'up to speed' with StreamInsight is easier if you take the time to run it and test it out. Roger Jennings expains how to be up and running in nine simple steps, once you've sorted out the prerequisites  Read more...
By Additional Articles 2013/03/15 | Source: SimpleTalk | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,091 reads

When does a Tumbling Window Start in StreamInsight

Whilst getting some courseware ready I was playing around writing some code and I decided to very simply show when a window starts and ends based on you asking for a TumblingWindow of n time units in StreamInsight. I thought this was going to be a two second thing but what I found was something I haven’t yet found documented anywhere until now.  Read more...
By Additional Articles 2011/04/21 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,987 reads

Mouse Clicks, Reactive Extensions and StreamInsight Mashup

I had an hour spare this afternoon so I wanted to have another play with Reactive Extensions in .Net and StreamInsight. I also didn’t want to simply use a console window as a way of gathering events so I decided to use a windows form instead. The task I set myself was this. Whenever I click on my form I want to subscribe to the event and output its location to the console window and also the timestamp of the event.  Read more...
By Additional Articles 2011/03/18 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 2,006 reads

Using SQL Server Integration Services and StreamInsight Together

The purpose of this paper is to provide guidance for enriching data integration scenarios by integrating StreamInsight with SQL Server Integration Services. Specifically, we looked at the technical challenges and solutions for such integration, by using a case study based on a customer scenarios in the telecommunications sector.  Read more...
By Additional Articles 2011/02/17 | Source: SQLCAT | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,261 reads

Linqpad and Autocompletion

I have mentioned before about doing development for StreamInsight in Linqpad. I have it installed on two separate PCs and I have enabled autocompletion on only one of them. Whilst both versions are an excellent tool, the one with autocompletion enabled is so much easier to use. After enabling autocompletion you can see I now get parameter listing   Read more...
By Additional Articles 2010/12/23 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 2,057 reads

Linqpad and StreamInsight

Slightly before the announcement of StreamInsight being available for Linqpad I downloaded it from here. I had seen Roman Schindlauer demonstrate it at Teched and it looked a really good tool to do some StreamInsight dev. You will need .Net 4.0 and StreamInsight installed.  Read more...
By Additional Articles 2010/12/16 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 2,540 reads

Pulling real-time data from Twitter using StreamInsight

An example of building a StreamInsight input adapter for retrieving Twitter data in real-time.  Read more...
By Johan Åhlén 2010/09/29 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 8,096 reads

SQL Profiler Through StreamInsight Sample Solution

In this postI show how you can use StreamInsight to take events coming from SQL Server Profiler in real-time and do some analytics whilst the data is in flight. Here is the solution for that post. The download contains Project that reads events from a previously recorded trace file Project that starts a trace and captures events in real-time from a custom trace definition file (Included) It is a very simple solution and could be extended.  Read more...
By Additional Articles 2010/09/21 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,790 reads

Issuing Current Time Increments in StreamInsight (A Practical Example)

The issuing of a Current Time Increment, Cti, in StreamInsight is very definitely one of the most important concepts to learn if you want your Streams to be responsive. A full discussion of how to issue Ctis is beyond the scope of this article but a very good explanation in addition to Books Online can be found in these three articles by a member of the StreamInsight team at Microsoft, Ciprian Gerea.  Read more...
By Additional Articles 2010/09/15 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,354 reads

AdvanceTimePolicy and Point Event Streams In StreamInsight.

There are a number of ways to issues CTIs (Current Time Increments) into your StreamInsight streams but a quite useful way is to do it declaratively on your source factory like this  Read more...
By Additional Articles 2010/09/09 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,151 reads

Streaming Profiler Data Through StreamInsight

Using the Trace Management objects API it is possible to capture the events happening on SQL Server or indeed Analysis Services. I got to thinking that this would be a good thing to stream out in real time in StreamInsight and do some analysis “In Flight”. So here is a short video of me doing just that.  Read more...
By Additional Articles 2010/08/31 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,885 reads

Additional Columns in StreamInsight Event Flow Debugger

This tool is excellent when investigating what is going on in your StreamInsight Streams. I was looking through the menu items recently and went to Query => Event Fields I found that there were a couple of columns not added by default to the event viewer (Reminds me of the fact that the Variables viewer in SSIS hides columns also) Latency NewEndTime EnqueueTime Here they all are together. This gives us even more information about what is going on  Read more...
By Additional Articles 2010/08/19 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,231 reads

Performing a Left Anti Semi Join in StreamInsight

Performing a LEFT OUTER JOIN in TSQL is easy. The same logic in StreamInsight requires a little more work. In this presentation I show exactly how you can perform a LEFT OUTER JOIN on your event streams. Your browser cannot play this video. Learn how to fix this.   Read more...
By Additional Articles 2010/08/17 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 2,013 reads

Getting started with StreamInsight

A quick-start to SQL Server StreamInsight and Complex Event Processing with a step-by-step example on stock quotes.  Read more...
By Johan Åhlén 2010/03/17 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 7,392 reads

What is StreamInsight and why does it matter?

An introduction to SQL Server StreamInsight and Complex Event Processing with a focus on Business Intelligence.  Read more...
By Johan Åhlén 2010/01/25 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 7,223 reads

Building a Yahoo Finance input adapter for SQL Server StreamInsight

Step by step guide to building and debugging a SQL Server StreamInsight input adapter.  Read more...
By Johan Åhlén 2009/11/25 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 6,473 reads

Introducing Microsoft’s Platform for Complex Event Processing

While typical relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high event data rates, continuous queries, and millisecond latency requirements that make it impractical to persist the data in a relational database for processing. These requirements are shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring. Event-driven applications use complex event processing (CEP) technology with the goal of identifying meaningful patterns, relationships and data abstractions from among seemingly unrelated events and trigger immediate response actions.   Read more...
By Additional Articles 2009/10/28 | Source: Microsoft MSDN | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,825 reads
   Items 1 to 18 of 18   
 
Tags
stairway series (5)    
complex event processing (3)    
profiler (2)    
algorithmic trading (1)    
business intelligence (1)    
event driven architecture (1)    
event stream processing (1)    
integration services (ssis) (1)    
sql azure (1)    
sql server 2008 r2 (1)    
twitter (1)