Sorry for the delay in getting this post up - I've been busy with the regular day job.
This was my second SQL Saturday - very fun, and very different from the first. I didn't happen to get to spend all day at the event - I spent the morning in downtown Seattle with the family. I wanted to be there in the morning to catch Scott Stauffer and Matt Masson's sessions - in fact, I missed Matt entirely! I'm sure I'll catch up with him sometime before the PASS Summit, if not then.
My session was extremely well attended, I thought - probably the highest headcount I've had staring back at me. The number and inquisitiveness of the questions confirmed to me that you guys were indeed paying attention and cared about the subject as well. I hope I was able to let you see a few of the options you have for loading your dimension tables with SSIS - and I know there are a couple of you waiting to see the demo package. Like I counseled in the session - try a few of them to see how they "feel" to you. Know that they all can be tweaked and altered - some more than others, of course, but that's why I showed you four techniques.
The slide deck is now posted on my SkyDrive, as well as the demonstration package. In order to run the fourth sample task in each package, you'll need to install the Kimball Method SCD Component from CodePlex. Feedback on the presentation would be great - I've set up an account at SpeakerRate - please provide some comments about things I could do better. For those that want more information on things like dimensional database design vs. normalized operational database design, you may want to review my other presentations/slide decks/demos - I've got them all listed on my Presentations Gallery page.
Hope to see you at SQL Connections, or the PASS Summit!
Todd, how was it different than the earlier one?
ReplyDeleteThe size was the largest difference - Portland was in several buildings, Redmond in one. Portland felt more like a "regular" conference - with an opening statement and all - but still wasn't. Redmond was more like a large user-group meeting. Both good, but different!
ReplyDelete