Join me Thursday 15 Feb 2018 at noon ET for Introduction to SSIS – a free webinar from Enterprise Data & Analytics. Abstract: Join SSIS author Andy Leonard as he presents Introduction to SSIS! In this webinar, Andy covers the following topics: – Build your first SSIS package, a data warehouse ETL stage loader – Deploy …
Continue reading Free Webinar: Introduction to SSIS – 15 Feb 2018
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. :{>
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 (andy.leonard@dilmsuite.com) and I will invite you! For …
Continue reading Parallel Execution in SSIS Framework Community Edition
I Don’t Just Teach, I’m a Student!
I write a lot about training I deliver: Biml Academy Expert SSIS Immersion Event on Learning SQL Server Integration Services (IESSIS1) I also share about courses I take: Achievement Unlocked: Certified in Implementing Real-Time Analytics with Azure HDInsight Achievement Unlocked: Certified in Implementing Predictive Analytics with Spark in Azure HDInsight Achievement Unlocked: Completed Processing Big …
Continue reading I Don’t Just Teach, I’m a Student!
I Want a Pony
Years ago, I emailed the Microsoft SSIS Developer Team with a request. It’s a long story. The short version is: there’s a bug in the way the SSIS runtime applies package configurations and this bug violates a principle of computing (the command line always wins). I should blog about it… In the email, I included …
Continue reading I Want a Pony
SSIS Catalog Compare: Help for DBAs Who Support SSIS
In my SQL Server Central article, Help for DBAs Who Support SSIS, I walk through several DILM (Data Integration Lifecycle Management) use cases including: Surfacing SSIS Catalog metadata Comparing SSIS Project configurations in two SSIS Catalogs Scripting SSIS Project ISPAC files Deploying an SSIS Project from one SSIS Catalog directly to another SSIS Catalog Generating scripts …
Continue reading SSIS Catalog Compare: Help for DBAs Who Support SSIS
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
What is the Problem You Are Trying to Solve?
How may I serve to help you solve this problem? What would you like for me to blog about? Please comment.
I’m a Speaker Mentor!
I’m honored to be part of an effort started by Alex Yates of DLM Consultants called Speaking Mentors. From the Home page: We are a bunch of experienced speakers who freely and without caveats offer our time to support first time speakers to deliver their first few sessions at tech meetups and/or conferences. If you would …
Continue reading I’m a Speaker Mentor!
Presenting DevOps for SSIS 08 Feb 2018
I am honored to present DevOps for SSIS (or Data Integration Lifecycle Management) for the PASS DevOps Virtual Chapter 08 Feb 2018. Abstract: DevOps for SSIS (or Data Integration Lifecycle Management) How does SSIS participate in enterprise DevOps? Sharing topics from his latest book (Data Integration Life Cycle Management with SSIS), author and presenter Andy …
Continue reading Presenting DevOps for SSIS 08 Feb 2018