From SSIS to Synapse to Fabric - A Data Architect's Case Study

Explore a real-world case study on migrating an Enterprise Data Warehouse (EDW) automation framework from SQL Server Integration Services (SSIS) to Azure Synapse Analytics and ultimately to Microsoft Fabric. Learn about the migration process, key lessons learned, and improvements made during this journey. Discover the unit test strategy employed and gain insights into what the future holds for data architecture. Benefit from practical experiences shared on using Fabric, migrating to Fabric, and re-architecting solutions using declarative techniques. This 50-minute conference talk, presented by SQL Server MVP Bob Duffy, offers valuable insights for data architects and professionals interested in modern data platform evolution.

From SSIS to Synapse to Fabric - A Data Architects Case Study