Author:Andy Leonard

I’m writing about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL Server Agent to schedule the execution of an SSIS Application and …
Continue reading The Heart of SSIS Framework Community Edition-Parent.dtsx

I’m writing more about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages – called SSIS Applications – in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL Server Agent to schedule the …
Continue reading Adding an SSIS Application to SSIS Framework Community Edition

The coolest thing about SSIS Framework Community Edition is it’s free. You can click that link to head over to the DILM Suite site where you can learn more and find a link to the source code, documentation, and sample SSIS projects on GitHub. I’m overwhelmed by the number of folks using this free utility. …
Continue reading Schedule an SSIS Application with SSIS Framework Community Edition

The coolest thing about SSIS Framework Community Edition is it’s free. You can click that link to head over to the DILM Suite site where you can learn more and find a link to the source code, documentation, and sample SSIS projects on GitHub. I’m overwhelmed by the number of folks using this free utility. …
Continue reading Schedule an SSIS Application with SSIS Framework Community Edition

I’m honored to present Use Biml as an SSIS Design Patterns Engine at SQL Saturday #588 in New York City 20 May 2017! I’ve been looking at the event schedule and… WOW! There are a lot of smart people presenting – plus me! I hope to see you there. :{>

This post is a follow-up to Mind the Gap where I wrote about Δ, the difference between our perception of ourselves and other’s perception of us. In Mind the Gap I focused on personal and community ramifications of minimizing your Δ. In this post I write about applying these same concepts to data science, analytics, …
Continue reading Data Science, Unicorns, and Some Things That Never Change

Enterprise Data & Analytics present Enterprise SSIS, Biml, and DILM – a free webinar 11 Jul 2017 at 1:00 PM. Register today! In case you missed it, the recording for our last free webinar – Designing an SSIS Framework – is available. :{> Learn More: The Recording for Designing an SSIS Framework is Now Available …
Continue reading Free Webinar: Enterprise SSIS, Biml, and DILM

Please help: If you commented below please email me by clicking the Email link and sending me an email. Redgate wants to notify the winners! Thank you,Andy  …and win an Amazon Echo Dot and one lucky winner will score a free SQL Clone license! About SQL Clone I can hear you thinking, “What’s SQL Clone, …
Continue reading UPDATED: Use Amazon’s Alexa to Create a Copy of a Database Using Redgate SQL Clone…

Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can now view the webinar for free (although registration is required) here. In the webinar Kent and I discussed the following Data Integration Lifecycle Management Suite products: SSIS Framework Community Edition …
Continue reading The Recording for Designing an SSIS Framework is Now Available

I am honored to present Intelligent Data Integration – a day-long precon at SQL Saturday #643 in Louisville Kentucky 4 Aug 2017! Synopsis: What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM, produced using Biml and executed using an SSIS Framework. …
Continue reading Presenting Intelligent Data Integration Precon at SQL Saturday–Louisville!