Posts
Sort by recent activity
Use SSMS and VS plugins/extensions on same project?
A while back, I attempted to have some folks use the VS SCA plugin and some folks use the SSMS one on the same SCA project. If I recall, there wer some odd mods to the sqlproj file that were a lit...
Azure SQL Database and SQL Server CREATE USER syntax usage
We use SQL Server 2019 Developer Edition for our local dev sandbox DBs, and we use Azure SQL Database for our test and prod DBs. I want to make a migration that will create a USER from a windows (...
Find instances of specific wait type?
I am seeing THREADPOOL waits as the top wait on an instance since startup. I would like to find out when these are occurring and what is causing them.Unsure how best to go about this. Started going...
flyway community vs teams - sql server 12.0/2014
Did not see a flyway forum category...I decided to explore flyway this week. Like many java apps on windows, the install and config was...tedious. I finally got rid of the "no mssql-jdbc_auth-8.4....
Monitor SSIS memory usage and errors in SQL Monitor?
Hoping to find some way to more closely monitor SSIS memory usage and errors in SQL Monitor. I'm aware of the performance counters for the "SQL Server:SSIS Pipeline" object - Buffer Memory and Buf...
Best Practices for SCA and git branching
Hello RG Peeps,I've read a few articles and forum posts on using SCA and git branching. Notably, @way0utwest and @Kendra_Little have shared good ideas on this topic. I wanted to start another pos...
Any way to configure a custom metric alert to only send one notification email?
I just created a custom metric for tempdb space used %, collecting every minute. I set 90% as the threshold for a medium alert. I'm afraid that I am going to get 35 emails as each minute the aler...
Azure Devops "Perform DeployFromPackage" fails due to serverless Azure SQL DB paused
We have an Azure DevOps pipeline and release configured that use "classic" (non-YAML) pipelines. We're also using the RedGate plugins for SCA build and release/deploy (for now). Our target DB is ...
Confusion around repo commit & pull sequence for SCA dev
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...
Confusion around repo commit & pull sequence for SCA dev
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...