SSIS Design Patterns and BIML: A Day of Intelligent Data Integration

I’m honored to deliver a brand new precon (the PowerPoint slides still have that new slide smell) at SQL Saturday #477 – Atlanta – BI Edition! The precon is titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration.

Abstract

Join Andy Leonard, founder of Enterprise Data & Analytics, SSIS coach and trainer, author, and consultant, for a day of training focused on intelligent data integration. Andy is an experienced SSIS consultant, but he also led an enterprise team of 40 ETL developers during projects that spanned 2.5 years. And delivered.

The target audience for this course is data integration developers and architects who want to learn more about SSIS performance, DevOps, execution, and automation.

Attendees will learn:
– a holistic approach to data integration design.
– a methodology for enterprise data integration that spans development through operational support.
– how automation changes everything. Including data integration with SSIS.

Topics include:
1. SSIS Design Patterns
   Data Flow Performance
   ETL Instrumentation
2. Executing SSIS in the Enterprise
   The SSIS Catalog – the good, the bad, and the ugly.
3. Custom SSIS Execution Frameworks
4. DevOps and SSIS
   A (Condensed) Sprint in the Life of a Data Integration Solution
   Version Control and SSIS
5. Business Intelligence Markup Language
   A Brief Introduction to Biml in BimlStudio
6. SSIS Design Patterns + Biml
   Putting the pieces together.
7. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks
   Executing the new combinations.
8. SSIS Design Patterns + Biml + Custom SSIS Execution Frameworks => DevOps
   Enterprise-class data integration with SSIS.

Register today!

I’m also presenting Using BIML as an SSIS Design Patterns Engine at SQL Saturday #477 – Atlanta – BI Edition! Right after my presentation, Scott Currie (the guy who created Mist and BimlOnline, and who shepherds Biml) is presenting SSIS Unit and Integration Testing with the Open Source BEST project!

As if that’s not enough, Patrick LeBlanc and Adam Saxton are also delivering a precon titled Microsoft BI in a Day. There are tons of really smart speakers lined up to present (plus me)! It’s going to be a great event!!

You can register for SQL Saturday #477 – Atlanta – BI Edition here. I hope to see you there!

:{>

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.