Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
4,826 reads
Azure Data Factory
Trigger the Execution of an ADF Pipeline from an Email
Learn how you can configure an Azure Data Factory pipeline that is triggered by an email being sent to an address.
2023-11-03 (first published: 2023-10-27)
4,499 reads
GIT Configuration and Automated Release for Azure Data Factory
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
2024-09-23 (first published: 2023-10-16)
2,524 reads
Sending Multiple Attachments in Email from Azure Data Factory Pipeline
This article shows how you can have your Azure Data Factory (ADF) pipeline send an email using a Logic App.
2023-09-29
3,325 reads
How to Implement CI/CD in Azure Data Factory (ADF)
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
13,301 reads
The Art of Data Ingestion - Part 1
Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]
2022-11-11
6,016 reads
Leveraging the Script Activity within Azure Data Factory
Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements.
2022-11-04
Assert Transformations in Azure Data Factory
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
4,037 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
4,401 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
18,875 reads
Blogs
New article: Automating SQL Server Builds
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
Leading with Accountability: How Extreme Ownership Transforms Leadership
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Unlock Your Notion Data with SQL
If your Notion workspace feels more like a data graveyard than a command center,...
Forums
What is Delayed Durability in SQL Server — And Should You Turn It On?
Comments posted to this topic are about the item What is Delayed Durability in...
Which MAXDOP?
Comments posted to this topic are about the item Which MAXDOP?
Data Sovereignty in the Cloud
Comments posted to this topic are about the item Data Sovereignty in the Cloud
Question of the Day
Which MAXDOP?
I have a SQL Server 2022 instance with this setting:
EXECUTE sp_configure 'max degree of parallelism', 4; GOI then run this:
SELECT ProductID, OrderQty, SUM(LineTotal) AS Total FROM Sales.SalesOrderDetail WHERE UnitPrice < $5.00 GROUP BY ProductID, OrderQty ORDER BY ProductID, OrderQty OPTION (MAXDOP 2); GOWhat is the maxdop for my query? See possible answers