Synapse Link for Dataverse: Video Series
Andy I've been diving into Synapse Link for Dataverse recently for a project and created a series of videos going through setting up Synapse Link with Dynamics 365 Sales and syncronising…
Azure Analysis Services Migration to Power BI Premium
Around November 2022, Microsoft announced a new feature within Power BI which allows you to migrate Tabular models from Azure Analysis Services into Power BI Premium. This interested me as…
Azure Synapse Link for Dataverse: Understanding Advanced Configuration Settings
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…