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:
http://sqldatapartners.com/2015/12/09/azure-data-factory/
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:
http://sqldatapartners.com/podcast/
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
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 🙂
Cheers,
Reza