Mastering DP-500 Exam: Querying Partitioned Sources in Azure Storage
This blog forms part of the Mastering DP-500 exam series. A list of available blogs is here and is in...
Andy
Mastering DP-500 Exam: Using Synapse Analytics Serverless SQL Pools to query Azure Storage
This blog forms part of the Mastering DP-500 exam series. A list of available blogs is here and is in...
Mastering DP-500 Exam: Blog Resources
I am collaborating with Data Mozart on blogging around the upcoming Microsoft Certified: Azure Enterprise Data Analyst Associate certification. Please...
New Certification: Microsoft Certified Azure Enterprise Data Analyst Associate
Microsoft has created a new certification, the Microsoft Certified Azure Enterprise Data Analyst Associate (link here). There is a single...
How does Serverless SQL Pools deal with different file schemas? Part 1 – CSV
Serverless SQL Pools offers a straight-forward method of querying data including CSV, JSON, and Parquet format stored in Azure Storage....
Integrating Power BI & Azure Synapse Analytics – Power BI UK User Group
Here is the link to the slides for the Power BI UK User Group session on Thursday 17th March, 2022...
SQLBits 2022 – The Dream Team: Synapse Analytics Serverless SQL Pools and Pipelines
I presented a 20 minute session at SQLBits 2022 in which I talked about how useful Synapse Pipelines can be...
Trigger The Process – Using CETAS in Serverless SQL Pools to Generate Pre-Calculated Datasets – Part 2 of 2
In part one we looked at a process in which a pre-aggregated dataset can be created by Azure Synapse Analytics...
Using CETAS in Serverless SQL Pools to Generate Pre-Calculated Datasets – Part 1 of 2
Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is...
DataMinutes #2 Session Companion for Turbocharging Power BI using Synapse Analytics
The slides for the DataMinutes #2 session Turbocharging Power BI using Synapse Analytics is available here to download. GitHub Code...
