Joining Queries in Azure Data Factory on Cosmos DB Sources
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
718 reads
ETL/SSIS/Azure Data Factory
Choosing Between SSIS vs ADF: What You Need to Know
In this article, we look at how you might go about choosing whether to use SSIS or ADF for your next ETL/ELT project.
2024-04-01
Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities
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
A Simple Method to Load Excel Data
Learn how a C# script can easily load data from Excel into SQL Server.
2024-01-15
6,090 reads
Configuring an SSIS ForEach Loop for Multiple File Types
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
2,019 reads
Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
1,921 reads
Trigger the Execution of an ADF Pipeline from an Email
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)
2,522 reads
Top 10 Methods to Improve ETL Performance Using SSIS
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
What I Wish Everyone Knew About ETL Processes - Traditional to Modern Cloud Solutions
Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.
2023-10-18
GIT Configuration and Automated Release for Azure Data Factory
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
2023-10-16
1,812 reads
Blogs
Derby City Data Days
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Tomorrow: Webcast on SQL Server security
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
A New Word: the Wends
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Forums
Should I create tables with dynamic SQL?
Hello all, I am thinking of creating a "shopping cart" in our application. My...
Expression Error ( property 'Error' cannot be selected )
Hello there. I have the following Pipeline I want to get the property error...
create cluster fails Win2016.
I'm installing a cluster prior to my 2019 SQL build. Failover Cluster tools...
Question of the Day
Express In-Memory OLTP
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers