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,876 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,599 reads
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
5,148 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,714 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,728 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,663 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,019 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
BCA KCU PURI INDAH Telpon/WA:08137887595.Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3...
BCA KCP Semanggi Telpon/WA:08137887595.Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Bend. Hilir, Kecamatan...
BCA KCP GAMA Telpon/WA:08137887595.Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers