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
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. :{>
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
Launching entdn.ai
Every business venture needs a launch day. Today I launch Enterprise Data & AI (entdn.ai). entdn.ai is an idea that’s been bouncing around my soul for a while. We implement data science, machine learning, and AI solutions. If you visit the site, you will find a use case that essentially describes an LLM (large language …
Continue reading Launching entdn.ai
SSIS Catalog Error 27150
In case you’ve never encountered SSIS Catalog Error 27150, the error message reads: The version of the project has changed since the instance of the execution has been created. Create a new execution instance and try again. A customer recently encountered this error. So… what happened? Short Answer The version of a project changed during …
Continue reading SSIS Catalog Error 27150