Podcast: Azure Data Factory

Posted by on Dec 10, 2015 in Azure Data Factory, SSIS | 2 Comments

I’ve been honored to talk with Carlos L Chacon about Azure Data Factory after my session at PASS Summit, and he published the webcast in hist website; SQLDataPartners. Thanks to Carlos and SQLDataPartners for the great opportunity to talk on one of my favorite topics as Data movement with the new technology; Azure Data Factory. I’ve first met Carlos last year in SQL Saturday Oregon, and afterwards in PASS Summit 2014. Carlos is very nice guy. He is running SQLDataPartners while he lives with his family in Richmond, Virginia.

About this Podcast: Azure Data Factory

As one of the newest Azure offerings, Azure Data Factory can at first thought be compared to SSIS.  I don’t think we are quite there yet with the comparisons; however, I talk with MVP Reza Rad and discuss some of the similarities and differences between the two.

A consultant now living in New Zealand, Reza has lots of experience with the data management and gives us the scoop on the initial offering of this new Azure tool.  I hope you enjoy the episode.  If you have some feedback or comments, feel free to reach out on Twitter–I am @CarlosLChacon

Carlos: Ultimately today, you gave a presentation at the summit, and it piqued my interest, since I personally am trying to do a lot more with Azure. You gave a presentation on comparing SSIS to the Azure Data Factory. That’s the conversation that we wanted to have today. Get us started, first maybe we should talk about what is the Azure Data Factory.

Here is the link to Podcast:


About SQLDataPartners Podcasts

In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry.  I want to introduce new and familiar topics and talk about them in a way you may have not considered.  We are all on different stages as data professionals, and we can all something new.  I hope you will join me on the SQL trail compañeros–you won’t regret it.

The podcast is available on ITunes and also on Stitcher!     Here you can listen to all the episodes!  The show notes are on each episode page–use the links at the bottom to get there.

Did I miss something or not quite get it right?  You can hit me up on twitter.  Don’t worry, I don’t bite.

List to Podcasts page:



Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.


  • Hi Reza, this podcast and your deck comparing SSIS vs ADF was very informational. Thank you very much for that. But, I’d like to mention that cost estimate in the conversation was a bit misleading.

    >> Let’s say, for example, you run 10 activity in your data flow, and that 10 activity you run 10 times a day or something like that, so that’s 100 times a day. And then you run that for a month, so that makes 3,000 activities per month.
    Then you fill into one of the tires of Azure Data Factory pricing. Let’s say for example, if you run this amount of activities per month, this is the price that you pay

    10 activity 10 times a day makes 3,000 run of activities per month, not 3,000 activities. The reason that we should distinguish this is because there is a cost for activity and a cost for activity re-run. Each activity cost $0.80 per month. 1000 re-run of single activity cost $1.34. 3,000 activities cost $2400 but 10 activities re-run 30 times per month would only cost $21.4. Number can be slightly different. 😉

    • Hi Aaron,

      Thanks for your kind words 🙂 Yes, you are absolutely right. I missed to mention re-runs costs much lower in that podcast. Thanks for mentioning it. I appreciate it 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *