Pages

Sunday, July 26, 2009

Presenting at New Jersey's PASS Chapter in August

I'm off to see family in New Jersey - my brother is a professor at Montclair State - so I thought I'd see if there were any SQL usergroups in the area.  You know - have a real vacation by getting in some good work-related content.  (My wife still loves me.  I think.)  I figured there had to be - heck there are two in my "hometown" on the left coast.  The first place I looked was on the PASS website, and I found the New Jersey SQL Server User Group, run by Melissa Demsak - the SQLDiva.
More than a few emails went back and forth, and I talked my way into presenting at the August meeting.  I had a great experience at DevTeach that sparked some inspiration, so it was relatively easy to brainstorm a good list of topics.  Melissa ran that by some of her members, and they decided on a combination of a few ideas around typical Data Warehouse processing requirements - avoiding bad performance in IS, processing SCDs, and loading fact tables.
If you're in the area, and are interested in a little pizza, Data Warehousing, and Integration Services - please mark your calendar!
What
Loading a Data Warehouse using SSIS should be pretty easy – all the tools you’ll need are in the box. However, there are a few things you should avoid and non-obvious best practices to use to make that ETL faster and more reliable. Assuming attendees have a basic level of familiarity with Kimball Data Warehousing methodology, this talk will explain how to accomplish Kimball style ETL using SQL Server Integration Services. We'll review the SCD Wizard and how it works for processing your dimension tables - what it's good for, what it's not, and what alternatives you have to it. We'll also examine fact table loading using a surrogate key replacement pipeline, especially using the Lookup component efficiently. Finally, we’ll look at specific and easy performance tweaks, techniques and best practices. Depending on time constraints, that can include reviewing which Data Flow components to avoid and how to still get your work done without them, tuning inserts and updates, or issues from the audience.
That's a lot to cover in one presentation, so there won't be a great amount of depth in any one area - there are simply too many tips and best practices!  However, it ought to give everyone a very good understanding of how SSIS implements Kimball style Data Warehouse loading.  A good portion of the performance portion of the presentation will be open to the floor - I have plenty to talk about, but specific questions are welcome.
When
The monthly NJSQL meeting will be on Thursday, August 13th.  Festivities start at 6pm and the presentation should start at around 6:30.
Where
The NJSQL user group meets in space graciously provided by SetFocus in Parsippany at 4 Century Drive.  I'd love to see you there!  (I'll even have some door prizes to add to the pot, if I can find some space to pack them.)

No comments:

Post a Comment