May 24, 2017 at 11:26 pm
Comments posted to this topic are about the item Masking short domains
May 24, 2017 at 11:27 pm
Nice, easy question, thanks Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
May 25, 2017 at 7:07 am
Good question. I remember another question on emails and data masking a couple months ago but can't remember what it was.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 25, 2017 at 7:14 am
May 25, 2017 at 10:20 am
Sean Lange - Thursday, May 25, 2017 7:07 AMGood question. I remember another question on emails and data masking a couple months ago but can't remember what it was.
Yeah, so do I. I had to look it up then. And here my wife says I forget things - I remembered this. 😉
May 25, 2017 at 10:28 am
Ed Wagner - Thursday, May 25, 2017 10:20 AMSean Lange - Thursday, May 25, 2017 7:07 AMGood question. I remember another question on emails and data masking a couple months ago but can't remember what it was.Yeah, so do I. I had to look it up then. And here my wife says I forget things - I remembered this. 😉
I almost clicked on what was eventually the correct answer but then second guessed myself and looked it up again. I was surprised that I remembered it correctly. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 25, 2017 at 11:27 am
Sean Lange - Thursday, May 25, 2017 7:07 AMGood question. I remember another question on emails and data masking a couple months ago but can't remember what it was.
I remembered that question too and I think it was more about if the email was "user.name@company.org" would masking make it "uXXX.XXX@XXX.org" or "uXXX.XXX@XXX.com" or "uXXX@XXX.org" or "uXXX@XXX.com"... but I could be wrong on that.
I like the easy questions like this one. I take these questions and send them out to all the DBA's where I work and keep a tally of how many people get correct total and per year. I'm currently in 2nd place... out of the 3 of us LOL. BUT I only started doing this for the past 136 QOTDs. But it is nice to have a little friendly competition in the workplace.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 26, 2017 at 12:24 pm
bmg002 - Thursday, May 25, 2017 11:27 AMSean Lange - Thursday, May 25, 2017 7:07 AMGood question. I remember another question on emails and data masking a couple months ago but can't remember what it was.I remembered that question too and I think it was more about if the email was "user.name@company.org" would masking make it "uXXX.XXX@XXX.org" or "uXXX.XXX@XXX.com" or "uXXX@XXX.org" or "uXXX@XXX.com"... but I could be wrong on that.
<snip>
I remembered that it was not exactly intuitive and checked BoL. Thanks, Steve!
August 16, 2017 at 11:27 pm
Revenant - Friday, May 26, 2017 12:24 PMbmg002 - Thursday, May 25, 2017 11:27 AMSean Lange - Thursday, May 25, 2017 7:07 AMGood question. I remember another question on emails and data masking a couple months ago but can't remember what it was.I remembered that question too and I think it was more about if the email was "user.name@company.org" would masking make it "uXXX.XXX@XXX.org" or "uXXX.XXX@XXX.com" or "uXXX@XXX.org" or "uXXX@XXX.com"... but I could be wrong on that.
<snip>
I remembered that it was not exactly intuitive and checked BoL. Thanks, Steve!
I too had to check bol. I like the BOL definition that the domain will be a constant suffix of ".com"
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2017 at 9:15 pm
I tend to dislike the definition that it's always .com. Could be a problem in some cases. I'd like the option to leave the suffix, set it, or vary it.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply