A Fine Slice Of SQL Server
Wolfgang Strasser wants to try Microsoft Purview but doesn’t want to break the bank:
And my reaction was – Nice, very nice.. I can try and create Microsoft Purview instances for free and test new features..
BUT: I wanted to be sure and check, how much metadata (sources, scan results, data assets, classifications) can fit into 1 MB of metadata.
Read on for Wolfgang’s test, as well as the full set of costs around trying out Purview.
Leave a CommentAlex Crampton writes some Python code:
The aim of this blog is to explain how to create custom Purview processes, enabling you to add lineage from processes that are not tracked out of the box.
As covered in this blog, Azure Purview can help with understanding the lineage of your data, offering visibility of how and where data is moving within your data estate.
Lineage can only be tracked out of the box when using tools such as Data Factory, Power BI, and Azure Data Share. Lineage is lost when using other tools like Azure Functions, Databricks notebooks, or SQL stored procedures.
Read on to see the code, as well as what you can do.
Comments closedVictoria 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 closed