Data and database management in everchanging technology landscape
This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.
2022-03-23
1,473 reads
sql change automation
Win DevOps books with Redgate’s competition
Redgate is giving you the chance to win your choice of DevOps books and Redgate goodies in their latest competition. To enter, visit the Redgate Forums and answer the question: ‘How is SQL Change Automation helping you?’
2021-05-17
Moving from application automation to true DevOps by including the database
This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code.
2021-04-08
Database Build Blockers: Four-part Object References
Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms.
2020-12-24
Database Updates: Rolling Back and Fixing Forward
Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update.
2020-12-11
Using Filters to Fine-tune Redgate Database Deployments
Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.
2020-09-02
Introducing SQL Change Automation 4.3
The latest version of SQL Change Automation now integrates with SQL Clone to let you use a snapshot of your database’s schema as a baseline. This simplifies migration development in complex databases, avoiding problems like invalid objects or circular dependencies, and you can verify migration scripts on a copy of the currently released database.
2020-08-20
6 New Courses Published on the Redgate University
Master the fundamentals of Redgate products with easy to follow video courses on Redgate University. This month 6 new courses have been published to help you advance your skills including courses on SQL Prompt, SQL Monitor, SQL Change Automation, SQL Compare, and Database DevOps for Oracle. All brought to you by some amazing presenters like Kendra Little, Grant Fritchey, Kathi Kellenberger and the Redgate team of experts. Start learning now!
2020-07-17
Allowing for manual checks and changes during database deployments
SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.
2020-06-15
New release: SQL Change Automation 4.1
We’ve heard from users that they really care about static data and were missing the feature in the SQL Change Automation SSMS plugin. In v4.1, we’ve added support for the tracking of static data tables to the SSMS extension, alongside existing support in the VS extension. Maya Malakova has written a technical summary showing how to use this feature. Learn more about the release here.
2020-01-21
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
URL Safe or Not?
Comments posted to this topic are about the item URL Safe or Not?
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers