Forum Discussion
Is Static Data Masking still a thing?
I'm reaching out to see if static data masking is still an option within Microsoft SQL Server /SQL Server Management Studio. I am aware that dynamic data masking (DDM) is available. I have found 2 Microsoft links that mention static data masking. The first appears to only apply to Azure and the second link is dead. I was wondering if static data masking has been deprecated for both on-prem and Azure and DDM is the only option, or is static data masking available in some other way (plugin or extension)?
Link 1:
https://azure.microsoft.com/en-us/blog/static-data-masking-preview/
Link 2:
https://docs.microsoft.com/en-us/sql/relational-databases/security/static-data-masking?view=sql-server-2017
Static Data Masking was in preview in SSMS 18, but removed before GA. It’s not something that is on the roadmap at this time.
5 Replies
- Hi,
There is a work around to implement static data masking: https://sqlserverwarrior.wordpress.com/2021/09/14/mask-sql-server-sensitive-columns-for-secure-backup-share-static-data-masking%ef%bf%bc/
Regards - erinstellato
Microsoft
Static Data Masking was in preview in SSMS 18, but removed before GA. It’s not something that is on the roadmap at this time.
- Just to confirm, Static Data Masking was in preview in SSMS 18, but removed before GA. It’s not something that is on the roadmap at this time? Not Dynamic?
- erinstellatoApologies, I was typing too fast. I fixed my original post so it is correct. Yes, talking about STATIC Data Masking.
