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
Category:SSIS Design Patterns
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!
SSIS Design Pattern: Controller Pattern
The SSIS Design Pattern known as the Controller Pattern provides a solution for executing SSIS packages in parallel – even from a serial SSIS execution framework such as SSIS Framework Community Edition (part of DILM Suite).
My Books
I’ve authored and co-authored a bunch of books! Truth be told, I enjoy writing. I think my love of writing stems from a love of learning. I’m just trying to share the joy! It’s a huge honor to write. I’m humbled and thrilled (all at the same time – a feeling I describe as “all …
Continue reading My Books
Introduction to the SSIS Lifecycle – 7 Jun 2018
Join me Thursday, 07 Jun at noon EDT for a free webinar: Introduction to the SSIS Lifecycle! How should an enterprise promote SSIS projects from Development to Production? How many “levels” are required? What are the best practices? Do SSIS lifecycle management tools exist? Join Andy Leonard – SSIS author, trainer, and consultant – to …
Continue reading Introduction to the SSIS Lifecycle – 7 Jun 2018
Honored to Present Faster SSIS at SQL Saturday Albuquerque on Cinco de Mayo!
I am honored to present Faster SSIS at SQL Saturday #720 – Albuquerque 5 May 2018! 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 you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages. We’ll start …
Continue reading Honored to Present Faster SSIS at SQL Saturday Albuquerque on Cinco de Mayo!
My Learning Resources for SSIS
People often ask me, “Andy, where can I learn SSIS or learn more about it?” Well, you’re at one such location – my blog! I’ve been blogging about SSIS for about 10 years as I type this. There’s a lot posts here about SSIS – that’s the good news. The bad news is: There’s a …
Continue reading My Learning Resources for SSIS
Introduction to Loading the Cloud with SSIS – 29 Mar 2018
The cloud is coming, ready of not. In this session, presenter and author Andy Leonard discusses and demonstrates some patterns for loading cloud destinations using SSIS. Join me for Introduction to Loading the Cloud with SSIS 29 Mar 2018 at noon ET to learn more. Register today! :{>
The Recording for Introduction to SSIS Design Patterns, Part 1 is Available
The Recording for Introduction to SSIS Design Patterns, Part 1 is now available (registration required). Abstract: SSIS Design Patterns are tried and true data integration patterns built in SQL Server Integration Services (SSIS). Join author and international speaker Andy Leonard as he explores: – The Truncate and Load Staging Pattern – The Incremental Load Pattern
Free Webinar – Introduction to Change Detection with SSIS 15 Mar 2018
Join me 15 Mar 2018 at noon ET for Introduction to Change Detection with SSIS, another free webinar sponsored by Enterprise Data & Analytics. Change detection is the central component for Incremental Load data integration patterns. In this presentation I discuss and demonstrate three change detection patterns: – No Change Detection – Brute-Force Change Detection …
Continue reading Free Webinar – Introduction to Change Detection with SSIS 15 Mar 2018