In November 2023, I shared how to start learning Microsoft Fabric in a post titled Start a Fabric Free Trial. In December 2023, I shared how to Create a Workspace in Fabric. In this post, I document one way to create a pipeline to load data from a CSV file stored in Azure Blob Storage to …
Continue reading Fabric: Load Data from a CSV File Stored in Azure Blob Storage to Azure SQL DB
Regular readers of this blog know I am all about saving money. I’ve blogged about ways to set up inexpensive instances of Azure SQL DB. I recently learned a couple new ways to save even more money working with Azure SQL. Both methods begin the same: The Stuff in Common Begin by connecting to the Azure …
Continue reading Save Money on Azure SQL DB
John Barker retired from the US Air Force in or around 1975. He returned home to rural Blackstone Virginia, in part to help care for his aging parents. He had experience in electronics as a technician and built a Southwest Technical Products M6800 computer kit. Although I’m not sure this is an accurate image of …
Continue reading The John Barker Mentoring Project
Featured image test tube drawing attribution: Test Vectors by Vecteezy. How do I test new SQL Server Integration Services (SSIS) extensions and updates to Visual Studio? I have a collection of virtual servers that run locally on my laptop. SSIS extensions for Visual Studio 2019 and Visual Studio 2022 are now separate downloads (see the …
Continue reading Testing New SSIS Extensions – Some Basics
In late January 2023, I shared a post titled “Laid Off? Or the Beginning of Your Next Opportunity?” in which I offered free access to one year of Enterprise Data & Analytics Premium Level – which contains all my recorded training. As you may read in the original post, I was inspired to make the …
Continue reading Update on my January 2023 Offer for Free Training
Update: Erin Stellato [LinkedIn], program manager extraordinaire, responded to my off-topic comment (that inspired this post): Thanks, Erin! If you would like to suggest or view other suggested changes to a Microsoft product or platform, head over to the page labeled Microsoft Azure | Share your Ideas. I have to warn you to not get …
Continue reading SQL Feedback
This post is part of a short series on Azure Data Factory pipeline return value functionality, which is in preview at the time of this writing. The Problem I am Trying to Solve I want to develop an Azure Data Factory (ADF) design pattern for calling focused, unit-of-work, function-y ADF pipelines that perform focused tasks. …
Continue reading One Complex Example of ADF Pipeline Return Value
This post is part of a short series on Azure Data Factory pipeline return value functionality, which is in preview at the time of this writing. The Problem I am Trying to Solve I want to develop an Azure Data Factory (ADF) design pattern for calling focused, unit-of-work, function-y ADF pipelines that perform focused tasks. …
Continue reading One Simple Example of ADF Pipeline Return Value
While delivering Azure Data factory (ADF) consulting for a client, I had the opportunity to develop some utility pipelines that used Pipeline return values functionality (in preview at the time of this writing). For me, this exercise was a two-step process, which I share in this series: One Simple Example of ADF Pipeline Return Value …
Continue reading ADF Pipeline Return Value Series
09 Aug 2023 Update: Yitzhak Khabinsky and I met via Microsoft Teams to continue the conversation that started in the comments section of this post and was continued on LinkedIn. There will likely be more to come… Why Use XML to Transfer Data? I asked Brave Search, “Why use XML?” Brave responded with a Summarizer …
Continue reading XMheck (formerly “XMhell”)
