Activity overview
Latest activity by John_Zabroski_wam
The other drawback to SQL Clone and most tools like it is there is no RDS offering. You can somewhat work around this by using regular SQL Server IAAS instances for dev. / comments
The other drawback to SQL Clone and most tools like it is there is no RDS offering. You can somewhat work around this by using regular SQL Server IAAS instances for dev.
@T_Steve_G I think you just need to communicate to RedGate how much $ your company would be prepared to spend on such a solution. If you're a large enterprise, SQL Clone will likely be cheaper than Dephix or WinDocks, and probably better supported. / comments
@T_Steve_G I think you just need to communicate to RedGate how much $ your company would be prepared to spend on such a solution. If you're a large enterprise, SQL Clone will likely be cheaper tha...
Thanks, Chris! This is not a production system, but auditors do not seem to care. Ability to have group MSA is the only saving grace here - this probably lowers it from a red flag to a yellow flag. Do you know what permissions the Windows Storage Management API requires? I tried to find documentation prior to writing this post and the one on ServerFault, but the documentation is sparse. / comments
Thanks, Chris! This is not a production system, but auditors do not seem to care. Ability to have group MSA is the only saving grace here - this probably lowers it from a red flag to a yellow fla...
I should add: IT Audits are extremely expensive, costing anywhere between $20,000 to $100,000 per audit for one of my clients. So every time we use a tool that requires Administrator privilege to function, it raises an audit flag and lowers the IT department score and increases the frequency of costly audits. / comments
I should add: IT Audits are extremely expensive, costing anywhere between $20,000 to $100,000 per audit for one of my clients. So every time we use a tool that requires Administrator privilege to ...
Why does SQL Clone Agent need local Administrators privilege?
I recently asked this question on ServerFault and got an answer indicating Backup Operator should be sufficient: https://serverfault.com/a/948106/238609However, SQL Clone Agent service will not sta...
This seems like something for the Red Gate QA team to investigate, not me. If I happen to install a new agent I'll let you know, but I try not to mess too much with SQL Clone. / comments
This seems like something for the Red Gate QA team to investigate, not me. If I happen to install a new agent I'll let you know, but I try not to mess too much with SQL Clone.
David, Is there any chance you could change the name of this so it shows up differently in WIndows "Add/Remove Programs" list? "SSMS Integration Pack 1" isn't very clear that it's a Red Gate product, or that it is what enables SQL Toolbelt to work in SSMS / comments
David,Is there any chance you could change the name of this so it shows up differently in WIndows "Add/Remove Programs" list? "SSMS Integration Pack 1" isn't very clear that it's a Red Gate produc...
The simplest way to diagnose this is to use DMVs and look at indexes with high write counts, since DMVs reset since last reboot or when the db was last created. As long as you did not reboot between the time you created the clone, then the writes will lead you to exactly what you are doing to balloon the db size. / comments
The simplest way to diagnose this is to use DMVs and look at indexes with high write counts, since DMVs reset since last reboot or when the db was last created. As long as you did not reboot betwe...
If you have a group MSA account and SQL Clone, then make sure your SQL Clone Server depends on SQL Server and w32time services. This will avoid situations where you reboot the domain controller and sql server at the same time and a race condition occurs between SQL Sever starting and SQL Clone coming up. Cheers / comments
If you have a group MSA account and SQL Clone, then make sure your SQL Clone Server depends on SQL Server and w32time services. This will avoid situations where you reboot the domain controller an...
I use it with gMSAs but the install process is a bit klunky. You ahve to first put in a fake password, then delete the password, then click Submit. So, Chris Hurley is not entirely correct. Cheers / comments
I use it with gMSAs but the install process is a bit klunky. You ahve to first put in a fake password, then delete the password, then click Submit. So, Chris Hurley is not entirely correct.Cheers