Streaming Profiler Data Through StreamInsight

by Allan Mitchell 4 Aug 2010 23:40
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.   Your browser cannot play this video. Learn how to fix this.

Performing a Left Anti Semi Join in StreamInsight

by Allan Mitchell 18 Jul 2010 09:54
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.

Sorting data in the SSIS Pipeline (Video)

by Allan Mitchell 29 May 2010 20:27
In this post I want to show a couple of ways to order the data that comes into the pipeline.  a number of people have asked me about this primarily because there are a number of ways to do it but also because some components in the pipeline take sorted inputs.  One of the methods I show is visually easy to understand and the other is less visual but potentially more performant.

Optimising Lookups with the Cache Transform (Video)

by Allan Mitchell 14 May 2010 15:40
How to optimise doing the same lookup multiple times. [More]

The Pipeline Limiter in SQL Server Integration Services (Video)

by Allan Mitchell 14 May 2010 11:51
Not many people understand that the Integration Services pipeline can be intentionally throttled back under the covers to stop you from running out of memory.  In this video we show you how to detect this is happening and explain more about the limiter itself. More...


Comment RSS