Loading...

Azure Synapse MVP Corner - October 2022

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 more
Need help with this product?

We 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.

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

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

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

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

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

3 years ago

Newsletter

Get the latest Dynamics 365 and Power Platform content in your inbox

A curated digest of community blogs, product news, videos, and podcasts — delivered without the noise.

Weekly updates Unsubscribe anytime Fresh community picks
We use your email only for the newsletter and you can unsubscribe at any time.
By subscribing, you agree to the privacy policy.