This is a picture of my friend Tom Roush and me from a few years ago. Tom passed away 29 Jan 2018 after a protracted battle with cancer. He was my friend and brother and I will miss his easy smile, sage wisdom, and German wit. I used to refer to Tom as “the best …
Continue reading Tom Roush
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. :{>
Andy’s Excellent SSIS-in-the-Cloud Adventure and PowerShell
If you’re new to PowerShell or just don’t know PowerShell, tinkering with Azure Data Factory Version 2 Integration Runtime (ADFv2 IR) can be intimidating. In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance, I walk you through the PowerShell part, sharing my (meager) knowledge of this awesome utility, assuming little (assuming nothing, …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure and PowerShell
Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives
In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance I wrote about the three steps to configure Azure-SSIS Integration Runtime in Azure Data Factory Version 2 (ADFv2 IR, or SSIS in the cloud). In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project I wrote about deploying, …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives
Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project
In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance I wrote about the three steps to configure Azure-SSIS Integration Runtime in Azure Data Factory Version 2 (ADFv2 IR, or SSIS in the cloud). In this post, I’m going to continue by showing you how to deploy, execute, and monitor an SSIS package. …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project
Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance
Maybe you’ve heard SSIS is available in the cloud. It is! But it’s not easy to get set up (at the time of this writing). I am here to help. The correct name for “SSIS in the cloud” is: Azure-SSIS Integration Runtime in Azure Data Factory version 2. Azure Data Factory version 2 is sometimes abbreviated …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance
Updates to SSIS Catalog Browser
I’m happy to announce the release of Catalog Browser v0.5! I taught the app a new trick: viewing SSIS Catalogs in Azure! Of course, Catalog Browser still works locally: As the next release of SSIS Catalog Compare approaches, I’ve been testing – a lot. Catalog Browser shares quite a bit of functionality with Catalog Compare – …
Continue reading Updates to SSIS Catalog Browser
Upcoming Catalog Properties Update for SSIS Catalog Compare
In this video I share and discuss upcoming updates to SSIS Catalog Compare‘s Catalog Properties node. Check it out! :{>
Learning for Free
I’ve been blogging lately about training and certifications and it’s generated a fair amount of questions. One question is: “How much does certification cost?” Well, some of it is free. A surprising amount is free, in fact. Biml Academy offers several hours of free training, for example. YouTube is chock-full of learning opportunities. The quality of training …
Continue reading Learning for Free
Achievement Unlocked: Certified in Implementing Real-Time Analytics with Azure HDInsight
I learned a lot completing Implementing Real-Time Analytics with Azure HDInsight. It’s the most fun Microsoft Virtual Academy / edX course I’ve taken to date! In completing this course, I finished the requirements for the Microsoft Azure HDInsight Big Data Analyst program. I completed Implementing Predictive Analytics with Spark in Azure HDInsight and Processing Big Data with Hadoop in Azure …
Continue reading Achievement Unlocked: Certified in Implementing Real-Time Analytics with Azure HDInsight
Writing about Apache Storm Stirs Up a Storm
A storm is coming… I’ve been spending some time learning other data integration and analytics open-source-y stuff. Perhaps you’ve noticed recent blog posts like: Apache Storm Stream Processing in Azure HDInsight Achievement Unlocked: Certified in Implementing Predictive Analytics with Spark in Azure HDInsight Achievement Unlocked: Completed Processing Big Data in Hadoop with Azure HDInsight If …
Continue reading Writing about Apache Storm Stirs Up a Storm