How can we help you today? How can we help you today?
don_don
Activity overview Badges (0) Posts (2) Comments (5)

Comments

Sort by recent activity
Hello, PlantBasedSQL!  It looks like your suggestion works and will fill the gap until an interface-based solution is provided.  Thanks again for the time you spent putting this together and for sharing your expertise.  You may mark this issue resolved. / comments
  1. Community
  2. Data Masker for SQL Server
  3. updated table model - same rules?
Hello, PlantBasedSQL!  It looks like your suggestion works and will fill the gap until an interface-based solution is provided.  Thanks again for the time you spent putting this together and for sh...
0 votes
Hello, PlantBasedSQL!  Thank you for taking the time to respond to my post.  I apologize that I wasn't very clear. [address] and [address_version] are not in the same data model - at least not at the same time.  v1 of the data model contains [address] with 12 columns.  v2 of the data model has [address_version] with 16 columns; the first 12 are exactly the same in the same ordinal order as [address] - the last 4 are date columns used to version the rows.  [address] is dropped from the model and replaced because [address_version] is the 'upgrade' to [address]. Since [address_version] is the 'upgrade' I had hoped I could just point the [address] rule to [address_version] and move on.  The rules for [address_version] will remain the same as [address] since the additional date columns are non-sensitive. Regarding the 500 tables - that was a tongue-in-cheek reference to the overall data model.  I am at the mercy of a third-party vendor who is still in the process of maturing their model and offering new features as other clients request them -- all of which translates to a more fluid model that one might expect from such a provider.  I do have a lot of tables to review, but the vast majority of them do not contain sensitive data.  But as the data model is 'upgraded', I need to review (and where necessary) modify the Masker ruleset. I am at a sort of borderline; there are enough tables to mask and review on each 'upgrade' that I might be justified in integrating Data Catalog -- but not quite so much as to justify the distraction from my other tasks to integrate Data Catalog.  I appreciate the reminder about Data Catalog, though, thank you for mentioning it. If we're talking about putting this in front of the dev team, it would be a very helpful feature to be able to 'map' prior-version tables and rules to new-version tables and rules, in bulk.  So long as I'm dreaming.  [image] Anyway, directly modifying the xml in DMSMASKSET seems to be my short-term way forward.  I am comfortable with json and xml, so this shouldn't pose too big a hurdle - I just didn't know I had that sort of access.  I'll be sure to be careful.  [image] So now that I've written a novel, I'll just say thank you again for your time to research this and provide a solid suggestion to move my projects forward; I'll give that a whirl. / comments
  1. Community
  2. Data Masker for SQL Server
  3. updated table model - same rules?
Hello, PlantBasedSQL!  Thank you for taking the time to respond to my post.  I apologize that I wasn't very clear.[address] and [address_version] are not in the same data model - at least not at th...
0 votes
Hello, PlantBasedSQL!  It looks like your suggestion works and will fill the gap until an interface-based solution is provided.  Thanks again for the time you spent putting this together and for sharing your expertise. / comments
  1. Community
  2. Data Masker for SQL Server
  3. updated table model - same rules?
Hello, PlantBasedSQL!  It looks like your suggestion works and will fill the gap until an interface-based solution is provided.  Thanks again for the time you spent putting this together and for sh...
0 votes
Hey there, Panagis -- thank you for responding.  Your guidance confirmed my suspicions based on what I was seeing while trying to automate this process.  And your thoughts about the powershell script running the clone and then mopping up is exactly what I was planning to do.  Take care. / comments
  1. Community
  2. SQL Clone
  3. change db owner / set read_only with clone template .. ?
Hey there, Panagis -- thank you for responding.  Your guidance confirmed my suspicions based on what I was seeing while trying to automate this process.  And your thoughts about the powershell scri...
0 votes
I came to the forums today to ask this very question before opening a ticket.  I'm pretty sure I'm just missing it somewhere and need a nudge in the correct direction.  Red-Gate - any help? ETA:  For clarification, it looks like the login is captured for a system-canned alert in a couple of places; my question is for custom metric collection / alerting; how do I reproduce this feature for custom metric collection? / comments
  1. Community
  2. Redgate Monitor
  3. Missing "Login Name" and "Program Name" to top queries
I came to the forums today to ask this very question before opening a ticket.  I'm pretty sure I'm just missing it somewhere and need a nudge in the correct direction.  Red-Gate - any help?ETA:  Fo...
0 votes
Total activity
10
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3