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
|
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.
|
|
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.
|
|
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.
|
|
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.
|
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
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...
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 ...
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.&...
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...
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...
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,...
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...
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...
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...
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...