In this episode of Kasper On BI we are talking about Synapse Analytics. What is it? How does it work? When can you use it? What are some common issues and how does it relate to Power BI?
The expert on today’s episode is Mark Pryce-Maher. Mark Pryce-Maher is a Senior Program Manager on the Azure Synapse Analytics Customer Success Engineering team at Microsoft, where he is working with customers implementing Enterprise Data Platforms.
This episode is also available as video on YouTube: https://youtu.be/ZAQkPfU9AAo
Links mentioned in the episode:
Twitter : http://twitter.com/markpm_msft
Blog: https://geeksonscreens.azurewebsites.net/
His Github: https://github.com/markprycemaher/Synapse/tree/master/presentations/presentation_aG
Gists: https://gist.github.com/MarkPryceMaherMSFT
Azure Synapse Overview:
https://docs.microsoft.com/en-gb/azure/synapse-analytics/
New Feature: Distribution Advisor
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/distribution-advisor?source=docs
Multi-Column Distribution
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse?view=aps-pdw-2016-au7#TableDistributionOptions
Dedicate SQL Pool Best Practices Best practices for dedicated SQL pools: Best practices for dedicated SQL pools – Azure Synapse Analytics | Microsoft Docs
Synapse Toolbox: Great Repository for Synapse scripts.
https://github.com/microsoft/Azure_Synapse_Toolbox
Synapse Certification
https://docs.microsoft.com/en-gb/certifications/azure-database-administrator-associate/
https://docs.microsoft.com/en-gb/certifications/azure-enterprise-data-analyst-associate/
Guy in a Cube : Getting started with Synapse
https://youtu.be/tWFAxOI7CF0