Azure Data Factory Interview Questions and Answers
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
4,435 reads
ADF
Understanding the Mapping Data Flow Activity in Azure Data Factory
Learn about using Mapping Data Flows in Azure Data Factory.
2022-04-25
9,496 reads
How to Flatten JSON in Azure Data Factory?
When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]
2021-09-17
20,419 reads
Working with Get Metadata Activity in Azure Data Factory
Learn how to gather metadata information about the files being processed in your ADF pipeline.
2021-08-20
23,654 reads
Why Power Query as an Activity in Azure Data Factory and SSIS?
There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
2021-07-26
4,454 reads
Reading Stored Procedure Output Parameters in Azure Data Factory
This article will help you to work with Store Procedure with output parameters in Azure data factory.
2021-04-06
34,675 reads
How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?
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,435 reads
Blogs
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Act on Your Certification Test Results
By Brian Kelley
Pass or fail, act on your certification test results.
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers