I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]
2024-09-02 (first published: 2021-11-05)
3,987 reads
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,521 reads
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
2024-02-05
2,718 reads
See how to get started with Microsoft Fabric.
2023-08-21
6,506 reads
Get ready to be blown away! The highly anticipated Microsoft Build in May 2023 has finally unveiled its latest and greatest creation: the incredible Microsoft Fabric - an unparalleled Data Intelligence platform that is guaranteed to revolutionize the tech world! fig 1: OneLake for all Data One of the most exciting things in Fabric I […]
2023-07-26
5,180 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
13,301 reads
In 2019 Canadian Broadcasting Corporation (CBC) news reported a massive data breach at the Desjardins Group, which is a Canadian financial service cooperative and the largest federation of credit unions in North America. The report indicated, a "malicious" employee copied sensitive personal information collected by Desjardins from their data warehouse. The data breach compromised the […]
2022-03-30
3,127 reads
Learn how to connect your Synapse workspace to a Git repository.
2022-01-26
8,087 reads
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,266 reads
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,434 reads
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
If your Notion workspace feels more like a data graveyard than a command center,...
Looking to re-engage lost visitors and turn them into loyal customers? A powerful Retargeting...
The way the clothing of Kashmir echoes its culture has always interested me. The...
Comments posted to this topic are about the item What is Delayed Durability in...
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