DLM Automation

SQL Toolbelt

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn’t. But one particularly common culprit is when deployments go wrong: I don’t know a single DBA who hasn’t been burned by a bad release. To Read more

DLM Automation

Database CI with Redgate DLM Automation, PowerShell and Jenkins

While the practice of Continuous Integration (CI) started with application code, you can apply the same principles to databases. Database CI is the process by which we build, test and deploy the database on commit of every database change, and report any errors. In this way, CI reduces your feedback loop such that changes that Read more

DLM Automation

Using database replication with automated deployments

The Redgate DLM Automation team that we’re part of took time out from development to explore some of the issues our customers face when automating database deployment. Following on from previous posts about cross-database and cross-server dependencies and production database drift, this blog shares some of our thoughts about how to deal with database replication. Database replication is Read more

DLM Dashboard

We don’t need no documentation – automating schema docs in Redgate DLM

“Understanding the existing product consumes roughly 30 percent of the total maintenance time.” Facts and Fallacies of Software Engineering by Robert L. Glass. You should be documenting your database schemas. I know it, you know it. Having (current, accurate) documentation available accelerates time-to-resolution for faults, aids tech-to-business conversations, and is a regulatory requirement for a great number of firms. Read more

DLM Dashboard

Dealing with production database drift

The Redgate DLM Automation team that we’re part of recently took time out from development to explore some of the issues our customers face when automating database deployment. Following on from last week’s post about cross-database and cross-server dependencies, this blog shares some of our thoughts about how to deal with production database drift. If Read more

DLM Automation

DLM Automation add-ons

Many software teams are already integrating their application code but haven’t yet brought the continuous integration discipline to their database development. With DLM Automation, you can extend that process by plugging into third party tools commonly used for application development. It’s now even easier to find the add-on you need for your build or release system. Read more

DLM Automation

Deploying cross-database dependencies to different environments

The Redgate DLM Automation team that we’re part of recently took time out from development to explore some of the issues our customers face when automating deployment of database changes.  As part of that exercise, we took a closer look at cross-database and cross-server dependencies – these can cause problems when deploying databases to multiple Read more

SQL Source Control

Sometimes the tool just fits – using Redgate DLM and Octopus Deploy for data change control

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 by Read more