Loading...
Skip to content
AndyLeonard.blog() AndyLeonard.blog()
  • RSS
  • Twitter
  • LinkedIn
  • About Andy
  • SSIS and ADF Training
  • Mailing List
  • linktr.ee

Presenting A Day of Intelligent Data Integration at SQL Saturday Richmond!

Posted on November 9, 2017Updated on November 17, 2017by Andy LeonardCategories:Biml, Biml Frameworks, BimlExpress Metadata Framework, Catalog Reports, DILM, DILM Suite, Framework Browser, Performance, Presentations, SQL Saturday, SSIS, SSIS Catalog, SSIS Frameworks, Training, Uncategorized

I am honored to present my day-long precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration at SQL Saturday 705 – Richmond 23 Mar 2018!

Description

What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM, produced using Biml and executed using an SSIS Framework.

Attend a day of training focused on intelligent data integration delivered by an experienced SSIS consultant who has also led an enterprise team of several ETL developers during multiple projects that spanned 2.5 years. And delivered.

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 the free utilities, BimlExpress and BimlOnline
6. SSIS Design Patterns + Biml
Putting the DILM (Data Integration Lifecycle Management) components 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.

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

Register today. I hope to see you there!

:{>

—

You might like working with Enterprise Data & Analytics because enterprise SSIS Frameworks, baby.

—

 

 

Andy Leonard

andyleonard.blog

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

Training

Do you need to level-up your ADF and SSIS skills in a hurry? Sign up for the Premium Level – All Recordings for 1 Year and get started on a full year of ADF and SSIS training!

I still deliver consulting! Want to migrate enterprise SSIS to the cloud? Need help with that data warehouse project? SSIS running too slow? Contact me. At Enterprise Data & Analytics, we are here to help!

Let's meet to discuss your Azure Data Factory, SSIS, or Data Warehouse project; or schedule a demo of SSIS Framework or SSIS Catalog Compare.

  • RSS
  • Twitter
  • LinkedIn
© 2023 by AndyLeonard.blog(). All rights reserved.
Back to top