Posts
Sort by recent activity
SCA - Correct order for pull, commit, etc
We've got some developers that made larger changes (schema and programmable objects) to their local DBs. We got one dev's changes into source (git repo in Azure Devops), buildable, and pushed to t...
SCA - Correct order for pull, commit, etc
We've got some developers that made larger changes (schema and programmable objects) to their local DBs. We got one dev's changes into source (git repo in Azure Devops), buildable, and pushed to t...
SSMS SCA Hangs regularly
SCA 4.2.20168 in SSMSThe SCA plugin seems to hang quite regularly for various operations. Noticed it during "Apply to Database" today, but I believe I've seen it in other tabs/processes, too. Is t...
SSMS Plugin verify success. Invoke-DatabaseBuild ERROR/FAIL
SQL Change Automation 4.2.20168SSMS Plugin.I have seen cases where "verify" in the SSMS plugin works fine, but when I run:Invoke-DatabaseBuild $ProjectFilePath -VerboseI get errors. It's causing m...
SCA in SSMS: "Cannot drop database "%_SHADOW" because it is currently in use"
SCA Version 4.2.20154.20409. SSMS plugin.Attempting to "Generate migrations". Keep getting:I've found the SPID connected to shadow and killed it a couple of times, but the error keeps happening. ...
changed alert email address, also turned all alerts ON
So, I just tried to change the alert notification email address for a single server. I selected "ALL" for the alerts, changed the email address and then saved. That had the unintended side effect ...
Plans to add a New-DatabaseMigration cmdlet?
It would be helpful to have a powershell cmdlet that could be used to generate new simple migrations rather than clicking thru a UI. Any plans? I see a related uservoice: https://redgate.uservoic...
OK to use both Visual Studio AND SSMS SCA tools/plugins for SCA?
SCA: 4.2.20098.19104We have an SCA project that was originally generated in SSMS. We might have some users that would prefer to use the Visual Studio plugin instead. Any caveats for using both to...
Alert fired, but no email notification
SQL Monitor 10.0.7.27595We have email notifications configured for SQL Agent job failures. Last night we had two different jobs fail on the same SQL instance, which triggered two alerts, but only ...
sql server vs machine CPU in SQL Monitor 10
SQL Monitor 10.1.11I'm looking at a time period in SQL Monitor where the main CPU metric at the top is pegged at 100%: I then looked down at the CPU area below and see that the machine CPU seems t...