I am humbled, honored, and excited to present Faster SSIS at SQL Saturday #721 – Raleigh 14 Apr 2018! Abstract Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) …
Continue reading Honored to Present Faster SSIS at SQL Saturday #721 – Raleigh 14 Apr 2018!
Category:SSIS Design Patterns
Introduction to SSIS Design Patterns, Part 1 – 8 Mar 2018
Join me 8 Mar 2018 at noon ET for another free webinar, Introduction to SSIS Design Patterns, Part 1! SSIS Design Patterns are tried and true data integration patterns built in SQL Server Integration Services (SSIS). Join author and international speaker Andy Leonard as he explores: – The Truncate and Load Staging Pattern – The …
Continue reading Introduction to SSIS Design Patterns, Part 1 – 8 Mar 2018
Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!
I am honored to announce I have been selected to deliver a full-day precon titled A Day of Intelligent Data Integration with SSIS and ADF at the Data Platform Summit 2018 in Bengarulu, India 7 Aug 2018! This will be my first appearance at the Data Platform Summit and my first visit to India. I …
Continue reading Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!
Presenting Use Biml to Automate SSIS Design Patterns to MSDEVMTL!
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!
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 ([email protected]) and I will invite you! For …
Continue reading Parallel Execution in SSIS Framework Community Edition
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
Honored to Present Faster SSIS at SQL Saturday #719 – Chicago 17 Mar 2018
I am honored to present Faster SSIS at SQL Saturday #719 in Chicago 17 Mar 2018! Abstract: Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages. We’ll start …
Continue reading Honored to Present Faster SSIS at SQL Saturday #719 – Chicago 17 Mar 2018
Apache Storm Stream Processing in Azure HDInsight
I’m learning more about Apache Storm which is used for stream processing for near-real-time analytics in Azure HDInsight. I grabbed the image above from an AWS presentation on slideshare (link). I got all giggly inside as I learned about Storm architecture. Why? Because I built this much of this same functionality as part the DILM …
Continue reading Apache Storm Stream Processing in Azure HDInsight
Expert SSIS Training: SSIS Design Patterns for Performance
I focus on three topics in the Expert SSIS course I deliver live, online in cooperation with Brent Ozar Unlimited: SSIS Design Patterns for Performance SSIS Deployment, Configuration, Execution, and Monitoring Automation What do I cover in SSIS Design Patterns for Performance? I cover Data Flow Internals, chat about throughput – the OBM (One Big Metric) …
Continue reading Expert SSIS Training: SSIS Design Patterns for Performance
The Next Book Project: Frameworks
Kent Bradshaw, Shannon Lowder, and I explore stored procedure-based data integration patterns, an SSIS execution framework, and two Biml frameworks in a book we are writing, tentatively titled Frameworks.