A Fine Slice Of SQL Server
Victoria Holt summarizes some Microsoft Purview updates:
Yesterday a lot of changes were announced for Microsoft Purview at the Microsoft security event securing your data with a multilayered defense. Microsoft Purview is about managing data security risks across hybrid multi-cloud data estates that have a defense in depth strategy to mitigate risk. The recording can be watched at this link.
Read on for a summary of what went down.
Comments closedWolfgang Strasser has been on the Purview beat:
A lot happened in the Microsoft Data Governance area, especially in the area of Microsoft Purview Data Governance.
Let’s go back in history and wrap up the announcements that have been made in Microsoft (Azure) Purview area. My main source for this summary is the Security, Compliance and Identity Blog.
Wolfgang has the set of changes as a bulleted list for easy digestion.
Comments closedLike all services in Azure, there’s associated costs when using the service, and naturally Microsoft Purview is no different. If interested in reading the standard pricing model for Microsoft Purview it has been outlined here – and follows a similar layout to all Azure price models.
However – as a result of such a broad range of capabilities, its pricing model is one of the more difficult to understand!
Read on for a PDF which hits the various charges you’ll see.
Comments closedSrdan Bozovic links Purview and SQL Server 2022:
The focus of this article is on using Microsoft Purview to enable access to user data as well as specific system metadata in SQL Server 2022 running on Azure Arc–enabled servers.
With the SQL Server 2022 release, the goal is to enable three main scenarios:
– Browsing data in user-defined tables and views.
– Performance monitoring with system commands, functions, and views.
– Security auditing with security-related system functions and views.
If Azure Arc-enabled servers are required for Purview to work, I think that will seriously hinder uptake.
Comments closedWolfgang Strasser looks at Microsoft Purview:
I was ready for a nice relaxing evening today, when an email appeared in my inbox “Azure Purview is now Microsoft Purview!”
Initially I thought… yeah.. “just another Microsoft product name renaming” .. but when I read through it more in depth I found out, that this is NOT just a renaming.
Read on to understand what it includes.
Comments closedVictoria Holt makes note of an improvement to Purview:
Azure Purview Workflows moved to Public Preview 10 March. This functionality enables customers to orchestrate the create, update and delete operations of data entities, have validation, and approval of these data entities using repeatable business processes.
The benefit of using Purview workflows is higher quality data, policy compliance, user collaboration, and change tracking awareness across the organization.
Read on for more information about how workflows currently work.
Comments closedWolfgang Strasser looks at some of the new Azure Purview announcements:
For me, Data lineage is one of those fascinating techniques to better understand your data estate and get a better knowledge how systems are connected and what data flows are there in your data landscape.
Lineage was there in Azure Purview since the beginning (Azure Data Factory, SSIS lineage, Power BI) but this week another very important part of data lineage was put into public preview: Dynamic Lineage Extraction from Azure SQL Databases.
Read on for more information.
Comments closedWolfgang Strasser sees a new role:
I’ve spotted a new Azure Purview permission level – Policy Authors. This new permission level is connected to the new Data Access Policy Management in Purview (as of today 2021-12-30 in preview; https://docs.microsoft.com/en-us/azure/purview/how-to-access-policies-storage)
Click through for a little bit more detail.
Comments closedWolfgang Strasser has a future review of past activities:
Yesterday, Andy Cutler (t) asked me on twitter, if the move of a registered source between collections is possible.
My first answer was, yes sure… And I also included a screenshot from one of my Purview accounts (which – this will be important in the following – is a legacy Purview account).
But – tech isn’t tech without some differentiation between versions and available options
Read the whole thing.
Comments closedAngela Henry wraps up a series:
Welcome to the final installment of our Azure Purview Series, focusing on Purview Data Map. The Purview Data Map is the foundation for data discovery and serves as the jumping-off point for all things data source related. It is the cloud-native platform-as-a-service (PaaS) that collects the metadata about your data sources and runs the scans to keep your metadata up to date.
Click through to see what’s available in Data Map and information on how to kick off and view scans.
Comments closed