Ingest and Retrieve data from an ADX Cluster Using Python
Learn how to query data in Azure Data Explorer using Python.
2024-05-06
525 reads
Sucharita Das
Trigger the Execution of an ADF Pipeline from an Email
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)
2,683 reads
GIT Configuration and Automated Release for Azure Data Factory
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
2023-10-16
1,860 reads
Sending Multiple Attachments in Email from Azure Data Factory Pipeline
This article shows how you can have your Azure Data Factory (ADF) pipeline send an email using a Logic App.
2023-09-29
2,049 reads
Incremental Data loading through ADF using Change Tracking
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
2022-04-18 (first published: 2020-10-13)
15,298 reads
2021-11-08
4,875 reads
Incremental Data Loading Using ADF and Change Tracking
This article looks at moving data in three related tables to Azure SQL Database using the change tracking feature in SQL Server to determine which rows have been changed.
2021-10-04
7,168 reads
Sending streaming data from Azure IoT Central to Azure SQL Database
Introduction In my last article, Working with Azure IoT Central at SQLServerCentral, I gave an overview of Azure IoT Central. I had connected my mobile phone as a device to Azure IoT Central and collected the telemetry data. In this article, I will export the telemetry data continuously from Azure IoT Central to Azure SQL […]
2021-08-23
3,529 reads
Working with Azure IoT Central
Gathering data from sensors and Internet of Things (IoT) devices is becoming more and more common in many organizations. This introductory article shows how you can get started with IoT Central in Azure.
2021-08-02
1,742 reads
An Introduction to Power BI
Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be shared with others, as required. Data may be connected from different sources including files, databases, Azure services, […]
2021-07-12
8,201 reads
Blogs
Redgate Summit Comes to the Windy City
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
Non-Functional Requirements
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
Techorama 2024 – Slides
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Forums
AG listener cant be removed
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Remove comma inside Comma Delimited File csv in SSIS Using Script task
Hi, I have two tables: one for headers with 9 fields and another for...
Inserting 100K rows Performance - Baseline Performance
We're trying to understand how quick new versions of SQL server can be. Obviously...
Question of the Day
The "ORDER BY" clause behavior
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers