Learn how to use Azure Data Factory to dynamically move bulk data from multiple sources to a new destination using the ForEach and Lookup activities.
2024-03-04
Learn how a C# script can easily load data from Excel into SQL Server.
2024-01-15
6,927 reads
The ForEach loop works with only one file type at a time by default. Learn how you can add code to your packages to work with multiple types of files.
2023-12-18
3,661 reads
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
5,196 reads
Learn how you can configure an Azure Data Factory pipeline that is triggered by an email being sent to an address.
2023-11-03 (first published: 2023-10-27)
4,761 reads
Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.
2023-10-25
Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.
2023-10-18
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
2024-09-23 (first published: 2023-10-16)
2,784 reads
This article shows how you can have your Azure Data Factory (ADF) pipeline send an email using a Logic App.
2023-09-29
3,726 reads
Learn how you can use monitor your data warehouse load process with Python code and a structured process.
2023-10-06 (first published: 2023-09-20)
2,027 reads
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
I don't see a PowerBI forum, so I'm posting here. I have a need...
Comments posted to this topic are about the item SQL Server Certificates
Comments posted to this topic are about the item Connect an Azure Function to...
Which of these is not true for certificates used for SQL Server connections?
See possible answers