Activity overview
Latest activity by PlantBasedSQL
Hey @DROP_TABLE_Students thanks for sharing! I was asked about using Redgate Change Control by a customer recently who had a need for the Shared Model and TFVC - so I created this video for them to run through a few features: [image] https://www.youtube.com/watch?v=7tzvCtFTacs&ab_channel=RedgateVideos Let me know if this addresses some of your questions! I believe branding is on the teams radar but thank you for the feedback [image] / comments
Hey @DROP_TABLE_Students thanks for sharing!I was asked about using Redgate Change Control by a customer recently who had a need for the Shared Model and TFVC - so I created this video for them to ...
Thanks @MariaO I'm glad this has all been resolved for you! Please feel free to mark this Q as answered if you're happy to! Thank you and happy masking! Kindest / comments
Thanks @MariaO I'm glad this has all been resolved for you!Please feel free to mark this Q as answered if you're happy to!Thank you and happy masking!Kindest
Thank you for your post @MariaO Sorry to hear you've had some issues with this! As it is ultimately just XML, if you open the DMSMaskSet file in Notepad++, VSCode or another Text editor, you should be able to manually change these numbers to something else, at least just so you can then get the set open and work from within Data Masker itself. Let me know if this helps! Kindest / comments
Thank you for your post @MariaO Sorry to hear you've had some issues with this!As it is ultimately just XML, if you open the DMSMaskSet file in Notepad++, VSCode or another Text editor, you should ...
Thanks @KimHoutmeyers Video on creating DataSets is here: https://www.red-gate.com/hub/university/courses/data-masker/getting-started-with-data-masker-for-sql-server/masking-rules-and-concepts/datasets-can-i-make I will wait to hear from you on how the run performs! Kindest / comments
Thanks @KimHoutmeyers Video on creating DataSets is here: https://www.red-gate.com/hub/university/courses/data-masker/getting-started-with-data-masker-for-sql-server/masking-rules-and-concepts/data...
Thanks @KimHoutmeyers Would you be able to provide a non-sensitive example of this just so that I'm understanding the requirement properly? That way I might be able to help better - feel free if you'd prefer to email the example to chris.unwin@red-gate.com On the other notes, the only 3 things that stands out for me are - 1) I might expect a rule like this to take 30-40 minutes based on the numbers involved, however longer than this would be too slow (obviously), 2) Non-clustered indexes _could_ be an issue here if they're trying to wrestle with the rule and all update at the same time and 3) there _might_ be a workaround with creating a new correlated dataset to use for replacement instead, but again I would need an example to best advise on this! Thank you very much, Kindest / comments
Thanks @KimHoutmeyers Would you be able to provide a non-sensitive example of this just so that I'm understanding the requirement properly? That way I might be able to help better - feel free if yo...
Hi @KimHoutmeyers Thank you for your post - 116,000 rows across 15 columns does seem like an awful lot to shuffle, so it may be that it's just a slightly heavier rule to run. Can I just confirm: - Why are you using a shuffle rule for so many columns on the table all at once? Is there a reason you're not using substitution rules? - Have you tried leaving it longer to see if it completes? - Where are you running Data Masker, and where does it sit in relation to the DB you're trying to mask? - Are any of the columns you're shuffling present in any non clustered indexes on the table? Thank you very much! Kindest / comments
Hi @KimHoutmeyers Thank you for your post - 116,000 rows across 15 columns does seem like an awful lot to shuffle, so it may be that it's just a slightly heavier rule to run.Can I just confirm:- Wh...
Thanks @Arun72 It looks like Syntax 1 you have is correct but your DATASETDIR in the PARFILE might be the issue here, possibly if the cmdline isn't escaping the "~" in your directory, are you able to provide the full path at all or perhaps capture it in "''s? It can be .txt or .PARFILE (still basically a .txt though) but it sounds more like a PARFILE issue than a cmdline issue! / comments
Thanks @Arun72 It looks like Syntax 1 you have is correct but your DATASETDIR in the PARFILE might be the issue here, possibly if the cmdline isn't escaping the "~" in your directory, are you able ...
Hi @Arun72 thank you for your post - can you please confirm the exact syntax you're running in powershell? & runs an executable but it looks like your path includes an invalid character ">", it should be used like this: & "C:\Program Files\Red Gate\Data Masker for SQL Server 7\DataMaskerCmdLine.exe" PARFILE="C:\Users\arun72\Documents\Data Masker(SqlServer)\Masking Sets\MyParFile.PARFILE" Let me know if this helps, Kindest / comments
Hi @Arun72 thank you for your post - can you please confirm the exact syntax you're running in powershell? & runs an executable but it looks like your path includes an invalid character ">", it sho...
Hey @Brian_Masker just checking in - did the above help with your query at all? Have a great week! Thanks very much. Kindest. / comments
Hey @Brian_Masker just checking in - did the above help with your query at all?Have a great week! Thanks very much.Kindest.
Hi @Brian_Masker (loving the name!) Thank you posting this - there is, at this time, no Container or Chocolatey install for Data Masker for SQL Server however your question definitely got me thinking if it was possible to use the hosted agent VM and Data Masker for this task. So I tried to achieve what you posted today and it resulted in this blog post: https://plantbasedsql.com/2021/04/09/but-i-dont-wanna-install-it-data-masker-on-the-fly-in-azure-devops-with-an-azure-sql-db/ Hopefully the step by step is enough to help - but if you have any questions, issues or would like to discuss possible workflows please just let me know. Thank you very much, Kindest / comments
Hi @Brian_Masker (loving the name!)Thank you posting this - there is, at this time, no Container or Chocolatey install for Data Masker for SQL Server however your question definitely got me thinkin...