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,750 reads
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,309 reads
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
2024-02-05
1,995 reads
See how to get started with Microsoft Fabric.
2023-08-21
4,755 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
4,904 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,321 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,039 reads
Learn how to connect your Synapse workspace to a Git repository.
2022-01-26
7,862 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
19,671 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,353 reads
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
Hi, Need your help. I've a SP that is using Update statement on a...
I have query which is filling TEMPDB I need suggestion how to modify this...
I have query which is filling TEMPDB I need suggestion how to modify this...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers