Bug – Synapse SqlPool Language and dates

We found this interesting bug on Dedicated SQL Pool when working with British style language. If you use Dynamic SQL to change the language, then selects on the date fail with a conversion error, but prints work. Weird... An example repro is below DECLARE @sql nvarchar(4000) Declare @StartDate date=convert(date, getdate()) SET @sql = 'SET LANGUAGE … Continue reading Bug – Synapse SqlPool Language and dates

Enabling Managed Identity Authentication on Azure Functions in Data Factory

This blog shows you how to enable Managed Identity on an Azure Function call from ADF, this can help secure the Function by adding a second authentication method on top of the API Key. Enabling these options enforces https on all function calls, ADF handles authentication and so no custom headers, tokens or keys are … Continue reading Enabling Managed Identity Authentication on Azure Functions in Data Factory