In this post I will provide some details about the demo SSIS project. I will then focus on version control and deployment. What DILM Is and Is Not Data Integration Lifecycle Management (DILM) is not about data integration development. DILM is about everything else: Configurations Management Version Management Deployment Execution Although DILM is not about …
Continue reading An Example of Data Integration Lifecycle Management with SSIS, Part 1
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.
Announcing SSIS Catalog Compare and CatCompare Version 2
I am pleased to announce the release of SSIS Catalog Compare and CatCompare version 2. You can purchase a bundle that includes both products (and saves you some money) or can purchase each product separately: SSIS Catalog Compare and CatCompare. If you’re interested in learning more about the functionality provided by the products you can …
Continue reading Announcing SSIS Catalog Compare and CatCompare Version 2
Save Time and Improve SSIS Quality with Biml, A Free Webinar
Join me at 1:00 PM EST 31 Jan 2017 for Save Time and Improve SSIS Quality with Biml, another free webinar from Enterprise Data & Analytics! “Save Time and Improve SSIS Quality with Biml” introduces Business Intelligence Markup Language (Biml) to SSIS developers, DBAs, sysadmins, and others who want to learn more about automating SSIS …
Continue reading Save Time and Improve SSIS Quality with Biml, A Free Webinar
Presenting “Using Biml as an SSIS Design Patterns Engine” at the (605) SQL Server User Group 10 Jan
I am honored to present – albeit remotely – Using Biml as an SSIS Design Patterns Engine to the (605) SQL Server User Group in Sioux Falls, SD Tuesday 10 Jan 2017! Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new …
Continue reading Presenting “Using Biml as an SSIS Design Patterns Engine” at the (605) SQL Server User Group 10 Jan
Free Webinar–Advanced SSIS Execution–24 Jan 2017
Join Enterprise Data & Analytics for Advanced SSIS Execution, a free webinar starting at 1:00 PM EST 24 Jan 2017! Kent and I demonstrated how to use the SSIS Catalog in the SSIS Academy series (see links to the recordings in the Learn More section). In this webinar, we share several ways to execute SSIS …
Continue reading Free Webinar–Advanced SSIS Execution–24 Jan 2017
Free Webinar–SSIS Catalog Management–10 Jan 2017
Join Enterprise Data & Analytics for SSIS Catalog Management, a free webinar starting at 1:00 PM EST 10 Jan 2017! Kent and I demonstrated how to use the SSIS Catalog in the SSIS Academy series (see links to the recordings in the Learn More section). In this webinar, we share best practices, tips, and tools …
Continue reading Free Webinar–SSIS Catalog Management–10 Jan 2017
An Example of Data Integration Lifecycle Management with SSIS, Part 0
What is Data Integration Lifecycle Management (DILM)? Here’s one way to think about DILM: Data Integration Lifecycle Management (DILM) is applying software Application Lifecycle Management (ALM) best practices to Data Integration development and operations (DevOps), version control, release management, and configuration. I can hear you thinking, “But Andy, why would we apply software best practices …
Continue reading An Example of Data Integration Lifecycle Management with SSIS, Part 0
Three Lessons Learned in 2016
Some folks do not like to read posts of a more personal nature or posts that contain religious references. If you are one of those people, you have been forewarned. I’ve read lots of posts from people who are ready for 2016 to be over. I understand their reasons. Celebrities, friends, and family have passed …
Continue reading Three Lessons Learned in 2016
My Top Blog Posts for 2016
(with a nod to @KrispyKreme) I’d like to wish everyone reading this post a blessed, peace-filled, and happy 2017! I would also like to thank you for reading this post and any other posts you may have read. Some Blog Post Stats I published 87 blog posts this year at SqlBlog.com. I published most in …
Continue reading My Top Blog Posts for 2016
Predictions for 2017
I’m hesitant to make predictions for 2017 because I’ve read the parts of the Old Testament that deal with prophets whose predictions did not come to pass. Perhaps a better title for this post is “Hopes for 2017” or “Thoughts for 2017”. The Cloud Will Grow (Filed under “DUH!”) 2016 saw a number of data …
Continue reading Predictions for 2017