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
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. :{>
Data Minute
This morning, I tried something new. I call it Data Minute. I’m not sold on that title. I like the idea though, a bunch. We shall see where it goes from here – if anywhere. What do you think? What would you like to see in a Data Minute? Enjoy! :{>
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
Thoughts on an Amazon Review
In this video, I share more about a negative review on Amazon, one about which I wrote in Regarding Amazon Reviews. I’m channeling my inner Gary Vaynerchuk and addressing a critic directly. Enjoy! :{>
SQL Data Partners Episode 215: Azure Data Factory
I was honored to chat with Carlos Chacon and Eugene Meidinger of SQL Data Partners about Azure Data Factory! :{>
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)
One Good Question
“How do I…?” I get questions that begin this way. Today, a friend reached out to ask how to search internals of SSIS packages deployed to an instance of the SSIS Catalog. My response was, “I don’t know, but this is how I would learn the answer.” I sent the following query: Select OBJECT_NAME(id) as …
Continue reading One Good Question