azure sql server vs synapse dedicated sql pool
Azure Synapse Dedicated SQL Pool Azure Synapse Dedicated SQL Pool (Previously Azure SQL Data Warehouse), a massively parallel processing database similar to other columnar-based scale-out database technologies such as Snowflake, Amazon Redshift, and Google BigQuery. To the end-user it is much like a traditional SQL Server, however, behind the scenes it distributes the storage and…
Azure Data factory linked service – system managed service identity error
Error: Cannot connect to SQL Database:’’, Database: ”, User: ”. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Login failed for user ‘<token-identified principal>’., SqlErrorNumber=18456,Class=14,State=1, Activity ID: As per the error message, Data factory managed identity doesn’t have access to the azure SQL…