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…
Future Data Driven 2023 – Fabric SQL
Session Abstract It all started with Parallel Data Warehouse, then came Azure SQL Data Warehouse…then Dedicated SQL Pools in Synapse! That was joined by Serverless SQL Pools in Synapse too.…
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,…
Synapse Link for Dataverse with Azure Synapse Analytics eBook
If you're interested in using Synapse Link for Dataverse with a Dynamics 365 environment to export data for analysis in Azure Synapse Analytics, then this latest version of the eBook…
Transactions and Isolation Levels in Fabric Warehouse
I trust everyone has been having fun with Fabric over the last few weeks, diving into various workload types like data engineering, data warehousing, data science, real-time streaming, all that…
Temp Tables in Fabric Lakehouse SQL Endpoint and Warehouse
This blog has been adapted from an earlier blog about using temp tables in Synapse Serverless SQL Pools. As the Fabric SQL engine is built from the Serverless SQL Pools…
Play Around: Deploy Database Projects to Fabric Warehouse
I always like to have a dig around, try a few things and see if something works (most likely unsupported!) and I've been interested to see if I could get…
Fabric in Production
This is a placeholder blog which will be revisted many, many times over the coming months. This is a list of features for Fabric that I feel need to be…
Getting Started with Microsoft Fabric: Enabling 60-Day Trial and Analysing Data
There's been an exciting new announcement at Microsoft Build in the form of Microsoft Fabric, a unified platform that brings together Data Engineering, Data Warehousing, Data Science, Real-time analytics, and…
Synapse Link for Dataverse: Delta Lake Export Configuration
Welcome to part 2 in the Synapse Link for Dataverse Delta Lake series. In the recently released functionality in Synapse Link for Dataverse to export to Delta Lake format, this…