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,688 reads
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,241 reads
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
2024-02-05
1,750 reads
See how to get started with Microsoft Fabric.
2023-08-21
4,445 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,846 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,081 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,023 reads
Learn how to connect your Synapse workspace to a Git repository.
2022-01-26
7,804 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,486 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,322 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward