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
22,034 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)
15,870 reads
In this article, learn how to use Azure Data Factory with a REST API to download files.
2020-09-07
15,049 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
11,027 reads
In this article we cover some things you should consider when determining whether to use Azure Data Factory, SSIS or Azure Databricks.
2020-07-03
Learn how to build your first Azure Data Factory Pipeline
2020-04-28
9,129 reads
By DataOnWheels
Hello data friends! Had a blast at my first ever M365 Community Day this...
By Steve Jones
One interesting concept in SQL Server is Deferred Name Resolution. This is something many...
By Kevin3NF
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...
Comments posted to this topic are about the item List the Databases To Which...
We rebuilt a bunch of indexes that had avg_fragmentation_in_percent>30. Now we have 1 job...
Good Afternoon. I have been manually running an SSIS package on an adhoc basis,...
What is returned from the following query ?
declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000' select dateadd(hour, 3.0/2, @currentDateTime);See possible answers