Skip Main Navigation
Page Content
This event has ended

SQL Saturday #89 Pre-Conference # 2 - Data Warehousing with SSIS Deep Dive by MS SQL MVP ----John Welch

Atlanta MDF

Friday, September 16, 2011 from 9:00 AM to 5:00 PM (EDT)

SQL Saturday #89 Pre-Conference # 2 - Data Warehousing...

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Pre-Con Attendee (Early bird rate before July 1, 2011) 43 Tickets Ended $89.00 $5.88
Pre-Con Attendee 9 Tickets Ended $99.00 $6.43

Share SQL Saturday #89 Pre-Conference # 2 - Data Warehousing with SSIS Deep Dive by MS SQL MVP ----John Welch

Event Details

 

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   Logging

o   Restartability and Recoverability

o   Auditing

-          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   Transactional

o   Periodic Snapshot

o   Accumulating Snapshot

o   Advanced Fact Patterns

-          Errors

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



 

 

 

 

Have questions about SQL Saturday #89 Pre-Conference # 2 - Data Warehousing with SSIS Deep Dive by MS SQL MVP ----John Welch? Contact Atlanta MDF

When & Where


Georgia State University- Alpharetta Center
3775 Brookside Parkway
Alpharetta, GA 30022

Friday, September 16, 2011 from 9:00 AM to 5:00 PM (EDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.