Posts
Sort by recent activity
Handle out of order changes to static data
We have a table that we use to store the current version of an application. A simplified version of it can be thought of as a primary key (auto-incrementing) and a string with the application vers...
Can flyway refuse to execute code with missing where clause?
SQL Prompt has the "Show execution warnings: Show warnings for statements with an INNER JOIN" that will warn a user in SSMS if execution may affect an undue number of records due to incorrect JOIN ...
DataFileSet element in RedGateDatabaseInfo.xml changes
This part of the file seems to change without reason: <DataFileSet> <Count>3</Count> <DataFile>MOM.Enums_Data.sql</DataFile> <DataFile>MOM.Errors_Data.sql</DataFile> <DataFile>MOM.Prin...
How do I change the size of the text in Flyway desktop
The text is overly large and I'd like to see more information on the screen at the same time.
SQL Monitor replication alert
Are there any out-of-the-box alerts that can be used to alert when transaction based replication is slow or has failed?
What the the best SQL server securables for account running Azure DevOps build agent
I am configuring the Azure DevOps on premises agent to build and deploy database using SQL Change automation. I have set up the agent to run as a service and have an active directory user to do th...
Deploy SQL Doc to SharePoint
How do I generate SQL documentation and deploy to SharePoint?
Out of date documentation
https://documentation.red-gate.com/sca/deploying-database-changes/add-ons/azure-devops/use-the-azure-devops-release-extension-with-an-approval-step has a mistake. Section 5.3.4 states "In Operatio...
Out of date documentation
https://documentation.red-gate.com/sca/deploying-database-changes/add-ons/azure-devops/use-the-azure-devops-release-extension-with-an-approval-step has a mistake. Section 5.3.4 states "In Operatio...
Azure DevOps Build Agent is using deprecated task execution handler
This warning is thrown during Build Pipeline execution:
##[section]Starting: Build SQL Change Automation Project MOM
==============================================================================
T...