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. Read more
We recently invited our customers to share their top tips for improving productivity in the first Redgate Tool Tips Swap. This post outlines their hints for using Redgate products to boost productivity and includes relevant training resources to further your learning. SQL Prompt Share formatting settings across your team to consistently format code before... Read more
Updated August 2020 In our series of blog posts about Version Control and the Database, we’ve explored the history of version control, why databases have some unique requirements, and why it’s important to include them in your VCS. In this concluding post, I focus on Redgate SQL Source Control and answer some fundamental questions... Read more
The long-awaited release of SQL Server Management Studio (SSMS) 2016 is approaching, bringing with it a more modern look and feel, more features, and more advantages for users. At Redgate, we’ve been working closely with Microsoft to make sure the latest version of SQL Source Control supports SSMS 2016 from launch day. SQL Source Control... Read more
How to use a combination of database roles, along with rules, filters and post deployment scripts in SQL Source Control, to add the required users to the correct role, for each database. Read more
It’s a familiar story. Two developers are working on a database, they’re using version control, and there’s a problem. The bigger problem is, they don’t even know they have a problem. As far as they’re concerned, they’re doing everything right. They’ve been using version control, so they can deploy the database changes they’ve been... Read more
From a business risk perspective, data change can be just as significant as code or schema change. Sometimes even more so; an incorrect static (or reference, or master) data change can drive your software’s behaviour more dangerously askew than pretty much any bug can. Imagine treating a retail customer for an investment fund as a corporate... Read more
Where developers have their own databases, you need to ensure the user accounts are configured identically across all development and test server, or you'll inevitably hear the phrase “…but it works on my machine”. Alex Yates describes, strategically, how this might work. Read more
