Azure Synapse MVP Corner - September 2022

[Guest pawelpotasinski]

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

 

 

 

 

 

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) -

- 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:

 

 

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:

 

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!
  

 

Continue reading...