Azure Synapse MVP Corner - February 2023
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
|
Dennes Torres (Twitter: @dennes)
Blog post: Synapse Serverless and Dedicated Pool: The differences no one told you about Description: There are many differences about drivers to access external sources and SQL syntax between Synapse Serverless and Dedicated Pool. In this blog, Dennes is highlighting some of these differences. 
|
|
Michał Smereczyński (Twitter: @smereczynski)
Blog post: Transaction cost and performance comparison per storage type in Azure Synapse Analytics Serverless Description: Transaction cost and performance comparison per storage type in Azure Synapse Analytics Serverless. 
|
|
Andy Cutler (Twitter: @MrAndyCutler)
Blog post: Partition Pruning with Delta Tables in Azure Synapse Analytics Description: In this blog post we’ll be looking at how Azure Synapse Analytics deals with partitioned Delta tables in Lake Databases & Serverless SQL Pools databases. We'll create Delta tables, run queries, and observe the results.
|
|
Andy Cutler (Twitter: @MrAndyCutler)
Video: Delta Tables in Azure Synapse Analytics - What's Going On? Description: We're looking at Delta tables in Azure Synapse Analytics in this video, specifically around partitioned Delta tables. We'll be looking at what happens when you create and query Delta partitioned tables in both Spark (Lake Databases) and Serverless SQL Pools databases. 
|
|
Andy Cutler (Twitter: @MrAndyCutler)
Video: Well-Architected Framework - Assessing Your Azure Synapse Analytics Readiness Description: The Azure Well-Architected Framework is a set of 5 pillars to help organizations optimize their Azure projects. But how do you link these 5 pillars with Azure Synapse Analytics? The Assessments area has a specific Synapse Analytics assessment. In this video we look at this assessment and the results. 
|
|
Kevin Chant (Twitter: @kevchant)
Blog post: Using Azure SQL Deploy v2 for dedicated SQL Pool deployments Description: Covers using Azure SQL Deploy v2 for dedicated SQL Pool deployments using GitHub Actions. Which is the GitHub Action that is also known as sql-action. 
|
|
Kevin Chant (Twitter: @kevchant)
Blog post: T-SQL Tuesday 159 - Azure Synapse Link and certifications Description: Kevin's T-SQL Tuesday contribution for February 2023, which covered Azure Synapse Link and certifications. 
|
|
Kevin Chant (Twitter: @kevchant)
Blog post: Deploying a dacpac to a serverless SQL pool Description: Cover deploying a dacpac to a serverless SQL pool using Azure DevOps. Yes, you are reading that right. It is now possible thanks to a SqlPackage update. 
|
|
Kevin Chant (Twitter: @kevchant)
Blog post: Homemade serverless SQL Pool Database Project Description: Shares how Kevin created a homemade serverless SQL Pool database project. Because he knows people are keen to work this way right now. 
|
|
Adrian Chodkowski (Twitter: @adrian_sql)
Blog post: Delta Lake 101 – Part 1: Introduction Description: Delta Lake is becoming increasingly popular. It is currently the default storage format used by the Spark engine. If not specified otherwise, it will be used by Synapse Analytics Spark Pools or Azure Databricks. Why has it become so popular? This is the first article in a series that will cover all of these topics. 
|
Call to action
- Read or 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 more "MVP Corner" blog posts!
Published on:
Learn moreRelated posts
Enhancing Azure Files resilience and performance
Azure Files provides the best-in-class fully managed file share solution in the cloud. We are excited to showcase several new capabilities, so...
Secure Access to Your Azure Virtual Machines for Free with Bastion Developer
As Microsoft Azure continues to evolve to accommodate its expanding user community, we are pleased to release a groundbreaking offering in res...
Faster server onboarding and disaster recovery with Azure File Sync (Public Preview)
We are excited to announce the public preview of faster server onboarding and disaster recovery. This will significantly accelerate customer o...
Log Analytics Cost Savings with Azure Advisor
Coding at the Speed of Innovation: AI and more with Azure SQL Database
The Azure SQL Database team is all set to unveil new product announcements as Build 2024 approaches. Innovation is the prominent theme this ti...
Generate insights from audio and video data using Speech analytics in Azure AI Studio
In this video, we explore the power of speech analytics in Azure AI Studio to extract insights from audio and video data. This technology help...
Azure Custom Policy- PostgreSQL Product - Compliance Report not Available- New Feature Request
If you're attempting to create custom policies for Azure Cosmos DB for PostgreSQL at the subscription level and are running into issues where ...
Microsoft Causes Fuss Around Azure MFA Announcement
Microsoft's recent announcement regarding the requirement of Azure MFA for connections to services starting in July 2024 has caused quite a st...
PostgreSQL for your AI app's backend | Azure Database for PostgreSQL Flexible Server
If you want to use Postgres as a managed service on Azure and build generative AI apps, then the Azure Database for Postgres Flexible Server i...