2021-01-14
21,229 reads
2021-01-14
21,229 reads
2020-11-23
450 reads
This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]
2020-11-12
10,917 reads
Azure Data Factory is a cloud based data orchestration tool that many ETL developers began using instead of SSIS. In this article, Rodney Landrum recalls a Data Factory project where he had to depend on another service, Azure Logic Apps, to fill in for some lacking functionality.
2020-10-23
Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.
2020-10-19
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
2022-04-18 (first published: 2020-10-13)
11,762 reads
In this article, learn how to use Azure Data Factory with a REST API to download files.
2020-09-07
10,019 reads
This article will demonstrate how to get started with Delta Lake using Azure Data Factory's new Delta Lake connector through examples of how to create, insert, update, and delete in a Delta Lake.
2020-09-01
Learn how to build a catalog of your different Azure Data Factory objects such as pipelines, activities, datasets and more.
2020-08-17
Introduction Azure Data Factory is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. We can create and schedule data pipelines which can move data between various supported data stores. We can also use for data transformation before loading it into […]
2020-08-11
9,031 reads
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
I was reading a SharePoint List using the “Get Items” activity in an Azure...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
If I setup log shipping for a database, and I want to do a...
Hi, We are using SQL 2014 version. The scheduled backup job is failing with...
Hello, I've a user database which I want to migrate to new server, so...