The Email Mask

Question

Post reply

The Email Mask

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
March 19, 2016 at 3:24 pm

#100923

Comments posted to this topic are about the item The Email Mask
March 21, 2016 at 11:14 pm

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

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

michal.lisinski SSCertifiable Points: 7201 More actions · Answer 1

Hi

Quite simple, not a lot to think about here.

This dynamic data masking function returns first character as it is and rest is replaced.

Regards

Mike

George Vobr SSChampion Points: 10009 More actions · Answer 2

Thanks Steve, that you teach us by small steps to learn about the Dynamic Data Masking. On 03/08/2016 it was about masking data type varchar. There was a reference to the DDM, where everyone could find the answer also to today's question. It is therefore surprising so a high proportion of incorrect answers.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I haven't used it yet. Then again, this is for SQL 2016, so we should get around to it by about 2020. 😛

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Pablo Echeverria Right there with Babe Points: 750 More actions · Answer 4

What is the purpose of returning 3 X, then @, then 4 X? Why not 2 X, then @, then 3 X?

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 5

pabechevb (3/22/2016)
What is the purpose of returning 3 X, then @, then 4 X? Why not 2 X, then @, then 3 X?

No purpose. Just a design decision by MS.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

akljfhnlaflkj

SSC Guru

Points: 76202

March 24, 2016 at 6:40 am

#1867388

Thanks for the question.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 7

Thanks for this interesting question related to SQL Server 2016. As I am curious , I have looked at the SQL Server 2016 CTP2 documentation and I discovered a nice function. I got point only because I have read the page for 20 minutes...:Whistling:

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP