The recording of my free webinar titled Using SSIS Framework Community Edition is now available (registration required). You can obtain the free and open source SSIS Framework Community Edition at DILM Suite. Enjoy! :{>
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. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Do you work for a charity or non-profit organization? Submit your application today. I haven’t advertised this in the past and… I’m not sure why: I donate licenses for SSIS Catalog Compare and (non-free) SSIS Framework Editions – and subscriptions to Biml Academy and SSIS Academy – and Enterprise Data & Analytics Training – to individuals who …
Continue reading Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Using SSIS Framework Community Edition Webinar 20 Sep
Join me 20 Sep 2018 at noon ET for a free webinar titled Using SSIS Framework Community Edition! Abstract SSIS Framework Community Edition is free and open source. You may know can use SSIS Framework Community Edition to execute a collection of SSIS packages using a call to a single stored procedure passing a single …
Continue reading Using SSIS Framework Community Edition Webinar 20 Sep
AndyWeather – Now Part of Weather Underground
Weather Underground is a cool weather site. They get community. Exhibit A is the latest personal weather station reporting to Weather Underground, affectionately known as PWS: KVAFARMV9. Yep, that’s the AndyWeather weather station, right there! :{>
Introducing Azure Data Factory Design Patterns
I was honored to write an article titled Introducing Azure Data Factory Design Patterns featured in this month’s PASS Insights newsletter! Introducing Azure Data Factory Design Patterns The article covers a couple execution patterns: Execute Child Pipeline Execute Child SSIS Package I demonstrate a cool SSIS Catalog Browser feature that helps ADF developers configure the Execute SSIS Package activity. To …
Continue reading Introducing Azure Data Factory Design Patterns
AndyWeather Internet of Things (IoT)
AndyWeather.com is a site I’ve maintained for about 10 years now. I use the site and related hardware, software, and services to test concepts and perform experiments. I then apply my experience in delivering Internet of Things (IoT) solutions for Enterprise Data & Analytics customers and for SSIS and Biml training, such as my upcoming course titled …
Continue reading AndyWeather Internet of Things (IoT)
Announcing the Fundamentals of Azure Data Factory Course!
I am excited to announce a brand new course (it still has that new course smell) from Brent Ozar Unlimited and honored to deliver it! This one-day, live, online course is titled Fundamentals of Azure Data Factory and it’s designed to introduce you to Azure Data Factory (ADF). There will be demos. Live demos. Lots …
Continue reading Announcing the Fundamentals of Azure Data Factory Course!
T-SQL Tuesday #106: Regarding Triggers
In my experience, people either love or hate triggers in Transact-SQL. As a consultant, I get to see some interesting solutions involving triggers. In one case, I saw several thousand lines of T-SQL in a single trigger. My first thought was, “I bet there’s a different way to do that.” I was right. The people …
Continue reading T-SQL Tuesday #106: Regarding Triggers
Change to the SSMS Create Catalog Dialog
I’m glad to see a change in the Create Catalog dialog for creating an instance of an SSIS Catalog using SQL Server Management Studio (SSMS) version 17.9. The “Enable this server as SSIS scale out master” checkbox is now unchecked by default: I’m not sure if this changed in SSMS version 17.9 or an earlier …
Continue reading Change to the SSMS Create Catalog Dialog
Enterprise Data & Analytics and Andy Leonard Consulting
I occasionally get questions about my companies (yes, plural) so I thought I’d write a post explaining them. Enterprise Data & Analytics Enterprise Data & Analytics is a boutique consulting firm. I own the company and I also deliver consulting services. We have a team of experienced engineers who deliver everything from cloud data migrations to …
Continue reading Enterprise Data & Analytics and Andy Leonard Consulting