Mastering DP-500 Exam: Querying Partitioned Sources in Azure Storage
Andy This blog forms part of the Mastering DP-500 exam series. A list of available blogs is here and is in association with Data Mozart. Learning Focus The learning focus for…
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 association with Data Mozart. Learning Focus The learning focus for…
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 find more information about this certification here. The list of…
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 exam with a pass rate of 70%: Exam DP-500: Designing…
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. A common pattern is to move data from source systems…
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 here. The video recording should be available soon.
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 when working with Serverless SQL Pools. The session included a…
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 Serverless SQL Pools and saved to an Azure Data Lake…
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 automatically updated as new data is added to its source…
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 The Serverless SQL Pools code to generate the pre-computed datasets…