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

(2)

You rated this post out of 5. Change rating

2021-09-17

20,519 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 […]

(2)

You rated this post out of 5. Change rating

2020-11-12

22,557 reads

Blogs

Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To

By

An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...

SQL Server Security Hardening Guide Using the DoD STIG Checklist

By

Security on your SQL Server is important. That doesn’t need any explaining. But where...

EightKB 2026: Registration is Open!

By

It’s that time of year again! EightKB is back on August 20th at 13:00...

Read the latest Blogs

Forums

Kontak BCA KCU KENDARI Telp:(08218154392)

By m4l4mt194

WA CS 08218154392 Jl. Jenderal M.t. Haryono No.95, Bende, Kec. Kadia, Kota Kendari, Sulawesi...

Backing Up a DMK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing Up a DMK

The Quiet Part

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Quiet Part

Visit the forum

Question of the Day

Backing Up a DMK

In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?

See possible answers