Ruminations of idle rants and ramblings of a code monkey

SQL Saturday Baton Rouge Presentations

Code Sample | Community | Events

It was absolutely awesome to be back in Baton Rouge for Sql Saturday. I do miss going out there … used to be I was out there regularly but now – well, not so much. I did already post them on the Sql Saturday site but for anyone else that’s interested, I’m posting them here.

The first is not a new one but always a popular one … Back to Basics: .NET Essentials That You May Have Forgotten. I’ll also be doing this one at Houston TechFest in September.

The other one is new: StreamInsight In Action: Real-Time Web Monitoring. This was inspired by a project that I was recently on where we were doing performance analysis and testing. Here was the challenge … we needed to know exactly which pages were executing (and what some of the form post parameters were) when we had spikes in various performance counters. Unfortunately, load testing tools won’t give you this level of detail. And trying to synchronize web logs and perfmon logs is an exercise in futility. And that’s where StreamInsight comes in … since we can take multiple sources of data and synchronize them in time, it’s actually pretty easy to do something like this in StreamInsight. And that’s just the tip of the iceberg; once you start, there’s a lot of other things that you can do as well. For example, if you are analyzing web farm performance, you can get early warning if one of the servers in the farm is starting to “go off the reservation”. Or if your servers are starting to perform poorly or are just beginning to get over-capacity. It’s all about enabling you to be more proactive in managing and operating your web site(s) rather than waiting for uncomfortable emails or calls. This also has a little WinForms/Grid sink so you can see (exactly) the different events as they are output.