Posts
Sort by recent activity
Is SCA going away?
Not seeing much new dev for SCA, and in the main redgate web page, it's not even listed under products. Do we need to be rethinking our DB devops strategy? Flyway enterprise? we've been using sca f...
Azure Data Factory, Synpase, Azure SQL Database, and SQL Change Automation
Hello!We are moving more of our work away from on-prem SSIS into synapse/ADF and using Azure SQL DB. This is great, but we are also using SCA. This was working OKish when developing ETL in SSIS, ev...
Getting frequest SQL Authentication Failed alerts for one server
SQL Monitor 11.2.11.14502Getting somewhat frequent (maybe hourly or so) Monitoring Stopped (SQL Server Authentication) alerts that go away within roughly a minute. This is only happening for one se...
Simpler ways to add additonal built-in performance counter metrics?
SQL Monitor 11.2.11.14502I am familiar with custom metrics and have added a few. However, I often just come back to, "It should be simpler than this". For example, I wanted to look at "SQLServer Bu...
Configure alert notification email at server level/scope?
SQL Monitor 11.2.11.14502Apologies if this has been answered before. I'm unable to find it in the docs or my own notes. I'd like to configure all alerts for a single server (all instances) to noti...
SQL Monitor: Can a alert and notification be fired via Add-SqlMonitorAnnotation?
SQL Monitor 11.2.11.14502I'm stoked to find Add-SqlMonitorAnnotation in the EdgateSQM powershell module. I have a PoC script that creates an Error annotation up and running. However, nobody will ...
Alert notification emails resent - all on one day
SQL Monitor 11.1.11.10642Last Saturday, our team received a ton of what appear to be "resent" alert notification emails from SQL Monitor. I thought maybe the SQL Monitor server was rebooted, but th...
Git repo organization for SCA + SSIS + AAS, etc.?
Hello RG folks,We currently have our DB (SCA) in a git repo, hosted in Azure DevOps. We have CI for that, triggered by commits on master (yes, I know I need to change that branch name). Our SSIS c...
Azure SQL Database not available in Analysis page?
I am monitoring a provisioned, single database Azure SQL Database. However, that instance does not show up in the Analysis page/tab. Do I need to configure something else to get it to show up?Tha...
How do I get a drift report?
I used New-DatabaseReleaseArtifact to effectively compare my local dev DB to the prod DB with the intent of getting a drift report and drift correction script. However, all I got was the changes.h...