SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Data Warehousing with SSIS

As a DBA why would I consider attending a pre-con by John Welch at SQL Saturday 89 titled Data Warehousing with SSIS?  For starters lets look at what all the session entails.

-          Laying out a framework for your ETL
Logging, Restartability and Recoverability, Auditing

-          Common SSIS Tasks
Using FTP to Retrieve Files, Copying and Archiving Files, Executing SQL Statements, Moving Data

-          Handling Dimensions
SCD Type 1, SCD Type 2, Advanced Dimension Types

-          Handling Facts
Transactional, Periodic Snapshot, Accumulating Snapshot, Advanced Fact Patterns

-          Errors
Handling Processing Errors, Handling Data Errors, Recovering from Errors

-          Performance Tuning SSIS
Tuning Performance of the Data Flow, Optimizing Data Warehouse Loads

-          Best Practices for Managing Your ETL

Out of the 7 topics only 1 is strictly about data warehouse.  The rest is all about SSIS and managing ETL.  As a production DBA I work a good bit with SSIS and support many ETL processes.  I might not get a great deal out of the portion about slowly changing dimensions but learning anything about SCD would be a good thing right.  At least then I could carry on a conversation and know a little about it.

So if you are a production DBA that wants to learn a great deal more about SSIS and tuning ETL processes then you really should consider attending John’s pre-con session at SQL Saturday 89 in Atlanta GA on September 16th.  You can’t beat the price of the class either.  $99 for 8 hours of training with lunch being included.  Don’t wait as space is limited.


Tim Radney - Database Professional

Tim Radney - Database Professional by Tim Radney I am a Sr DBA for a top 40 US bank. I live in the south eastern US. I have been working with database since 1999 but only full time for the past three years.


Posted by Anonymous on 8 August 2011

Pingback from  Dew Drop – August 8, 2011 | Alvin Ashcraft's Morning Dew

Posted by Anonymous on 9 August 2011

Pingback from  Dew Drop – August 9, 2011 | Alvin Ashcraft's Morning Dew

Leave a Comment

Please register or log in to leave a comment.