Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
2022-08-12
1,652 reads
Azure Data Factory
Understanding Shared Access Signature and Access Policy in Azure Storage
This article covers how you can give access with a shared key to Azure Storage Accounts and apply a policy for how users can access the files.
2022-06-15
1,250 reads
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
1,223 reads
The Script Activity in Azure Data Factory
Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.
2022-05-13
3,476 reads
Understanding the Mapping Data Flow Activity in Azure Data Factory
Learn about using Mapping Data Flows in Azure Data Factory.
2022-04-25
2,821 reads
An Introduction to Flowlets in Azure Data Factory
Learn how you can re-use parts of your pipeline in Azure Data Factory. Save off some tasks as a flowlet for use in multiple pipelines.
2022-04-15
2,646 reads
Understanding Azure Data Factory Pricing
Learn how Azure Data Factory charges you for use and how to estimate what your charges would be based on a few examples.
2022-04-04
6,290 reads
Prevent Accidental Resource Deletion Using Locks in Azure Data Factory
Learn how to protect production resources from accidental changes in Azure Data Factory.
2022-03-16
832 reads
Working with Fail Activity in Azure Data Factory
Introduction In this article, we will talk about a newly introduced activity in Azure Data Factory, which is the fail activity. The fail activity is very useful to stop or fail the pipeline at the specified point. For example, a lookup activity might return no data or a switch activity executes the default block. We […]
2022-01-24
2,253 reads
Choosing Between SQL Server Integration Services and Azure Data Factory
In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.
2022-01-21
Blogs
PGSQL Phriday #001: Two Truths and a Lie
As a part of my own journey of learning within PostgreSQL, I’ve decided that...
Daily Coping 7 Oct 2022
By Steve Jones
Today’s coping tip is to be willing to share how you feel and ask...
T-SQL Tuesday #155 –The Dynamic Code Invitation
By Steve Jones
Apologies for the late invitation. A minor snafu has me hosting again. This is...
Forums
How to display original part and recommende part with each other but must recome
I work on sql server 2019 i face issue on slow running when I...
Any reason to use AWS WAF over Cloudflare?
I'm primarily using Cloudflare for security. I was wondering if AWS WAF is any...
OP identification
In lengthy discussions and in developing trial and error scenarios I sometimes find it...
Ask SSC