Data Masker V-Next- Help us get more users!

• 
  I'm happy to help. We don't currently have a project planned at my office, but It could certainly spark some interesting conversations plus I certainly have room to do so some research with some of our datasets in test/dev.

  BrandonLeach September 06, 2018 22:52

  - 0 +
• 
  @BeckyE, Let me know if you still need assistance.  We have been using Data Masker for a few months but not hitting it very hard yet.  I'd like to help if I can.

  adam_hafner September 30, 2018 23:23

  - 0 +
• 
  Hi @BeckyE, send me some details please. Although we do not use this product in a company I'm working for now, but I'd like to prepare a post blog about it and spread the words among my friends.

  KamilN October 02, 2018 23:03

  - 0 +
• 
  @KamilN thank you, that would be brilliant! Becky is on holiday at the moment, but I will pass your message on so she can get back to you upon her return.

  Roseanna October 08, 2018 14:57

  - 0 +
• 
  I just had my first experience with Data Masker, and I have some significant suggestions. I would LOVE to have a chat with the people leading the charge on the next edition!! Please have them reach out to me if they are interested. I hope I am not too late for the V-Next release, but better late than never.
  
  1) Wildcards or multiple schemas on initial grab of tables?
  
  2) I am rather jet-lagged (just arrived in Europe yesterday), but the interface didn't feel intuitive to me at all. I don't yet have specific suggestions because I am rushing through to complete what is needed so I can move on to other things.
  
  3) It looks like you are doing RBAR individual updates, apparently without even a BEGIN TRAN/COMMIT TRAN wrapped around some number of those. That is a CRUSHINGLY-BAD thing to do to SQL Server, especially from an IO write perspective. 
  
  4) You are updating the same table N times each, where N is the number of columns that have some operation on them. So you can immediately reduce transactions by N-1/N by updating all columns for each row just once. I note this may not be possible if "don't do NULL fields" is a thing, but you can possibly know about if still valid a few different ways.
  
  5) Everything seems to be serial. Multi-threaded operations would seem an obvious need. 
  
  6) Is there an option to make the database SIMPLE recovery mode to avoid tlog bloat? 
  
  7) Is there an option to check tlog percent full and fire off backup?
  
  8) Batching row updates with transactioning could provide a HUGE performance boost due to several factors.

  TheSQLGuru October 09, 2018 12:57

  - 0 +
• 
  I would like to get involved with the development as well. Reach out to me. I might be able to convince my company to test the tool.
  

  FeodorGeorgiev November 02, 2018 17:16

  - 0 +
• 
  I would definitely be interested in trying the most recent bits of the Masker. I should make it clear that my aim is not to evaluate it for a client, nor do I plan to blog about it. But since I have worked with implementing masking myself for a database with a complex schema at my client, I believe that I will be able provide feedback that could be useful for Red Gate. I also find it interesting to compare Red Gate's product against what Microsoft has put into SSMS. So if anyone could contact me offline with more details, that would be great!
  

  ErlandSommarskog November 18, 2018 21:56

  - 0 +
• 
  I was very busy last month and now I wanted to sit and do some exercises with Data Masker vNext and write blog post about it.

  As usual, I wanted to do something bit more sophisticated like:

  - masking email address based on First name and last name of the email's owner (coming from different table)

  - masking address data but wanted to remain data consistent (i.e. region should stay one of the UK if Country is UK)

  - masking using Shuffling technique

  I guess that all mentioned options are available in Data Masker v6 but not sure about vNext (v7)?

  Could you advice me a little bit, please? 

  Even the landing page is not very informative, but maybe I missed something?

  KamilN December 17, 2018 23:12

  - 0 +

Add comment

Please sign in to leave a comment.