The Azure-SSIS Team has done it again; they’ve added more cool SSIS execution functionality to Azure Data Factory! Execute SSIS Package Activity Update First, add an Execute SSIS Package Activity in an Azure Data Factory pipeline. On Settings, select an Azure-SSIS Integration Runtime. Set Package Location to “Embedded package”: The Execute SSIS Package activity’s properties …
Continue reading Embed an SSIS Package in an Azure Data Factory Pipeline
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. :{>
Wrapping up the Summer o’ ADF 2019
As the 2019 Summer o’ ADF 2019 draws to a close, we look forward to shorter and cooler Autumn days (in the northern hemisphere, at least!), conference season, and the fast-approaching holidays. As always, I had an absolute blast sharing tips and tricks for using Azure Data Factory in the enterprise. I must admit that …
Continue reading Wrapping up the Summer o’ ADF 2019
Manage SSIS Catalog Size
A few days ago, I (along with some smart people) were asked on Twitter how to manage the size of the SSIS Catalog. Since I’d heard this question a couple times recently, I decided it would probably make a good topic for a blog post. Welcome to the blog post! The gentleman who asked the …
Continue reading Manage SSIS Catalog Size
Overcome Challenges of Lifting and Shifting SSIS to Azure
Enjoy this recording of a free webinar titled Overcome Challenges of Lifting and Shifting SSIS to Azure! In this webinar, I demonstrated challenges of scripting SSIS Catalog Environments, Environment Variables, References, Reference Mappings, and Literals for deployment to another SSIS Catalog. These challenges are particularly troublesome when practicing Lifecycle Management or DevOps with SQL Server …
Continue reading Overcome Challenges of Lifting and Shifting SSIS to Azure
Goodbye Microsoft Professional Program and a Question
I was sad to read the announcement of the retirement of the Microsoft Professional Program, I’m still sad about it because it was a good program. Print Your Certificates If you have completed your MPP courses or tracks, please save/print certificates by December 31, 2019. https://academy.microsoft.com/en-us/professional-program/ According to the website, you should save and / or …
Continue reading Goodbye Microsoft Professional Program and a Question
The First DataSoup Virtual Summit is Live!
Frank La Vigne (@Tableteer | LinkedIn | DataDriven) and I are honored to announce the first DataSoup Virtual Summit! Awesome Speakers! Speakers at first DataSoup Virtual Summit are intelligent, world-renowned experts (plus me!). Head over to the speaker page and check them out. A Virtual Summit is… Different If you sign up to view DataSoup, …
Continue reading The First DataSoup Virtual Summit is Live!
Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!
I am honored to deliver From Zero to ADF – a full-day pre-conference training event held Friday, 04 Oct 2019 – the day before SQL Saturday 907 – Pittsburgh! Abstract From Zero to ADF is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF). ADF is a cloud …
Continue reading Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!
Learn Azure Part 0 – Create an Azure Account
If you are interested in learning Azure, cool! I am here to help.™ Let’s begin by thinking about this journey accurately: Azure is not easy. Azure is not simple. Learning Azure will take time. You will experience frustration. Sounds awesome, right?! The preceding list is the bad news. There is good news, though: If learning …
Continue reading Learn Azure Part 0 – Create an Azure Account
Data Driven Podcast – Brent Ozar
Frank and I had an awesome time interviewing Brent Ozar (Brent Ozar Unlimited | @BrentO | Professional Blog | Personal Blog) on the Data Driven Podcast! We talked about NoLock, Stoicism, and playing country music backwards – among other things. Check out the show! Season 3 went live last week with John Lee Dumas of …
Continue reading Data Driven Podcast – Brent Ozar
Presenting Moving Data with ADF at TriPASS 20 Aug
I am honored to deliver Moving Data with ADF to the Triangle SQL Server Users Group (TriPASS) 20 Aug 2019 starting at 6:00 PM EDT! This event will be streamed live via Twitch. Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical …
Continue reading Presenting Moving Data with ADF at TriPASS 20 Aug