Date: Thursday, August 13th (Yes…Thursday is correct for this month only!!!)
Agenda:
6:00pm - 6:30pm: Networking & Pizza
6:30pm - 6:40pm: NJSQL Community Updates
6:40pm: Presentation
Refreshments: Pizza/Soda
Sponsor: TBD
Give-A-Ways: TBD
Presenter: Todd McDermid
Topic: SSIS Tips and Tweaks
Topic Summary:
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 ETL using SQL Server Integration Services. We'll quickly 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, including use of the Lookup component for date-ranged lookups. 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.
Bio:
Todd McDermid has been developing software for about two decades, and most of that software has used SQL Server for data storage. He has primarily been involved with Manufacturing and Supply Chain projects, both in ISVs and as an internal IT resource. In recent years, he’s discovered Business Intelligence and the Microsoft platform – turning him into somewhat of an evangelist for using BI to support performance management in his current organization. To assist in achieving that goal, he’s used Integration Services to populate a Data Warehouse, using standard as well as custom built SSIS components. Along the way he’s earned his MCSD.Net and MCTS (on SQL08BI). He’s currently a moderator of the MSDN SSIS forums, coordinator of two CodePlex open-source projects, and frequent blogger on SSIS topics.
SQLDiva