SQL Server Data Automation Through Frameworks is Available!

Kent Bradshaw and I are excited and honored to announce the release of our latest book, SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory! Enjoy! :{> Need Help? Enterprise Data & Analytics delivers private training, can join your team to help implement your enterprise data warehouse solution, …
Continue reading SQL Server Data Automation Through Frameworks is Available!

Andy’s Black Friday Training Sale is Coming…

Next week, Enterprise Data & Analytics kicks off the Black Friday Training Sale! This year’s sale begins 1 Nov 2020 with a substantial discount on our Live Season Pass (attend my SSIS and ADF training course deliveries for a full year) for two weeks only! The Enterprise Data & Analytics Black Friday¬†ends 13 Dec 2020. …
Continue reading Andy’s Black Friday Training Sale is Coming…

Azure-SSIS Catalog Database Connection Failed

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

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

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