I was provisioning a new Azure Data Factory (ADF) Azure-SSIS Integration Runtime (IR) to conduct some testing and, when I clicked the “Test connection” link, I got a Connection failed error as shown in the red box: I clicked the “More” link to display details in the blue box To provision new Integration Runtime, Azure …
Continue reading Azure-SSIS Catalog Database Connection Failed
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. :{>
Azure Data Factory and SSIS Training 2020-Q4
Join me 16-19 Nov 2020 for four days of SQL Server Integration Services (SSIS) training! Days 1 and 2 focus on development using real-world data (I love AdventureWorks for demos, but real-world data is never that clean). Students complete 10 labs on days 1 and 2 and get to play the game What Will SSIS …
Continue reading Azure Data Factory and SSIS Training 2020-Q4
My Stream About Writing a Technical Book
I streamed about writing a technical book earlier today (19 Oct 2020). I referenced a couple blog posts: Writing a Technical Book One Way to Write a Technical Book Enjoy! :{>
Biml Stream – 13 Oct 2020
I streamed about Biml earlier. And BimlExpress (which is free). And my BimlExpress Metadata Framework (which is also free). Enjoy! :{>
SSIS 2019 Extension v3.10 for Visual Studio 2019 Released
The Microsoft Azure-SSIS team released version 3.10 of the SQL Server Integration Services Projects extension a couple weeks back. I missed it until today because my writing is keeping me in my SSIS 2017 VMs and, truth be told, I am a little off my game the past few weeks. Apologies for this delayed post. …
Continue reading SSIS 2019 Extension v3.10 for Visual Studio 2019 Released
How to Promote SSIS Code in the Enterprise Lifecycle
I’ve written about Data Integration Lifecycle Management (DILM) tiers. To summarize, every enterprise needs at least four lifecycle management tiers: 1. Development – an environment in which developers have sysadmin privileges. 2. Test – another environment in which developers have sysadmin privileges. 4. Production – managed by production operations such as domain administrators, system administrators, …
Continue reading How to Promote SSIS Code in the Enterprise Lifecycle
Slowly Coming Back, October 2020 Edition
I share a lot. Because I share a lot, many people believe: I am an extrovert; and I share everything. Neither is accurate. I am an introvert with a strong desire to help others. My desire overcomes my introvert nature enough to keep me out there. Truth be told? I’d rather be spending time with …
Continue reading Slowly Coming Back, October 2020 Edition
SSIS Catalog Browser Live Demo
I am delivering more and more live streaming sessions. The session for today (6 Oct 2020) was all about SSIS Catalog Browser, a free utility from DILM Suite. DILM Suite hosts several utilities to help with Data Integration Lifecycle Management (DILM). Most are free and many are open source. You should check it out! Enjoy …
Continue reading SSIS Catalog Browser Live Demo
Training and Failure
The image above is a screenshot from the My Expectations slide. It’s part of my From Zero to SSIS course. You can learn more about this course (and others) at the Enterprise Data & Analytics Training page. The part in the box is important: “This is a safe place to fail.” I share that in …
Continue reading Training and Failure
Feedback From a Student
I just received this from a student who took advantage of my offer of Free Training for People Who Have Lost Their Jobs – which continues; some students in my From Zero to SSIS course delivery this week are taking advantage of this offer. How does it work? Visit the post titled Free Training for …
Continue reading Feedback From a Student