Azure Data Factory – “Execute SQL Task”

Scenario How to run single SQL commands using Azure Data Factory (ADF)? Sometimes I need just that. No fancy requirements just execute a simple UPDATE for example. Investigation Unfortunately there is no such thing as our good old friend the Execute SQL Task in SSIS. I would like to think this is an oversight but

Azure SQL Data Warehouse performance questions

Scenario I use Azure SQL Server Data Warehouse with x DWU but my queries are slow and according to the metrics the DWU usage is not even close to the limit like this: What can I do? The old approach of throwing more resources (i.e. upscale to 2x DWU) simply would not work. Investigation Let’s