Lift and Shift is Not a Strategy…

Lift and shift is a bridge. If your enterprise is considering migrating enterprise data and data integration workloads from on-premises to the cloud, lifting and shifting is not the end of the story. Lifting and shifting is, rather, the mechanism – the conversion project – that positions your enterprise to leverage the economies of scale …
Continue reading Lift and Shift is Not a Strategy…

Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston

I am honored to deliver Lift and Shift SSIS to ADF at the Azure DataFest in Reston Virginia 11 Oct 2018! Abstract Your enterprise wants to use the latest cool Azure Data Analytics tools but there’s one issue: All your data are belong to the servers on-premises. How do you get your enterprise data into …
Continue reading Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston

Time and Money in the Cloud

What Could Your Enterprise Do With Extra Time? Benjamin Franklin is credited with saying, “Time is money.” The 2011 movie, In Time, depicts an entire economy based on time. (A friend pointed out that time is not fungible, but I digress…) So, what could your enterprise do with more time? When you think about it, …
Continue reading Time and Money in the Cloud

The Recording for Designing a Custom ADF SSIS Execution Framework is Available

The recording the Summer-O’-ADF webinar titled Designing a Custom ADF SSIS Execution Framework is now available (registration required)! Enjoy! :{>  

SSIS Catalog Compare vNext Preview

I am happy to announce that the next version of SSIS Catalog Compare is officially in Preview! What exactly does “Preview” mean? I’m glad you asked. It means I am sharing copies of SSIS Catalog Compare with users of the current version to get their feedback, find bugs, and help identify improvements. Here’s a screenshot: …
Continue reading SSIS Catalog Compare vNext Preview

The Cloud Costs Money

It’s true: the cloud costs money. Yesterday, when I logged into my Azure Portal to set up an Azure Data Factory Integration Runtime for my presentation, the balance for my Azure free subscription (which allows me $100USD per month) was sitting around $82USD. This morning, after leaving a demo instance of ADFIR running overnight, my …
Continue reading The Cloud Costs Money

ADF Execute SSIS Package Activity

The good people who work on Azure Data Factory recently added an Execute SSIS Package activity. It’s pretty cool. Let’s tinker with it some, shall we? First, you will need to create an Azure Data Factory SSIS Integration Runtime. If you don’t know how, that’s ok – I’ve written a post titled Lift and Shift SSIS …
Continue reading ADF Execute SSIS Package Activity

Lift and Shift SSIS Part 1: Deploy Integration Runtime SSIS

What if I told you, “You can quickly and easily deploy Integration Runtime SSIS projects to Azure Data Factory?” You can! As shown in the image, you can simply right-click the SSIS project name in SQL Server Data Tools (SSDT) Solution Explorer and click Deploy to deploy the project to the Azure Data Factory (ADF) …
Continue reading Lift and Shift SSIS Part 1: Deploy Integration Runtime SSIS

Lift and Shift SSIS Part 0: Creating the ADF Integration Runtime

Let’s face it: All the cool kids are playing in the cloud. And why wouldn’t they be? Microsoft Azure gets new features every week… sometimes every day! One shiny feature is Azure Data Factory Integration Runtime (ADFIR) which is new in Azure Data Factory version 2. In this post I will show you one way to …
Continue reading Lift and Shift SSIS Part 0: Creating the ADF Integration Runtime