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,874 reads
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,426 reads
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
2024-02-05
2,333 reads
See how to get started with Microsoft Fabric.
2023-08-21
5,439 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,039 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,809 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,094 reads
Learn how to connect your Synapse workspace to a Git repository.
2022-01-26
7,971 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,958 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,403 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
I'm using an ADO Net Source to extract data and running into an issue...
Hi I have below query and i want Cummulative Total . Total should be...
Everyone seems to be a Newbie with zero points today! Browser = Chrome
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers