In my last post titled Fabric: Load Data from a CSV File Stored in Azure Blob Storage to Azure SQL DB, I documented one way to create a pipeline to load data from a CSV file stored in Azure Blob Storage to an Azure SQL Database in a new Fabric workspace. In this post, I …
Continue reading Fabric: Test-Driving the New Office 365 Outlook Data Factory Activity
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>
A Procrastination Tale
Late in the evening of 30 Dec, the temperature in casa de Leonard began dropping. The thermostat continued to report a 68°F setting, our setting for cool-ish to downright cold evenings. When I first checked the in-house temperature a little after midnight, the current temperature read 64°F. By morning, the current temperature had dropped to …
Continue reading A Procrastination Tale
Fabric: Load Data from a CSV File Stored in Azure Blob Storage to Azure SQL DB
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
Create a Workspace in Fabric
In November 2023, I shared how to start learning Microsoft Fabric in a post titled Start a Fabric Free Trial. Once your free trial is set up, one good next step is to create a Workspace. Begin by browsing to Fabric at app.fabric.microsoft.com: After logging in, select any of the available capabilities displayed on the …
Continue reading Create a Workspace in Fabric
Save Money on 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
The John Barker Mentoring Project
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
SQL Server Integration Services Extensions Updates
It’s been a while since I blogged about SSIS extensions to Visual Studio. For that, I apologize. During my hiatus, The Microsoft SSIS Team appears to have separated the SSIS extensions for Visual Studio 2019 and Visual Studio 2022. The latest version of the Visual Studio 2019 SSIS extension is version 4.5, updated on my …
Continue reading SQL Server Integration Services Extensions Updates
Testing New SSIS Extensions – Some Basics
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
Update on my January 2023 Offer for Free Training
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
Start a Fabric Free Trial
Are you interested in learning more about Microsoft Fabric? One way to begin tinkering with the new platform is to start a free trial. At the time of this post, a free trial is available here: You may be prompted to check your eligibility for the free Fabric Trial. If so: Enter your email address …
Continue reading Start a Fabric Free Trial