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).

Experience Matters

This is a picture of Kent Bradshaw, Microsoft Certified Data Scientist. Kent and I work together at Enterprise Data & Analytics delivering data engineering, business intelligence, and data-based solutions that help businesses turn their data into actionable information. We do not do this alone, we are surrounded by an excellent team that holds diverse skills, …
Continue reading Experience Matters

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

Data Integration Pattern: The Pessimistic Load

“What is a Pessimistic Load?” I’m glad you asked! A pessimistic load is any load pattern that incorporates a strict reconciliation process. Strict reconciliation throws an error when the reconciliation effort fails. How Does It Work? First you load some records. Then you check to see if the records you intended to load have been loaded. …
Continue reading Data Integration Pattern: The Pessimistic Load

Immersion Event on Learning SSIS – May 2018!

I am honored to partner with the awesome team at SQLSkills to deliver IESSIS1: Immersion Event on Learning SQL Server Integration Services in person in Chicago 7-11 May 2018! Click here to register! Here’s what I’ll be covering: Module 1: Introduction In the introduction we share information about the instructor, course flow, and content, and gather …
Continue reading Immersion Event on Learning SSIS – May 2018!

Available for Pre-Order – The Biml Book!

  I am excited to announce The Biml Book is now available for pre-order from Amazon and Apress! I was honored to write with the inventor of Biml, Scott Currie, and an awesome team of BimlHeroes: Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows, Simon Peck, Reeves Smith, Raymond Sondak, Benjamin Weissman, and Cathrine Wilhelmsen. Chapters …
Continue reading Available for Pre-Order – The Biml Book!

Why I Do Not Mix High Availability with Reporting Solutions

One way to offload reporting requirements from the Production OLTP (OnLine Transaction Processing) database while providing a near-real-time copy of Production data is to execute reporting and analytics queries against a High Availability solution replica – such as SQL Server Availability Groups. Learn more about Availability Groups On at: Overview of Always On Availability Groups (SQL Server). “Why …
Continue reading Why I Do Not Mix High Availability with Reporting Solutions