This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
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
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.
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.
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.
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.
Description: Run through the data/analytics focused announcements made during Microsoft Ignite.
Description: Discussion on whether the data vault approach is suitable for a lake-based architecture - what are the drivers and detractors for this approach.
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.
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.
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!