Enjoy! :{>
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. :{>
Free Webinar: Is Power BI Right for You?
Join us for “Is Power BI Right for You?” 15 May at 12:00 PM EDT! Join Pluralsight course author Eugene Meidinger (@SQLGene | sqlgene.com) as he demonstrates problems Power BI is designed to solve. This free webinar includes comparisons between Power BI and popular reporting platforms (SSRS, Tableau) and a high-level introduction to Power BI …
Continue reading Free Webinar: Is Power BI Right for You?
The Space Between
It happened again this weekend. After delivering my presentation titled “Moving Data with Azure Data Factory,” at SQL Saturday – Raleigh (which was awesome, by the way!) – one of the handful who stood because the seats were filled (I am humbled) approached and said, “I read your blog. How do you find time to …
Continue reading The Space Between
The Recording for Enterprise SSIS Execution is Available
Kent Bradshaw and I had a blast delivering more free training from Enterprise Data & Analytics today – this time it was all about Enterprise SSIS Execution. If you were unable to attend, please enjoy the recording here: There’s a coupon code near the end of the recording that will save you money on Enterprise …
Continue reading The Recording for Enterprise SSIS Execution is Available
Free Webinar – Using Biml as an SSIS Design Patterns Engine
The next free webinar from Enterprise Data & Analytics is Using Biml as an SSIS Design Patterns Engine Thursday 2 May 2019 at 12:00 PM EDT. 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. …
Continue reading Free Webinar – Using Biml as an SSIS Design Patterns Engine
HowTo: Install SSIS Framework Community Edition
SSIS Framework Community Edition is available from DILM Suite (Data Integration Lifecycle Management Suite). SSIS Framework CE is not only free, it is open source. To install SSIS Framework Community Edition, visit DILM Suite and click SSIS Framework Community Edition: When the SSIS Framework Community Edition page opens, click the first link: This link will …
Continue reading HowTo: Install SSIS Framework Community Edition
Azure DevOps, Software Development, and Git Part 1 – Applied
I started this series with the title “Azure DevOps, SSIS, and Git” in a post titled Azure DevOps, SSIS, and Git Part 0 – Getting Started. I am renaming it because “I do what I want!” Seriously, I renamed the series – changing “SSIS” to “Software Development” – because I’m going to write about more …
Continue reading Azure DevOps, Software Development, and Git Part 1 – Applied
Staging Data Temporarily in an SSIS Data Flow
My friend Slava Murygin (@SlavaSQL) recently asked a question on Twitter: Populated query results into an object variable sucessfully used it in a data flow task, but can’t use it second time. Is there an easy way around? Tim Mitchell (Blog | @Tim_Mitchell | Tim’s post: Temp Tables in SSIS) and I engaged. You can …
Continue reading Staging Data Temporarily in an SSIS Data Flow
New SSIS Catalog Browser Azure Properties
Thanks to some help from my friend, Sandy Winarko, SSIS Catalog Browser version 0.8.9.0 now includes Azure-SSIS Catalog Properties for Azure Worker Agents and Azure Status. When Azure-SSIS is stopped or starting, SSIS Catalog Browser reports an Azure Status of “Not Running”: Once even one Azure-SSIS worker agent starts, SSIS Catalog Browser reports an Azure …
Continue reading New SSIS Catalog Browser Azure Properties
The Recording for Loading Medical Data with SSIS is Available
Kent Bradshaw and I had a blast delivering Loading Medical Data with SSIS earlier today! If you missed the webinar and, perhaps more importanly, coupon codes to save on upcoming Enterprise Data & Analytics Training. Enjoy the video! We demonstrated a handful of (free!) DILM Suite (Data Integration Lifecycle Management) utilities: Catalog Reports SSIS Catalog …
Continue reading The Recording for Loading Medical Data with SSIS is Available