Head to Head: SSIS versus Azure Data Factory - Tim Mitchell

Note: This is an online meeting. To attend:

1. RSVP for this event on Meetup.
2. Register at GoToWebinar using the "online event" link from this Meetup post.
3. You will receive an e-mail with a link to join the meeting.

Head to Head: SSIS versus Azure Data Factory

Summary:
In this session, we will compare SSIS with Azure Data Factory to learn the strengths and weaknesses of each, and to explore use cases for both.

Abstract:
Anyone working in the SQL Server ecosystem has likely heard of both SQL Server Integration Services (SSIS) and Azure Data Factory (ADF). Both of these are used to move and transform data, and are both very capable and mature tools. But how do the two compare to each other? How does one determine which is better for a given task?

In this session, we will do a head-to-head comparison of SSIS and ADF. We'll compare the features of each of these tools, calling out the functionality common to both as well as the behaviors exclusive to one or the other. We will discuss the benefits and the challenges of working with SSIS and ADF, exploring topics including:

• Performance
• Ease of administration
• Monitoring and troubleshooting
• Cost

Finally, we will wrap up with demos showing practical examples of using SSIS and ADF in the real world.

About The Presenter
Tim Mitchell is a business intelligence architect, author, and trainer. He has been building data solutions for over 17 years, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is the founder and principal data architect at Tyleris Data Solutions, a consulting firm focused on delivering on-premises and cloud-based solutions on the Microsoft data platform.

As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is a member of the Boulder BI Brain Trust, a Melissa Data MVP, and is active in the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

Sacramento SQL Server User Group:
https://www.meetup.com/Sacramento-SQL-Server-User-Group
https://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448