What is Azure Synapse Analytics with Mark Pryce-Maher

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.