Loading...

Azure Synapse MVP Corner - March 2023

Azure Synapse MVP Corner - March 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

 

pawelpotasinski_0-1683227161179.png

 

Kevin Chant (Twitter: @kevchant)

 

Blog post: Deploy a dacpac to a serverless SQL pool using GitHub Actions

Description: Covers how you can deploy a dacpac to a serverless SQL pool using GitHub Actions. Which is now possible thanks to a SqlPackage update.

 

pawelpotasinski_0-1683227732767.jpeg

 

 

pawelpotasinski_1-1683227174461.png

 

Kevin Chant (Twitter: @kevchant)

 

Video: Streamlining your CI/CD Pipeline with Azure Synapse Link for SQL Server 2022

Description: Covers a complete CI/CD experience for Azure Synapse Link for SQL Server 2022.

 

pawelpotasinski_1-1683227901002.png

 

 

pawelpotasinski_2-1683227263463.png

 

Andy Cutler (Twitter: @MrAndyCutler)

 

Blog post: Understanding ResultSet Caching in Dedicated SQL Pools with Power BI

Description: In this first blog in a new series of Power BI + Azure Synapse Analytics Andy is looking into Dedicated SQL Pools ResultSet Caching and how this feature can accelerate load performance into Power BI datasets.

 

 
 
pawelpotasinski_5-1683228024893.png

 

 

pawelpotasinski_3-1683227279547.png

 

Andy Cutler (Twitter: @MrAndyCutler)

 

Blog post: Azure Synapse Serverless SQL Pools Cheat Sheet

Description: Here is a Synapse Serverless SQL Pools Cheat Sheet to help you easily reference syntax to query CSV, Parquet, and Delta data in Azure Data Lake. It covers various scenarios when querying and includes creating Views, External Tables, and using system metadata to track Data Processed.

 

pawelpotasinski_6-1683228128938.png

 

 

 

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 more
Azure Synapse Analytics Blog articles
Azure Synapse Analytics Blog articles

Azure Synapse Analytics Blog articles

Share post:

Related posts

We're moving!

We’re moving to the Analytics on Azure Tech Community! All new Azure Synapse Analytics content will be published there. In the next few days a...

1 year ago

Upgrade to Azure Synapse runtimes for Apache Spark 3.4 & previous runtimes deprecation

It is important to stay ahead of the curve and keep services up to date. That's why we encourage all Azure Synapse customers with Apache ...

2 years ago

Interpreting Script activity output json with Azure Data Factory\Synapse analytics

Script activity in Azure Data Factory\ Synapse analytics is very helpful to run queries against data sources mentioned here in this document.&...

2 years ago

ADF\Synapse Analytics - Replace Columns names using Rule based mapping in Mapping data flows

In real time, the column names from source might not be uniform, some columns will have a space in it, some other columns will not. For exampl...

2 years ago

Synapse Connectivity Series Part #4 - Advanced network troubleshooting and network trace analysis

Continuing the series of this blog posts I would like to go more advanced on troubleshooting connectivity issues. I would like to thank also&n...

2 years ago

Boost your CICD automation for Synapse SQL Serverless by taking advantage of SSDT and SqlPackage CLI

Introduction   Azure Synapse Analytics Serverless SQL is a query service mostly used over the data in your data lake, for data discovery,...

2 years ago

Metadata-Based Ingestion in Synapse with Delta Lake

  Overview     The crucial first step in any ETL (extract, transform, load) process or data engineering program is ingestion, w...

3 years ago

Missing Fields Added to Dedicated SQL pool Diagnostic Settings Logs

Over the past year, customers have informed the team there were a set of key columns missing in the standalone Dedicated SQL pools (formerly S...

3 years ago

Using Azure DevOps with Synapse Workspaces to create hot fixes in production environments

Have you ever deployed a release to production only to find out a bug has escaped your testing process and now users are being severely impact...

3 years ago

CI & CD With Azure Synapse Dedicated SQL Pool

Author(s): Pradeep Srikakolapu is a Program Manager in Azure Synapse Customer Success Engineering (CSE) team.    Automating de...

3 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy