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.

7 thoughts on “Who’s going to PASS next week?

  1. 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.

  2. 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?

  3. 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.

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.