Azure Synapse MVP Corner - December 2022

About this blog series

Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. To learn about the Microsoft MVP Award and to find MVPs visit the official website: https://mvp.microsoft.com/.

The Azure Synapse Analytics team presents you with a blog series "Azure Synapse MVP Corner" to highlight selected content created by MVPs.

This month's MVP content

Blog post: Real move on Data Lake using Rest API on ADF

Published by MVP: Bob Duffy (Twitter: @bob_duffy)

Description: This article describes how to use the data lake rest API to perform file move operations to avoid having to use ADF. This provides cost savings and much faster performance on large files when using ADF or synapse workspace to move files.

Blog post: Azure Synapse Analytics at SQLBit 2023

Published by MVP: Andy Cutler (Twitter: @MrAndyCutler)

Description: In this blog are all the SQLBits training day and general sessions that involve Synapse. There’s a variety of Synapse sessions from Dedicated SQL Pools, to Power BI and Synapse integration, Serverless SQL Pools, Data Architecture, and much more.

Blog post: Mastering DP-500 Exam: Configuring Synapse Analytics Source Control with Azure DevOps

Published by MVP: Andy Cutler (Twitter: @MrAndyCutler)

Description: In this blog part 1 of 2 on source control, we’ll look at how to integrate Azure Synapse Analytics into Azure DevOps Git. This forms part of the skill measured “Commit code and artefacts to a source control repository in Azure Synapse Analytics” for the DP500 Azure Enterprise Data Analyst certification.

Video: Every Azure Synapse Analytics Engineer Needs to Know this Essential Dataverse Feature - Synapse Link

Published by MVP: Andy Cutler (Twitter: @MrAndyCutler)

Description: In this Azure Synapse Analytics video we'll be looking at creating a Synapse Link for Dataverse between Dynamics 365 Sales and Azure Synapse Analytics to enable automatic data synchronisation. We'll then query this data using Serverless SQL Pools.

Article: Synapse Serverless SQL and file types – the ultimate guide!

Published by MVP: Nikola Ilic (Twitter: @DataMozart)

Description: The article should provide you with a better understanding of what is happening behind the scenes once you run the T-SQL query in Serverless SQL. It should also give you a hint about the difference in performance and costs, based on the file type you’re dealing with.

Blog post: Six-minute crash course about Synapse Studio

Published by MVP: Kevin Chant (Twitter: @kevchant)

Description: A six-minute crash course about Synapse Studio, the web UI of Azure Synapse Analytics.

Blog post: Data Factory objects in Synapse Studio

Published by MVP: Kevin Chant (Twitter: @kevchant)

Description: Covers where you can find Azure Data Factory objects in Synapse Studio.

Video: Viewing a list of Christmas presents from Azure Data Engineering services

Published by MVP: Kevin Chant (Twitter: @kevchant)

Description: In this short video Kevin shows how you can view the list of presents stored in the text-based files from Azure Databricks and Azure Synapse Analytics.

Blog post: Cleanup Synapse before deployment

Published by MVP: Joost van Rossum (Twitter: @ssisjoost)

Description: If you remove for example a trigger in development then it won't be removed in other environments by the deployment task. This could mess up your ETL/ELT process. This post shows how to empty your Synapse workspace before deployment to get rid of old components like pipelines, linked services and triggers.