Can you believe the PASS Summit 2018 begins only 10 weeks from today (27 Aug 2018)? I confess, this is sneaking up on me fast! I will be there. Will you? Where Can You Find Andy at the PASS Summit 2018? Precon! Monday 5 Nov 2018, I’m delivering a full-day pre-conference session titled Intelligent Data …
Continue reading PASS Summit 2018 Starts in 10 Weeks!
Category:Data Integration Patterns
What’s the Best Book for Learning SSIS?
I am often asked the question, “Andy, what’s the Best Book for Learning SSIS?” There are some really good books out there that will help you learn SSIS (and I am co-author of several). The book from which I learned the most about SSIS is Extending SSIS 2005 with Script by Donald Farmer. Why do …
Continue reading What’s the Best Book for Learning SSIS?
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
Free Webinar – Designing a Custom ADF SSIS Execution Framework
Folks, I’m not going to even pretend to be cool and collected about this webinar about designing an ADF SSIS Execution Framework. I’ve been waiting for this one for a loooooooong time! The next (free!) webinar in the series I’m calling the Summer-O’-ADF is Designing a Custom ADF SSIS Execution Framework. It’s at noon EDT Thursday …
Continue reading Free Webinar – Designing a Custom ADF SSIS Execution Framework
Free Webinar – ADF Controller Design Pattern with the SSIS Integration Runtime
The next free webinar in my Summer-O’-ADF series of free webinars is titled ADF Controller Design Pattern with the SSIS Integration Runtime. It’s scheduled for Thursday 5 Jul 2018 at noon EDT. It will be recorded in case you miss it. “Previously on the Summer-O’-ADF Series…” </DonLaFontaine> In my previous webinar, The Azure Data Factory Controller Design …
Continue reading Free Webinar – ADF Controller Design Pattern with the SSIS Integration Runtime
100 Dumb Little Things
Software development is hard. It takes time, yes. But more than that, software development takes patience and thought and blood and sweat and love and tears. My friends at Varigence recently released an update to their Business Intelligence Markup Language (Biml) products. If you’re into business intelligence or data science, integration, or engineering, you should …
Continue reading 100 Dumb Little Things
It’s Biml 2018 Release Day!
Scott Currie and the team at Varigence announce the release of BimlFlex 2018, BimlStudio 2018, and BimlExpress 2018! This much-anticipated release includes awesome features for experienced Biml professionals as well as for data engineers new to automating processes! BimlFlex 2018 BimlFlex is a mature and complete data engineering automation framework. Out of the box, BimlFlex …
Continue reading It’s Biml 2018 Release Day!
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
The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available
The recording of my free webinar – Introduction to Lifting and Shifting SSIS to the Cloud – is now available (registration required). Abstract How does an enterprise lift and shift SSIS projects from SSIS Catalogs on-premises to the Azure Data Factory Integration Runtime? What are the best practices? Do SSIS lifecycle management tools exist to …
Continue reading The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available
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