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
Category: Uncategorized
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