Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!

I am honored to deliver a full day pre-conference session at the PASS Data Community Summit 2022! My precon is titled “A Day of Azure Data Factory.” Register today! Abstract In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including: – Version control …
Continue reading Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!

SSIS Catalog Browser v0.9.10 is Available

I am excited to share the latest release of SSIS Catalog Browser, and it’s still free at DILM Suite! A feature I forgot to mention in the video is the “Check for Update” menu item: If you are running the current version – beginning in version 0.9.10.0 – clicking Help>Check for Update will display a …
Continue reading SSIS Catalog Browser v0.9.10 is Available

Technology Marketing Template

This month (May 2022), I mark 47 years since I first flipped toggle switches representing hexadecimal bytes and machine code commands into a Motorola 6800 processor trainer. I remember the thrill of watching the program successfully execute. I still experience a thrill when code runs as intended (usually after much debugging). I was recently inspired …
Continue reading Technology Marketing Template

After Azure Subscription Disabled, Restart ADF Triggers

A couple / three days after delivering the April 2022 edition of Master the Fundamentals of Azure Data Factory (the next delivery is 20 May 2022 – check out Enterprise Data & Analytics Training to register and save money!), I got an email from Azure informing me my account had been disabled because I reached …
Continue reading After Azure Subscription Disabled, Restart ADF Triggers

One Way to Create an Azure-SSIS IR in Synapse Analytics

On 17 Feb 2022, I first saw the Microsoft announcement of the public preview of Azure-SSIS integration runtimes in Azure Synapse Analytics. I blogged about the announcement in a post titled Azure-SSIS Integration Runtime now available in Azure Synapse Analytics. I am excited to share one way for you to provision an Azure-SSIS IR in …
Continue reading One Way to Create an Azure-SSIS IR in Synapse Analytics

Azure-SSIS Supports SSIS 2017 Only

With the recent public preview release of Synapse-SSIS, I want to remind SSIS developers that Azure-SSIS integration runtimes – be they configured in Azure Data Factory (ADF) or in Azure Synapse Analytics – support only SSIS 2017 packages. Errors most often occur when executing SSIS packages that contain script tasks or script components. If you deploy …
Continue reading Azure-SSIS Supports SSIS 2017 Only

Short Video on Azure-SSIS in Synapse Analytics

Last week, Microsoft announced the public preview of Azure-SSIS Integration Runtime in Azure Synapse Analytics. I streamed about this announcement. Enjoy! The websites mentioned in this stream: Azure-SSIS Integration Runtime now available in Azure Synapse Analytics (Public Preview) Enterprise Data & Analytics Free stuff (and some stuff for sale) at Data Integration Lifecycle Management Suite …
Continue reading Short Video on Azure-SSIS in Synapse Analytics