Azure Purview, which recently became generally available, allows governance of on-premises SQL server farms at scale, and with ease. This blog details how to register and scan a SQL server. It also describes how to restrict access and discover assets easily by grouping SQL servers into Purview collections. Using Purview, users can also gain further insights into their entire hybrid data estate.
Register and scan SQL Server
Navigate to a Purview account and click on the Data Map section to the left. Users can view their data estate maps and choose to view sources in table format as well.