Who’s going to PASS next week?
I’ll be there. In fact I’m sure just about everyone who is anyone in the world of MDX will, like me, be there on Monday at Mosha’s MDX seminar – assuming, of course, that Mosha actually makes it himself this time…!
Anyway, if you see me, say hello, and come along to my session first thing on Thursday morning. I’m going to be speaking about "How to build a SSIS, SSRS and SSAS monitoring solution using SSIS, SSRS and SSAS" – basically building a data warehouse to hold all the logging data that the three servers produce, building a cube on top and writing some queries/building reports so you can visualise activity. I submitted the abstract for this before I’d done any work on the subject and of course soon came to realise that it’s a massive topic, so I’ve been working like mad for the past few weeks to get my demos and slides together. But I will have some cool stuff to show, I promise, even though I’ll still be putting the finishing touches to it 5 minutes before the session starts.

I wish I could have been going to PASS this year, but unfortunately it was not possible
Darren
November 16, 2008 at 12:40 pm
See you.
Tomislav
November 16, 2008 at 2:28 pm
You aren\’t by chance going to release that presentation online after the PASS conference are you?
Frank
November 18, 2008 at 6:01 pm
What, my presentation? It\’ll be available for download via the PASS site I think.
Chris
November 18, 2008 at 11:18 pm
Sounds cool.
Did a very similar thing for an IT department to collect data review there server usage for a consolidation exercise and capacity planning. Worked well though we did it as POC and didn\’t get too much time and hence had a few issues. Would be good to see someone else\’s approach to the same problem.
Shaun
November 19, 2008 at 4:18 pm
Hi Chris,
I\’ve attended your session @ SQLPASS. Great stuff! Actually the whole conference was amazing this year.
Do you plan on publishing your solution online? I can try to build it myself but hey, why re-invent the wheel?
Frenk
November 26, 2008 at 2:20 pm
I need to get onto PASS to make sure the proper version of my slides and the code are all available for download from the PASS website. I\’ve uploaded them, but they\’ve only got the draft version of my slides from a few months ago available to download still. I\’m not sure I\’m allowed to put them up for download anywhere else.
Chris
November 27, 2008 at 12:27 am