ADF

SQLServerCentral Article

How to Flatten JSON in Azure Data Factory?

  • Article

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) […]

4.5 (2)

2021-09-17

13,355 reads

SQLServerCentral Article

How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

  • Article

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 […]

4.5 (2)

2020-11-12

16,353 reads

Blogs

New Job -> Week 3 -> Creating Alerts

By

This is part of a series of new job blog posts. You can find...

Using SQL Alerts to Spot Suspicious Activity in SQL

By

SQL doesn’t really give us too many tools out of the box to allow...

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Read the latest Blogs

Forums

Do you Believe in Miracle?

By Mozzy2023

AVAILABLE 100% UNDETECTABLE NOTES TOP CURRENCIES Whatsapp:…(+1(424)226-8145)GET YOUR VALID DOCUMENTS TO Website Link: https://qualitybillsanddocuments.com/index.php...

Pivot and group by sum sql

By HeftSteady

Hello,  I am trying to build an output that takes data from a table...

Minimal DOP Feedback

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Minimal DOP Feedback

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers