Looks like this event has already ended.
Check out upcoming events by this organizer, or organize your very own event.
SQL Saturday #89 Pre-Conference # 2 - Data Warehousing with SSIS Deep Dive by MS SQL MVP ----John Welch
Friday, September 16, 2011 from 9:00 AM to 5:00 PM (EDT)
Want to learn more about implementing data warehouse ETL with SQL Server Integration Services? Attend this full day seminar, and we’ll cover using SSIS for data warehousing in-depth. You’ll learn everything you need to know to populate your data warehouse with data. We’ll cover how to develop a common framework for your packages, automate the creation of rote packages for staging data, implement common patterns for handling various types of dimensions and fact tables, and how to instrument your packages to identify and recover from failures when loading data. We’ll be using the AdventureWorks databases for the examples, so bring along a laptop configured with SQL Server 2005 or later, and the AdventureWorks sample databases installed. We’ll also cover how the upcoming Denali release of SQL Server affects what we discuss in this seminar.
Topics will include:
- Laying out a framework for your ETL
o Restartability and Recoverability
- Common SSIS Tasks
o Using FTP to Retrieve Files
o Copying and Archiving Files
o Executing SQL Statements
o Moving Data
- Handling Dimensions
o SCD Type 1
o SCD Type 2
o Advanced Dimension Types
- Handling Facts
o Periodic Snapshot
o Accumulating Snapshot
o Advanced Fact Patterns
o Handling Processing Errors
o Handling Data Errors
o Recovering from Errors
- Performance Tuning SSIS
o Tuning Performance of the Data Flow
o Optimizing Data Warehouse Loads
- Best Practices for Managing Your ETL
John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server BI topics.
Seminar includes lunch and refreshments. Please email us with specific dietary restrictions by clicking on "Contact the Host" on the right side of the page. Thanks and see you there!
SQL Saturday #89, filled with many free sessions and events, will be held the next day. For more info and to register for SQL Saturday, please visit the event website:http://www.sqlsaturday.com/89/eventhome.aspx