Iteration and Conditional Activities in Azure Data Factory
Learn about the different iterator activities in Azure Data Factory.
2024-08-23 (first published: 2021-10-22)
9,281 reads
Arindam
- Skills: SQL,Azure
- LinkedIn: https://www.linkedin.com/in/arindamxs/
An Introduction to Flowlets in Azure Data Factory
Learn how you can re-use parts of your pipeline in Azure Data Factory. Save off some tasks as a flowlet for use in multiple pipelines.
2024-02-19 (first published: 2022-04-15)
7,564 reads
Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
5,274 reads
Create Your First Pipeline in Microsoft Fabric
Learn how to get started with a Microsoft Fabric pipeline.
2023-08-02
4,559 reads
Analyze Data with a Serverless SQL pool in Azure Synapse Analytics
Learn how to query data stored in text files from Azure Synapse Analytics using the Serverless pool that is included with each workspace.
2023-06-07
1,468 reads
Understanding Azure Synapse Analytics Pricing
Learn about the different parts of Azure Synapse Analytics and what it costs for each of these areas.
2023-03-03
13,878 reads
Assert Transformations in Azure Data Factory
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
4,265 reads
Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
2022-08-12
17,153 reads
Monitoring Azure Blob Storage
Learn about how you can monitor your Azure Storage account and set alerts to let you know when to take action.
2022-07-08
2,884 reads
Understanding Shared Access Signature and Access Policy in Azure Storage
This article covers how you can give access with a shared key to Azure Storage Accounts and apply a policy for how users can access the files.
2022-06-15
8,702 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers