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....
Andy
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....
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...
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...
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...
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....
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...
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...
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,...
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...
