Our regular meeting, with food provided and a raffle, followed by Office Hours at Clyde's of Chevy Chase (http://www.clydes.com/chevy-chase) across the street (downstairs bar). Bring your questions and build your network of SQL Server peers.
Choosing Sides in the ETL vs ELT Debate
Cameron Snapp, Manager/Architect CAPTECH VENTURES INC
The debate regarding the relative merits of extract transform load (ETL) and extract load transform (ELT) data migration strategies isn’t new, but it remains relevant. Making the right choice is critical, because the wrong solution will slow development cycles and execution times, and increase the cost and complexity of code maintenance. In this presentation, I’ll cover some best practices for implementing an ELT solution for a variety of data migration scenarios. Data enthusiasts of any level will benefit from a detailed discussion of methodologies, strategic benefits, and code examples.
Cameron Snapp is a MCSE and PMP certified IT Consultant with over 14 years of database development experience. He has worked on dozens of Micorsoft SQL Server OLTP, Datawarehouse, and Business Intelligence projects in the area. He holds a Computer Science degree from the University of Richmond and a Masters degree in IT Management from the University of Virginia. Cameron specializes in IT Projects related to data strategy, modeling, integration and reporting.