Free Webinar: Using the Azure Data Factory If Condition and Web Activities

The summer o’ ADF continues with another free webinar from Enterprise Data & Analytics Friday, 14 Jun 2019 at 12:00 PM EDT: Using the Azure Data Factory If Condition and Web Activities! Abstract Join Microsoft Data Platform MVP and author Andy Leonard for 30 minutes packed with demos. In this session, Andy walks through using …
Continue reading Free Webinar: Using the Azure Data Factory If Condition and Web Activities

The Recording of Build and Load a Staging Database with Biml

The recording of Enterprise Data & Analytics’ free webinar titled Build and Load a Staging Database with Biml is available! Get the Code! Download the SSIS solution files here: Load AdventureWorks2017_Stage – version 0 Load AdventureWorks2017_Stage – version 1 Load WideWorldImporters Want More? Learn more from Andy Leonard and the professionals at Enterprise Data & …
Continue reading The Recording of Build and Load a Staging Database with Biml

Mean Time to Identify Failure

While managing a team of 40 ETL developers, I wanted to track lots of metrics. Some of the things I wanted to track were technical, like SSIS package execution times. Some metrics were people-centric.  Andy’s First Rule of Statistics states: You can use statistics for anything about people, except people. Andy – circa 2005 It was …
Continue reading Mean Time to Identify Failure

Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!

I am honored to announce I will be delivering Intelligent Data Integration through SSIS – a day-long SQL Saturday 841 – Dallas pre-conference session 31 May 2019! Description: What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data …
Continue reading Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!

Enterprise Data & Analytics Welcomes Shannon Lowder!

I am honored and thrilled to welcome Shannon Lowder (@shannonlowder | blog | LinkedIn) to the Enterprise Data & Analytics team! Shannon is a data engineer, data scientist, BimlHero (though not listed on the page at the time of this writing), and shepherd of the Biml Interrogator open source project. If you use Biml to generate SSIS …
Continue reading Enterprise Data & Analytics Welcomes Shannon Lowder!

Biml, Book Reviews, and Metadata-Driven Frameworks

I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks

100 Dumb Little Things

Software development is hard. It takes time, yes. But more than that, software development takes patience and thought and blood and sweat and love and tears. My friends at Varigence recently released an update to their Business Intelligence Markup Language (Biml) products. If you’re into business intelligence or data science, integration, or engineering, you should …
Continue reading 100 Dumb Little Things

SSIS Design Pattern: Controller Pattern

The SSIS Design Pattern known as the Controller Pattern provides a solution for executing SSIS packages in parallel – even from a serial SSIS execution framework such as SSIS Framework Community Edition (part of DILM Suite).