Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creating the Synapse Workspace. In Level 2, we analyzed Data Lake files using the Serverless SQL Pool. In Level 3, we analyzed Data Lake files using the Spark Pool. In Levels 4 and level 5, I will discuss the Delta […]
2024-12-18
1,523 reads
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
2024-10-24 (first published: 2024-07-03)
862 reads
In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.
2024-10-24 (first published: 2024-08-14)
798 reads
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creation of the Synapse Workspace. In Level 2, data analysis was done on Data Lake files using Serverless SQL Pool. In Level 3, I will analyze data from the files uploaded in Data Lake container using a Spark Pool. I will […]
2024-10-24 (first published: 2024-09-18)
701 reads
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,414 reads
This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline.
2024-05-13
1,002 reads
Learn how to query data in Azure Data Explorer using Python.
2024-05-06
1,140 reads
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,178 reads
This article shows how you can have your Azure Data Factory (ADF) pipeline send an email using a Logic App.
2023-09-29
3,095 reads
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
2022-04-18 (first published: 2020-10-13)
15,897 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...
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
Comments posted to this topic are about the item The Table Backup
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers