Full Day SSIS: Problem, Design, Solution Pre-con

Speakers:

Brian Knight, a SQL Server MVP, MCITP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. He is the author of a dozen SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.

Devin Knight, a Microsoft MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the President of the local users group (JSSUG).

Session Details:

Join this full-day session to learn how to solve real world data extraction problems using SSIS with a variety of battle tested design patterns.

The session will start out with one of the most common challenges in ETL: data warehouses. We will show you a variety of competing patterns to load your dimensions and facts more efficiently and discuss the pros and cons of each. You’ll learn how to use SQL Server Change Data Capture integration into SSIS (CDC) and incremental loads to effectively load your data warehouse in the fastest way possible.

One of the most common design patterns needed is how to deal with duplicate data. The speakers will show an end-to-end solution to scrub duplicate data and give rows a scoring system to sift out the best records. You'll also see a number of advanced patterns for lesser-used tasks in SSIS like Term Extraction and Data Mining Transform.

These are just a few of the patterns that we will be demonstrating. With all of the solutions shown, you will be given an end-to-end project with all the packages and data. You'll come out of the session with a lot of options on how to do your ETL job.

Remember to bring your laptop since you’ll be able to work with the speakers on many of the patterns.

Also, please note that you will want to have at least beginner SSIS experience for this session.