I’m honored and excited to deliver Use Biml to Automate SSIS Design Patterns to the MSDevMTL User Group in Montréal, QC 27 Mar 2018! Session: 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 …
Continue reading Presenting Use Biml to Automate SSIS Design Patterns to MSDEVMTL!
SSIS Catalog Browser Video
Earlier today I went live on Facebook to share features of the latest update for SSIS Catalog Browser (which is FREE): What’s new? View Azure Data Factory version 2 Integration Runtime (aka SSIS in the Cloud) Values Everywhere Project Connections Project Connection References Package Connections Package Connection References :{>
Free Webinar: Introduction to Biml – 22 Feb 2018
Join me Thursday 22 Feb 2018 at noon ET for Introduction to Biml – a free webinar from Biml Academy. Abstract: Join Biml and SSIS author Andy Leonard as he presents Introduction to Biml! In this webinar, Andy covers the following topics: – Code your first Biml file in BimlExpress (free!) – Use BimlScript to automate …
Continue reading Free Webinar: Introduction to Biml – 22 Feb 2018
The Recording for Introduction to SSIS is Now Available
If you missed the live presentation do not despair: The recording for my free webinar Introduction to SSIS is now available (registration required)! Enjoy! :{>
One Solution to Presentation Tracks
A while back I shared some thoughts in a post titled One Solution to Presentation Levels about ways to improve information regarding presentations. This post is a follow-up with one suggestion for how we might improve indications regarding presentation track or content. As with presentation levels, my non-appreciation for presentation tracks is largely driven by presentation evaluation …
Continue reading One Solution to Presentation Tracks
Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
My friend and brother, Patrick LeBlanc (@patrickdba), built a cool Power Bi Dashboard (and database!) to help K12 education systems track students and student activities such as attendance. Better yet, he gives it away! He gives away the code and he shares a free Guy in a Cube video walking through the features. Patrick emailed and …
Continue reading Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
Free Webinar: Introduction to SSIS – 15 Feb 2018
Join me Thursday 15 Feb 2018 at noon ET for Introduction to SSIS – a free webinar from Enterprise Data & Analytics. Abstract: Join SSIS author Andy Leonard as he presents Introduction to SSIS! In this webinar, Andy covers the following topics: – Build your first SSIS package, a data warehouse ETL stage loader – Deploy …
Continue reading Free Webinar: Introduction to SSIS – 15 Feb 2018
Parallel Execution in SSIS Framework Community Edition
A number of folks are using the SSIS Framework Community Edition. I know because I continue to get interesting questions about it! Before I write more, I’d like to invite users to the DILM Suite Slack channel for Community Edition. If you cannot join, please let me know (andy.leonard@dilmsuite.com) and I will invite you! For …
Continue reading Parallel Execution in SSIS Framework Community Edition
I Don’t Just Teach, I’m a Student!
I write a lot about training I deliver: Biml Academy Expert SSIS Immersion Event on Learning SQL Server Integration Services (IESSIS1) I also share about courses I take: Achievement Unlocked: Certified in Implementing Real-Time Analytics with Azure HDInsight Achievement Unlocked: Certified in Implementing Predictive Analytics with Spark in Azure HDInsight Achievement Unlocked: Completed Processing Big …
Continue reading I Don’t Just Teach, I’m a Student!
I Want a Pony
Years ago, I emailed the Microsoft SSIS Developer Team with a request. It’s a long story. The short version is: there’s a bug in the way the SSIS runtime applies package configurations and this bug violates a principle of computing (the command line always wins). I should blog about it… In the email, I included …
Continue reading I Want a Pony