Post reply

Data Masking

  • March 4, 2010 at 1:53 pm

    #219635

    Hi all,

    In my new company we are handling banking data. My management recommend to learn Data masking.

    I can understand little bit but not exactly.

    Anyone tell me,

    1. what is the purpose to do data masking?

    2.For what we have to go for that?

    3.If its good means how its working?

    4.Any dynamic logic for data masking?

    5.what r the requirement for data masking?

  • March 4, 2010 at 2:12 pm

    #1128772

    Data masking is a general term. More than one way exists to accomplish this, but if you are just concerned about how to store the data in the database in "masked" form, then you can store the data in a varbinary field and use combinations of the following:

    encryptbykey

    decryptbykey

    Where the key(s) are encrypted by certificates. You can study this in BOL by searching on encryption. The term it uses is "cell level encryption." You can also go here

    http://msdn.microsoft.com/en-us/library/cc278098.aspx

    for a comparison between cell level encryption and transparent data encryption.

    Regards,

    Toby

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply