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…
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…
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…
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.
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…
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…
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…
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…
SQLBits is back this year and is running from Tuesday 8th to Sunday 12th March at the ExCel in London. Register for the event and see the schedule here. I'm…
The next DataMinutes conference (#2) is taking place on Friday 21st January. What's different about DataMinutes is that it is a fast-paced lightning session conference, all sessions are short at…
Andy