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

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, and cost. Finally, we will wrap up with demos showing practical examples of using SSIS and ADF in the real world.
Watch the session recording from PASS Summit 2019. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: www.red-gate.co...