Dynamic Data Masking Feature in SQL Server 2016

  • pankaj.chakole

    SSC Enthusiast

    Points: 121

    Comments posted to this topic are about the item Dynamic Data Masking Feature in SQL Server 2016

    Pankaj Chakole
    Database Administrator
    Email # pankaj.chakole@gmail.com

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    It does appear to have a singular purpose and does it well.

  • MMartin1

    One Orange Chip

    Points: 27502

    A step forward indeed to simplify operations in a business that protects personal data.

    Another great feature to have would be the ability to generate fake records by substituting column values to protect the real value. The date of birth is a good example. In my testing environment I may be creating joins and want to verify the DOB for person with ID 123 (in my query results) is 'blah' by referencing the base person table (should have 'blah' as well, though not the real value).

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

  • zkim143

    SSC Veteran

    Points: 217

    Free Microsoft Sample questions are available on Passin1day. You can prepare your Microsoft Exams with the help of our Questions and answers. Our questions are 100% valid and accurate for all students around the world. Here you can also prepare your all Microsoft exams with the help of our study material. Here also find latest all Microsoft certification exams study guide. Our experts are always here for your help. Feel free to ask any question about Microsoft.

  • pankaj.chakole

    SSC Enthusiast

    Points: 121

    DDM fuctions are not masking or modifying the orginal data so i dont think so it will allow you to retrive data by putting blah in where clause

    Pankaj Chakole
    Database Administrator
    Email # pankaj.chakole@gmail.com

  • MMartin1

    One Orange Chip

    Points: 27502

    pankaj.chakole (1/9/2017)


    DDM fuctions are not masking or modifying the orginal data so i dont think so it will allow you to retrive data by putting blah in where clause

    Not sure what you are referencing exactly. My comment scope is a hypothetical situation where a feature (presumably not in existence) would be in place, along with its end results when put to use.

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

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

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