SQL Azure – Dynamic Data Masking

SQL Azure – Dynamic Data Masking

Yesterday i covered what’s data masking and how can we implement in SQL Server 2016. Today I would like to continute the same topic in SQL Azure.
Yes folks Data masking is already live in SQL Azure!!!. If you are not tested it go through the article how to do it.

  • Login in to Azure Portal
  • Expand the menu and click on SQL databases

sql_azure_dynamic_data_masking_1

  • Now search for the database to which you are planning to enable dynamic masking.
sql_azure_dynamic_data_masking_2
  • Click on the database name. New tab will open with the database and it’s properties.
  • Make sure your database is upgraded to V12 or else you can’t use masking feature.

sql_azure_dynamic_data_masking_3

  • In the right hand side you can see the menu “Dynamic Data Masking”. Just click on that

sql_azure_dynamic_data_masking_4

  • You will be shown above tab once you clicked “Dynamic Data Masking”
  • The good part in Azure is that, based on the column names it will suggest you the column names for masking. It can be from any table.
  • In this page you can also set permissions to the users as who can see unmasked data.
  • If you are looking for the same columns then click on “Add Mask” button to enable data masking. You are done !!
  • Let’s say the column you are looking is not in the suggested list. No worries. In the above pic you can see a button called “Add Mask”, just click on that to select the column
sql_azure_dynamic_data_masking_5
  • Now select the table schema, then select the table name followed by the column name which you want to mask.
  • There is one more drop down menu which will allow you to select the masking function (like what we did in SQL Server 2016).
  • Again the good thing in Azure the function is categorized based on usage. You can select the function based on what data you store into the column.
  • Once you are done, just click save button. Boom, you are done masking the data!!
sql_azure_dynamic_data_masking_6
  • In the above pic now you can see the list of columns enabled for data masking.
  • Now lets say you need to drop the masking from the column. Again it’s pretty simple task.
  • Just click on the masked column from the list above, it will pop up a new tab as show below, just click on the delete button on top. Done!! 🙂 You dropped data masking.
sql_azure_dynamic_data_masking_7

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*


x

Related Posts

Provisioning Azure Cosmos DB using Powershell
Azure Cosmos database is one of the NoSQL database that is available in Microsoft Azure cloud platform. Azure Cosmos db is getting more popular c...
Query Editor - Azure Portal
An interesting new tool (in preview) added to Azure SQL database. Now Azure portal provides flexibility to query azure sql database from a browse...
Clear Procedure Cache in SQL Azure database
When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics...
powered by RelatedPosts