Azure Synapse Analytics at SQLBit 2023
Andy 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…
Up and Running: How to make your Azure Synapse Analytics Proof of Concept a Success (Data Relay Session)
Firstly, I'd like to say a huge thank you to the Data Relay team, the helpers, the sponsors, the attendees, the venues, venue staff, and speakers for making Data Relay…
Elastic Queries with Azure SQL Database and Synapse Analytics Serverless SQL Pools
Recently I have been exploring an option to use an Azure SQL Database for a small footprint Data Warehouse and wondered whether I could create an elastic query connection to…