Opened 20 months ago

#619 new defect

SQL training in pune

Reported by: anonymous Owned by: somebody
Priority: major Milestone:
Component: component1 Version:
Keywords: Cc:


SQL classes in pune
SQL training in pune

This put up is going to be constrained to solely SQL Server Table Columns and solely Extended Properties named MS_Description. Quite a few years in the past I labored on a records catalog challenge the place we brought descriptions for many of the tables, views, and columns to the database the usage of prolonged homes named MS_Description. Let’s count on you have some of these for this put up preserving in idea that the Purview APIs grant so many features past what this put up covers and that the code right here may want to be modified to do so a lot greater as well.

Starting out I thinking it would be incredible to import the sensitivity classifications that SSMS creates. Pre-SQL 2019 these have been held in Extended Properties and now have their very personal DMV (sys.sensitivity_classifications). While this sounded extremely good in principle it wasn’t as thrilling when I wrote the code. This is due to the fact Azure Purview already has machine classifications at a greater granular scale for every of the ones you discover in SSMS and Purview additionally provides these as it executes a scan on the records source. It does a rather accurate job too. With that said, I shifted my center of attention to including descriptions instead.

Attachments (0)

Change History (0)

Modify Ticket

Change Properties
Set your email in Preferences
as new The owner will remain somebody.
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from somebody to the specified user. Next status will be 'assigned'.
The owner will be changed from somebody to anonymous. Next status will be 'accepted'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.