Blog Post

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.



You rated this post out of 5. Change rating




You rated this post out of 5. Change rating