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
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Recording – Using the Azure Data Factory ForEach Activity
In this video, Andy Leonard discusses and demonstrates the Azure Data Factory ForEach activity.
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
The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available
Enjoy this recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes! <ShamelessPlug> Need Help Getting Started with ADF? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work for large and challenging data engineering enterprises. …
Continue reading The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available
Integration Services Extension for VS 2019 v3.8 Released
The Integration Services v3.8 extension for VS 2019 has been released! From the SQL Server Integration Services Projects page: <ShamelessPlug> Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises kickstart or complete Enterprise Data Warehouse projects – whether on-premises or in the cloud. Our experienced engineers grok enterprises of all …
Continue reading Integration Services Extension for VS 2019 v3.8 Released
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