Activity overview
Latest activity by gbargsley
Azure SQL Managed Instance bug
Is this the best place to submit information on possible bugs found?Recently when doing some work in the SQL Monitor web interface, I noticed a difference in behavior when viewing an Azure SQL Mana...
I have a similar need, but am starting from nothing. Currently our service operations team creates ad hoc sql scripts to fix issues discovered in different areas of different applications. They submit these to the DBA team for execution. Originally it was thought the DBA team would review them and execute. That is simply not the case outside of syntax error checks I cannot review for logic or data changes as I am not familiar with all the products and how the databases work. So my management is wanting to get me out of the middle of this as I am not serving any purpose except I have permissions to execute. I am trying to find out how to implement a process that the service team can create and test their scripts in DEV, then a system that will execute in production once validated/approved. I know it is not a true build and deployment type solution, but I am looking for something that would help automate this without build my own. Any suggestions would be great. / comments
I have a similar need, but am starting from nothing. Currently our service operations team creates ad hoc sql scripts to fix issues discovered in different areas of different applications.They sub...
Ok, so I converted my dmset to a v6 file. I ran it through DataMasker GUI manually to make sure all worked with no errors. That is fine. I just created a PARFILE and am trying to figure out how to execute via PowerShell but the docs appear to only reference command line as DOS. I used to use: Start-Process "C:\Program Files\Red Gate\Data Masker for SQL Server\DataMasker.exe" "D:\DBA\DataMasker\Masking Sets\Elastic_DataMasking_08152018.DMSSet -R -X" -NoNewWindow -Wait But: Start-Process "C:\Program Files\Red Gate\Data Masker for SQL Server 6\DataMaskerCmdLine.exe" "PARFILE=D:\DBA\DataMasker\Masking Sets\v6\PARFILE_Elastic_DataMasking_01312019.txt -R -X" / comments
Ok, so I converted my dmset to a v6 file. I ran it through DataMasker GUI manually to make sure all worked with no errors. That is fine. I just created a PARFILE and am trying to figure out how ...
Thanks for the input. I will revisit upgrading and getting my DMSets migrated. / comments
Thanks for the input. I will revisit upgrading and getting my DMSets migrated.
I have 6 installed, but I do not have the time to make the changes needed to work with my existing 5.x data masks. / comments
I have 6 installed, but I do not have the time to make the changes needed to work with my existing 5.x data masks.
Product Not Licensed error
I have automation that runs in a PowerShell script that is kicked off by a SQL Agent job. If I do not run Data Masker as an actual user account. My windows AD account for a period of time my autom...
SQL Data Compare selected tables only (command line)
I am currently working to automate the process of updating our development environment with production schema and lookup table data.
I have figured out how to take a snapshot of production and comp...
Command Line Basics
We are working on a project to deploy our Admin tools to new servers that are brought in to the environment and to keep synchronized on existing servers. We started writing our own process and fou...
SQL Compare Objects referencing Objects
I am trying to build a script for a database using SQL compare 9.
We are running in to issues where Stored Procedures and Views are referencing other objects that have not been created yet by the S...