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

Leap Year issue with MDX date navigation

A few days ago (exactly one day after 29th of February when testing data from last night’s load) I experienced a strange issue which I couldn’t explain at first but then found out that it is related to the leap year and to the fact that even though this year has a 29th in Feb

Default Member inconsistency

Issue Example is based on Adventure Works – SQL 2012 The user would like to browse the cube mainly for data related to the Accessories products so the default member of that attribute is set to: [Product].[Category].&[4] You have to make that modification in Adventure Works in order to test this behaviour! But as the