Lake Databases And The Importance of Data Types
Andy I encountered an issue with Azure Synapse Analytics Lake Databases and I'd like to share the problem and the solution. This really should be filed under "the solution was obvious!…
Mastering DP-500 Exam: Using the Data Map in Microsoft Purview
Part of the upcoming Azure Enterprise Data Analyst Associate exam, the DP-500, is to understand how to identify data sources in Azure using Microsoft Purview. In this blog post we'll…
Mastering DP-500 Exam: Integrating Microsoft Purview with Power BI
Part of the upcoming Azure Enterprise Data Analyst Associate exam, the DP-500, is to understand how Microsoft Purview integrates with Power BI to manage assets. In this blog post we'll…
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 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…