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 Comunity 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

Learn Power BI From Eugene Meidinger 13 Aug!

I’m excited to announce the availablity of a brand new Enterprise Data & Analytics course titled Power BI: Implementing the Other 90% by Eugene Meidinger (@SQLGene | SqlGene.com)! Abstract One of the things Eugene Meidinger found frustrating when he first learned Power BI was all of the behind-the-scenes configuration required to bring Power BI to the enterprise. …
Continue reading Learn Power BI From Eugene Meidinger 13 Aug!

Free Webinar – Enterprise SSIS Execution

Join Kent Bradshaw and me as we present (another) free Enterprise Data & Analytics webinar Tuesday, 23 Apr 2019 at 12:00 PM EDT: Enterprise SSIS Execution. Abstract SQL Server Integration Services (SSIS) is a powerful enterprise data integration tool that ships free with Microsoft SQL Server. Join Andy Leonard – Microsoft Data platform MVP, author, …
Continue reading Free Webinar – Enterprise SSIS Execution