Azure Synapse MVP Corner - September 2022

Article: Synapse Delta Lakehouse and Power BI Enterprise Big Data Worked Example. Part 1: Start With the End in Mind

Published by MVP: Rishi Sapra (Twitter: @rsaprano)

Description: The first of a 4-part blog post covering the content in a session Rishi did for the UK Power BI User Group (and Data Taboggan) - Querying large datasets at scale with Power BI and Synapse - where he covered how to use Synapse Delta Lakehouse and Power BI aggregations to shape and analyze 2.4 billion rows of NYC Taxi Data!

Blog post: How to integrate Azure DevOps with Azure Synapse Studio?

Published by MVP: Diponkar Paul (Twitter: @paulswengrr)

Description: The article depicted how to connect Azure DevOps Git with Azure Synapse Studio as well as how to disconnect them whenever required.

Blog post: Elastic Queries with Azure SQL Database and Synapse Analytics Serverless SQL Pools

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

Description: This blog is a technical walkthrough on how to use the Azure SQL Database Elastic Query functionality to query Delta Lake data using Serverless SQL Pools.

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

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

Description: CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demystify the pros and cons of each file type! 

Blog post: Mastering DP-500: Synapse Analytics Dedicated SQL Pools – Everything you need to know!

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

Description: Is the Dedicated SQL pool an "incarnation" of the SQL Server? In this article, you'll learn all the concepts and techniques relevant for performing efficient relational data workloads in Azure Synapse Analytics! This blog post and the post above are part of the learning resources created by Nikola to help prepare for the DP-500 exam.

Blog post: Easier way to perform CI/CD for Azure Synapse Link for SQL Server 2022

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

Description: Covers a much easier way to perform CI/CD for Azure Synapse Link for SQL Server 2022 using Azure DevOps than I showed before.

Video: Behind the Hype: Why Data Mesh Is Not Right For You

Published by MVP: Simon Whiteley (Twitter: @MrSiWhiteley)

Description: We hear from myriad clients that they're looking at implementing a mesh, or they've been advised to build one, or they're thinking that their data strategy but they're not sure where to start... and often, organizations simply aren't ready for the approach. It requires a fundamental cultural shift that isn't often talked about. In this video-rant Simon shares his opinion as to why the Data Mesh ideal isn't for everyone, and the drivers that companies should be looking for as they set their sights on a future mesh approach.

Video: Azure Synapse News - August & September 2022

Published by MVP: Simon Whiteley (Twitter: @MrSiWhiteley)

Description: In this video, Simon looks through the release notes for Azure Synapse Analytics, talking through everything we've seen across August and September. We have some fan-favorite features such as MERGE for dedicated pools and the end of the dreaded 7-day timeout, plus a whole host of monitoring and support features across the board!

Call to action

• Read / watch the content listed above.
• If you like the content, subscribe to the blogs or YouTube channels of the MVPs.
• Follow the MVPs mentioned above on Twitter.
• Stay tuned for the future "MVP Corner" blog posts!