Honored to Present Faster SSIS at SQL Saturday Albuquerque on Cinco de Mayo!

Posted on by Andy LeonardCategories:Data Integration Patterns, PASS, Presentations, SQL Saturday, SSIS, SSIS Design Patterns

I am honored to present Faster SSIS at SQL Saturday #720 – Albuquerque 5 May 2018!

Abstract
Ever wonder why SSIS runs so slow? 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.

The schedule for the event looks awesome. There are lots of really smart people presenting – plus me!

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.