Posts Categorized in Database DevOps & DLM

This is the most exciting time there’s ever been to be in the software space in general and the database world specifically. Continuous delivery practices have moved into the enterprise and the database needs to keep up too. At Redgate, we’re making it possible with a Database Lifecycle Management (DLM) process that mirrors the more familiar Application Lifecycle Management (ALM). The result? DevOps for the database becomes a reality. Crucially, Redgate software allies it to application DevOps by plugging into the same software stack. Find out more by reading our latest blog posts.

DevOps – a DBA’s perspective

Earlier this year, we ran a DevOps 101 webinar in conjunction with Redgate to a predominately DBA audience. In this blog post our own DevOpsGuys DBA, Paul Ibison, gives his views on what DevOps means from a DBA perspective. Note that Paul is a SQL Server DBA, so some of the comments are specific... read more

SQL Clone and backups protected with TDE – part 2

My last article demonstrated that you can use SQL Clone to make a copy of a live database, even when that database is protected with Transparent Data Encryption (TDE). However, not everyone will want to use SQL Clone against a live database, especially a production database. Fortunately, SQL Clone allows you to build an... read more

SQL Clone and databases protected with TDE – part 1

SQL Clone is designed to make it easy to provision copies of a database for development and test environments in seconds. Often, these ‘clones’ are copies of production databases, which contain sensitive data that needs to be protected from unauthorized access. Transparent Data Encryption (TDE) is one technique that many organizations have implemented in... read more

Where’s the database in DevOps?

At the end of 2015, we interviewed James Betteley, Head of Education at DevOpsGuys about the role of the database in DevOps. James is a firm believer that DevOps is about people and processes, and that while automation tools are necessary, they are not sufficient for a team to be a DevOps team. Here’s what... read more

Database provisioning: getting started with SQL Clone

For large databases, it’s a hard and time consuming task to provide database developers with development or test copies of that database that resemble the production database, in terms of the size, distribution and nature of the data. It can take a lot of time to produce a copy of the latest database build,... read more

So what’s the real state of database DevOps?

Good question. Redgate recently ran a State of Database DevOps survey among 1,000 software professionals. The survey included developers, database administrators, and those at management level, and over half of the companies involved employed more than 500 people. I took a quick glance at the results in a recent blog post and talked about some surprising findings:... read more

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... read more