Free Webinar – Building an SSIS Framework in ADF

Join me at 12:00 PM EDT on 9 Jul 2020 for Building an SSIS Framework in ADF, another free Summer o’ ADF webinar from Enterprise Data & Analytics. Abstract Andy authors SSIS frameworks according to a few principles: 1. Functionality 2. Empathy 3. Simplicity Join Microsoft Data Platform MVP Andy Leonard as he discusses and …
Continue reading Free Webinar – Building an SSIS Framework in ADF

Free Webinar: Using the Azure Data Factory ForEach Activity

The Azure Data Factory ForEach activity iterates collections. This makes the ForEach activity extremely useful for acting on flexible number of items. As with all software, there are corners. So, I cover a gotcha or two in this free webinar from Enterprise Data & Analytics at 12:00 PM EDT 30 Jun 2020. Register today for …
Continue reading Free Webinar: Using the Azure Data Factory ForEach Activity

Data Driven Podcast: Bob Ward

Frank and I are honored to share an interview with Bob Ward (@bobwardms)! It was an awesome show – check it out! Notable Quotes On playing the “plague or pollen” game. (02:30) Regarding sportsball… (05:30) Virtual is the new norm. (06:30) Bob and Azure (07:30) Frank caught Bob in person at Microsoft Ready (08:15) On …
Continue reading Data Driven Podcast: Bob Ward

Four Questions to Ask When Hiring an Enterprise Data Consultant

It’s time to hire a consultant for your enterprise data project. That is awesome news, but a quick search for the perfect consultancy reveals a number of options (and hourly rates). What’s a CEO, CIO, CFO, VP, or Director to do? How do you choose a consultant with the right experience for your enterprise data …
Continue reading Four Questions to Ask When Hiring an Enterprise Data Consultant

One Way to Break Out of an Azure Data Factory ForEach Activity

First, a couple shoutouts to my brothers and friends, Joel Cochran (@joelcochran) and Shannon Lowder (@shannonlowder). This approach grew out of conversations with them. The ForEach activity iterates over a collection of items. One less-documented property of the ForEach activity is it (currently) iterates the entire collection. I can hear some of you asking… “What …
Continue reading One Way to Break Out of an Azure Data Factory ForEach Activity

Trying a New Thing

Inspired by Brent Ozar, Erik Darling, Riley – my younger son, command sergeant 12 year old, Streamlabs OBS guru, etc. – and others, I’m taking Twitch for a test drive. So far, I’ve streamed a few test streams. One stream included a walk-through of an Azure Data Factory design pattern. How to Get In on …
Continue reading Trying a New Thing

Configure Azure Data Factory Security for the ADF REST API

Before using the Azure Data Factory’s REST API in a Web activity’s Settings tab, security must be configured. Azure Data Factory pipelines may use the Web activity to call ADF REST API methods if and only if the Azure Data Factory managed identity is assigned the Contributor role. More information about the problem I am …
Continue reading Configure Azure Data Factory Security for the ADF REST API