I’m honored to deliver a Training Day at SQLBits 2020, which is now a virtual event! My training day will be delivered 30 Sep 2020 and is titled From Zero to Azure Data Factory. The agenda is: From Zero to Azure Data Factory is designed to jumpstart data engineering and data integration developers, introducing them …
Continue reading Honored to Present From Zero to ADF at SQLBits 2020!
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. :{>
On Over-Engineering…
Some who follow me on Twitch (you may follow me at https://twitch.tv/andyleonard) – have seen me live-code the demo project for the second edition of Building Custom Tasks for SQL Server Integration Services (link to the first edition). The demo project is a custom task named Execute Catalog Package Task: While writing about parsing the …
Continue reading On Over-Engineering…
Recording for Updates to the SSIS Framework Webinar
Enjoy this recording of the Updates to the SSIS Framework free webinar, delivered 30 Jul 2020 at 12:00 PM EDT. Learn more about the SSIS Framework at DILM Suite. Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our …
Continue reading Recording for Updates to the SSIS Framework Webinar
Free Webinar – Updates to the SSIS Framework
Join me 30 Jul 2020 at 12:00 PM EDT for Updates to the SSIS Framework! The recording for this presentation is available here. “I cover a really good example in the webinar. “ My favorite new feature is Application Package Property Overrides. I can hear you thinking, “What are Application Package Property Overrides, Andy?” I’m …
Continue reading Free Webinar – Updates to the SSIS Framework
SQL Server Management Studio v18.6 is Available
SQL Server Management Studio v18.6 is released! According to Microsoft, version 18.6 is the second major release of SSMS in 2020. There are cool new features and even more bug fixes: Enjoy! :{>
One Way to Incrementally Develop ADF Pipelines
A friend pinged me recently to ask about rolling back Azure Data Factory (ADF) pipeline versions. My response was a question: Are you using source control with ADF? That did not help the current situation. I thought of the way I often build ADF pipelines and shared my methodology, which is relatively simple (it has …
Continue reading One Way to Incrementally Develop ADF Pipelines
Nesting ForEach Activities in Azure Data Factory
Near the end of June 2020, I delivered a free Enterprise Data & Analytics Summer o’ ADF webinar titled Using the Azure Data Factory ForEach Activity. My friend Meagan Longoria (Blog | @MMarie | LinkedIn) was in attendance. If you don’t know Meagan, you should – especially if you work with analytics. She’s scary-smart about …
Continue reading Nesting ForEach Activities in Azure Data Factory
The Recording for Building an SSIS Framework in Azure Data Factory
Enjoy this recording of the (free!) Enterprise Data & Analytics webinar titled Building an SSIS Framework in ADF! :{> 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 …
Continue reading The Recording for Building an SSIS Framework in Azure Data Factory
Learn SSIS Data Flows and Azure Data Factory in August 2020!
I recently added two online training deliveries for August 2020: 10-11 Aug 2020: SSIS Data Flows 12 Aug 2020: Master the Fundamentals of Azure Data Factory SSIS Data Flows is a two-day, online, live course designed to jumpstart SSIS developers who want to learn SSIS and those who desire to fill gaps in their self-taught …
Continue reading Learn SSIS Data Flows and Azure Data Factory in August 2020!
SQL Server Data Automation through Frameworks Book Available for Pre-Order
Although the cover image needs an update, my and Kent Bradshaw’s next book – titled “SQL Server Data Automation through Frameworks: Building Metadata-driven Frameworks with T-SQL, SSIS, and Azure Data Factory” is available for pre-order!