Azure Synapse Link for Dataverse: Understanding Advanced Configuration Settings
Andy In the first part of this blog series we looked at how to configure Synapse Link for Dataverse with Dynamics 365 Sales data and synchronise this data with an Azure…
Azure Synapse Analytics in 2022: Retrospective
Retrospective Another year has rolled by (where does the time go...) and another year in the life of Azure Synapse Analytics. I've mostly spent time blogging and talking about Synapse…
Azure Synapse Analytics at SQLBit 2023
The General Session agenda for SQLBits 2023 is now available here and covers the agenda on Thursday, Friday, and Saturday. SQLBits 2023 is running from Tuesday March 14th until Saturday…
Mastering DP-500 Exam: Configuring Synapse Analytics Source Control with Azure DevOps
This blog forms part of the DP-500 blog series on this site here and also from Data Mozart's blog here. Summary Part of the DP-500: Designing and Implementing Enterprise-Scale Analytics…
Databricks Data Engineer Associate Certification Overview
I've been looking at taking the Databricks Data Engineer Associate Certification (the Databricks page for the certification is here) as I've noted the certification covers areas such as the overall…
Azure Synapse Link for Dataverse: Getting Started with Dynamics 365 Sales and Synapse Analytics
Part of the Azure Synapse Analytics suite of services is Synapse Link. This enables synchronization of data from sources including Cosmos DB, SQL Server, Azure SQL Database, and the Dataverse…
Connecting Power BI to Azure SQL Database using Private Endpoints
This was originally posted on my Datahai company blog in November 2021. This blog has now been updated as of November 2022 as certain steps have changed, notably the movement…
Mastering DP-500 Exam: Querying JSON Data in Serverless SQL Pools
This blog forms part of the DP-500 blog series on this site here and also from Data Mozart's blog here. Summary Part of the DP-500: Designing and Implementing Enterprise-Scale Analytics…
Dedicated SQL Pools DMVs: Show Name of Synapse Studio Script Being Executed
I'm currently in the process of building a Query and Workload Analyser Power BI report which queries several DMVs (Dynamic Management Views) in Synapse Dedicated SQL Pools. One of the…
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…