Category:Uncategorized

I am honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday 620 – Dublin 17 Jun! Abstract Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one …
Continue reading Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday Dublin 17 Jun!

I am honored to present my day-long precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration at SQL Saturday 620 – Dublin 15 Jun 2017! Description 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 …
Continue reading Presenting A Day of Intelligent Data Integration Precon at SQL Saturday Dublin!

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…