Azure Synapse MVP Corner - October 2022
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
Published by MVP: Kevin Chant (Twitter: @kevchant)
Description: Covers a complete CI/CD experience for Azure Synapse Link for SQL Server 2022 tables, which uses a YAML Pipeline in Azure DevOps. Including how to automatically stop and start it in the pipeline.
Blog post: Dedicated SQL Pools DMVs: Show Name of Synapse Studio Script Being Executed
Published by MVP: Andy Cutler (Twitter: @MrAndyCutler)
Description: Within Dedicated SQL Pools are a set of Dynamic Management Views (DMVs) which show SQL activity, we can actually use these DMVs to see the name of a SQL script that was executed from Synapse Studio.
Blog post: Mastering DP-500: Score ML models in Synapse with PREDICT function!
Published by MVP: Nikola Ilic (Twitter: @DataMozart)
Description: Azure Synapse dedicated SQL pool provides you the capability to score machine learning models using the familiar T-SQL language. Using the PREDICT function you can bring your existing machine learning models trained with historical data and score them to enrich the data in your data warehouse.
Video: Locking Down Azure Synapse Analytics
Published by MVP: Kevin Feasel (Twitter: @feaselkl)
Description: This is a talk Kevin gave to the Triangle Area SQL Server Users Group on Tuesday, October 18th. Azure Synapse Analytics is a complex system, combining dedicated SQL pools, serverless SQL pools, Spark pools, and more. With such a broad scope, it can be difficult to understand what you need to secure and how you can lock it down. In this talk, Kevin first reviews the Azure Synapse Analytics surface area. Then, he introduces settings and procedures to protect data at rest, in transit, and during processing. Finally, he reviews several tools you can use to increase your security posture and reduce the risk of data exfiltration.
Video: Microsoft Ignite 2022 - Book of News Recap
Published by MVP: Simon Whiteley (Twitter: @MrSiWhiteley)
Description: Run through the data/analytics focused announcements made during Microsoft Ignite.
Video: Behind the Hype: Should you ever build a Data Vault in a Lakehouse?
Published by MVP: Simon Whiteley (Twitter: @MrSiWhiteley)
Description: Discussion on whether the data vault approach is suitable for a lake-based architecture - what are the drivers and detractors for this approach.
Blog post: Four different ways to incorporate Azure Synapse and Power BI
Published by MVP: Ginger Grant (Twitter: @desertislesql)
Description: Describe different methods of using Power BI and Azure Synapse, including browsing, source for dedicated pools, Data Lakehouse and serverless SQL databases. The post also includes a link to a recent video where Ginger discussed this topic for the DFW Power BI User Group.
Blog post: Connecting to Azure Storage from Synapse Analytics using Private Endpoint
Published by MVP: Adrian Chodkowski (Twitter: @Adrian_SQL)
Description: Security is a very important aspect of every cloud-based project. Synapse Analytics ecosystem allows us to configure many different options including networking and connectivity. In this article, Adrian demonstrates how to set up a private endpoint from Synapse Analytics to external Data Lake storage.
Video: Empowering Azure Synapse Analytics with Azure AD
Published by MVP: Heini Ilmarinen (Twitter: @HeiniIlmarinen)
Description: When working with Azure data services it is nearly impossible to ignore Azure AD. It is what we can use to secure Synapse Analytics as well as to powerfully manage access control within Synapse. To start making any sense of this, in this video Heini walks through the essentials of what you need to know about Azure AD, and how to make the most out of Azure AD when setting up Azure Synapse Analytics - both in terms of giving users the access they require, as well as allowing an external service to authenticate to Synapse using Azure AD.
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!
Published on:
Learn moreWe can help you with Azure Synapse MVP Corner - October 2022
If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.
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...
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 ...
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...
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.&...
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...
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 ...