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
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. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
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
Tom Roush
This is a picture of my friend Tom Roush and me from a few years ago. Tom passed away 29 Jan 2018 after a protracted battle with cancer. He was my friend and brother and I will miss his easy smile, sage wisdom, and German wit. I used to refer to Tom as “the best …
Continue reading Tom Roush
Andy’s Excellent SSIS-in-the-Cloud Adventure and PowerShell
If you’re new to PowerShell or just don’t know PowerShell, tinkering with Azure Data Factory Version 2 Integration Runtime (ADFv2 IR) can be intimidating. In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance, I walk you through the PowerShell part, sharing my (meager) knowledge of this awesome utility, assuming little (assuming nothing, …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure and PowerShell
Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives
In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance I wrote about the three steps to configure Azure-SSIS Integration Runtime in Azure Data Factory Version 2 (ADFv2 IR, or SSIS in the cloud). In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project I wrote about deploying, …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives
Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project
In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance I wrote about the three steps to configure Azure-SSIS Integration Runtime in Azure Data Factory Version 2 (ADFv2 IR, or SSIS in the cloud). In this post, I’m going to continue by showing you how to deploy, execute, and monitor an SSIS package. …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project
Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance
Maybe you’ve heard SSIS is available in the cloud. It is! But it’s not easy to get set up (at the time of this writing). I am here to help. The correct name for “SSIS in the cloud” is: Azure-SSIS Integration Runtime in Azure Data Factory version 2. Azure Data Factory version 2 is sometimes abbreviated …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance
Updates to SSIS Catalog Browser
I’m happy to announce the release of Catalog Browser v0.5! I taught the app a new trick: viewing SSIS Catalogs in Azure! Of course, Catalog Browser still works locally: As the next release of SSIS Catalog Compare approaches, I’ve been testing – a lot. Catalog Browser shares quite a bit of functionality with Catalog Compare – …
Continue reading Updates to SSIS Catalog Browser