Azure Data Factory

We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed a service to help customers using those services move data around. Azure Data Factory was born with the initial premise of moving data between cloud services; however, it has added the ability to connect with on-premises systems and continues to add a variety of connectors it can now natively support.

In this episode, we chat with our friend Andy Leonard about Azure Data Factory, his experience working with the product team, and how customers can leverage the cloud to get business done faster.

3 Takeaways

  1. The way you approach cloud architecture will probably look different than what you do on-premises.
  2. The change in architecture can lead to a performance increase at no additional expense.
  3. Azure Data Factory continues to merge the experience between the cloud and on-premises for a more seamless transition.

Our Guest

andy leonard

Andy Leonard

Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is author and co-author of several books about SSIS, Biml, Managing Teams, and Azure Data Factory. Andy blogs at where you can learn more on the About Andy page.

[If you’re moving data on-premises and in the cloud] you’re not doing it wrong in my opinion and experience. Hybrid has just emerged as the dominant force among people using the cloud at all. It’s a surprising amount.

Andy Leonard

Meet the Hosts

carlos chacon headshot

Carlos Chacon

With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at and provides training through SQL Trail events.

eugene meidinger headshot

Eugene Meidinger

Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.

kevin feasel headshot

Kevin Feasel

Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

Want to Submit Some Feedback?

Did we miss something or not quite get it right? Want to be a guest or suggest a guest/topic for the podcast?

Let's find what you're looking for