I am honored to present Faster SSIS at SQL Saturday Boston 22 Sep 2018! Check out this schedule – there are a bunch of smart people presenting – plus me! Abstract Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows …
Continue reading Honored to Present Faster SSIS at SQL Saturday Boston 22 Sep 2018!
Category:Azure
Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
Join me 30 Aug 2018 at noon EDT for another free webinar titled Use Biml to Build a Local Copy of an Azure SQL DB. This webinar is inspired by a social media post by a friend. His company is using Azure SQL DB in Production. They want to make a copy of the Production …
Continue reading Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
DevOps and SSIS and Azure Data Factory
I wrote a book about practicing Data Integration Lifecycle Management with SSIS. In the book I explore tools I built to support DevOps with SSIS. Collectively, I call them the Data Integration Lifecycle Management Suite (DILM Suite). Many utilities at DILM Suite are free and some are open-source: SSIS Framework Community Edition – free, open-source, and …
Continue reading DevOps and SSIS and Azure Data Factory
Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Atlanta
The #Azure DataFest Atlanta Schedule has been posted and I am honored to be selected to present Lift and Shift SSIS to ADF! Check out this lineup of presenters and presentations. I describe this group as: “a bunch of smart people – plus me!” Lift and Shift SSIS to ADF Abstract Your enterprise wants to …
Continue reading Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Atlanta
Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun
Andy’s Summer-o’-ADF continues with another free (yes, FREE) webinar! Abstract Join me as I begin to explore a brand new topic: Azure Data Factory Design Patterns. This first webinar in the series is titled The Azure Data Factory Controller Design Pattern. In this demo-tastic session I show how to apply the pattern described in …
Continue reading Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun
Free Webinar – Introduction to Lifting and Shifting SSIS to ADF
I hope you will join me 21 Jun at noon EDT for a free webinar titled Introduction to Lifting and Shifting SSIS to the Cloud! Abstract In this webinar I demonstrate and discuss migrating SSIS projects from on-premises to the Azure Data Factory Integration Runtime. In addition I cover some best practices and demonstrate some …
Continue reading Free Webinar – Introduction to Lifting and Shifting SSIS to ADF
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
How I Learn
This is a picture of how I learn. These are executions of an Azure Data Factory version 2 (ADFv2) pipeline. The pipeline is designed to grab data collected from a local weather station here in Hampden-Sydney Virginia – just outside Farmville – and piped to Azure Blob Storage via AzCopy. How do I learn? Fail …
Continue reading How I Learn
Completed: Microsoft Big Data Professional Program Capstone Project
I’m excited to announce that I’ve completed – with help from my friend and brother and co-host of the Data Driven podcast, Frank La Vigne (Blog | @Tableteer) – the Microsoft Big Data Professional Program Capstone project! The capstone is the last course requirement (of 10 courses) to complete the Microsoft Professional Program in Big …
Continue reading Completed: Microsoft Big Data Professional Program Capstone Project