Data Minute and Links for 03 Feb 2021

I’ve experienced an issue with Restream.io not recording my screen for the past couple days. I’m on the horn with Restream Technical Support as I type, and I am certain they will get it resolved quickly because Restream is awesome. The bug means I needed to reshoot (yay…not really…) the screen and edit the video. …
Continue reading Data Minute and Links for 03 Feb 2021

Data Minute Links for 02 Feb 2021

Links for today’s Data Minute: Companies will battle for boomers Is Azure Synapse Analytics Ready for Production? Data Minute Today’s Sponsor: Enterprise Data & Analytics Are you interested in sponsoring a Data Minute? Contact me! I welcome your feedback and suggestions for Data Minute. :{> Need Help With Your Enterprise Data Warehouse or ETL? At …
Continue reading Data Minute Links for 02 Feb 2021

Updates to the SSIS Extension for Visual Studio 2019

On 25 Jan 2021, the Microsoft SSIS Team released version 3.12 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning that users rollback to v 3.11.1. The warning was issued 31 Jan 2021 and reads: …
Continue reading Updates to the SSIS Extension for Visual Studio 2019

SSIS Framework Manager Community Edition Updated

I made a few changes to SSIS Framework Manager CE (Community Edition). The most impactful change is to the SSIS Framework Application Execute functionality. In the initial (alpha!) release, framework application executions – executed from SSIS Framework Manager CE (only) – timed out at 30 seconds. This was due to the default SqlCommand timeout and …
Continue reading SSIS Framework Manager Community Edition Updated

New DataDriven Episode with Dan Burcaw

Links Sponsor: Audible.com – Get a free audio book when you sign up for a free trial! Notable Quotes BAILeY’s Introduction (00:00) “Foreshadowing” – BAILeY (00:36) Andy shares about proofing Building Custom Tasks for SQL Server Integration Services, 2nd EDition (01:30) Introducing Dan and Nami ML (05:00) Dan wrote an app – when he was …
Continue reading New DataDriven Episode with Dan Burcaw

An ADF Azure-SSIS Framework

I spent a little time walking through the third section of the book SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory co-authored by (the) Kent Bradshaw and me. At the start of Part 1, I included thoughts about our first review. Part 1 did not go as planned. …
Continue reading An ADF Azure-SSIS Framework

Announcing SSIS Framework Manager CE (Community Edition)

I’m excited to announce SSIS Framework Manager CE (Community Edition) is available for download at DILM Suite! SSIS Framework Manager CE is designed to support SSIS Framework Community Edition, providing a GUI to facilitate SSIS Framework Application creation, configuration, and management. Three views are supported in this initial edition: Catalog, Application, and Package. The Catalog …
Continue reading Announcing SSIS Framework Manager CE (Community Edition)