Loading...
Skip to content
AndyLeonard.blog() AndyLeonard.blog()
  • LinkedIn
  • X.com
  • RSS
  • About Andy
  • linktr.ee

Honored to Present Faster SSIS at Triad SQL PASS BI 30 Oct!

Posted on October 18, 2018by Andy LeonardCategories:Performance, Presentations, SSIS, SSIS Best Practices

I am honored to join my friends at the Triad SQL PASS BI Group in Greensboro North Carolina 30 Oct 2018, where I will present Faster SSIS!

Abstract

Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages. We’ll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we’ll explain a Data Flow Task’s bottleneck when loading binary large objects – or Blobs. Finally, we’ll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud. Prerequisites: Familiarity with SQL Server Integration Services (SSIS).

Register today! I hope to see you there.

:{>

Andy Leonard

andyleonard.blog

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

Comments

Leave a Reply Cancel 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.

Training

Next Live Training:

Fabric Data Factory logo A Day of Azure Data Factory live and online 9:00 AM-4:30 PM (ET) 21 May 2025. Register today!
Fabric Data Factory logoAdvanced Azure Data Factory (ADF) live and online 9:00 AM-4:30 PM (ET) 11 Jun 2025. Register today!
Fabric Data Factory logo A Day of Fabric Data Factory live and online 9:00 AM-4:30 PM (ET) 18 Jun 2025. Register today!

Subscribe to my Newsletter

Need Help?

I still deliver consulting! I help enterprises implement Fabric Data Factory and Azure Data Factory solutions, help data teams rescue data warehouse projects, and support businesses by validating data architecture. Contact me. I can help.

Training

Azure QuickStart Premium includes access to all Enterprise Data & Analytics' Fabric, Azure, and Azure Data Factory training for 1 Year! Register today!

Do you need to level-up your Data Engineering skills in a hurry? Premium Level includes all Azure QuickStart Premium content plus SSIS and SSIS Catalog content. Register today!

  • LinkedIn
  • X.com
  • RSS
© 2025 by AndyLeonard.blog(). All rights reserved.
Back to top