Azure Synapse Analytics Custom Roles
Andy Recently I had a challenge in terms of providing a least permissions possible security model for a Data Engineer persona when working with Synapse Analytics. I won't go into detail…
Azure Synapse Analytics Managed Virtual Networks for the Developer
It's recommended in a Synapse environment, especially a production/live environment, to lock a Synapse Analytics workspace down behind a Virtual Network (VNet). Synapse itself cannot be connected to any VNet,…
User Permissions in Serverless SQL Pools: External Tables vs Views
In a recent Synapse Analytics Serverless SQL Pools QnA session, the Serverless SQL Pools team stated that using External Tables rather than Views was preferred if you wanted to restrict…