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.

Announcing Redgate Data Tools in Visual Studio 2017

Visual Studio 2017 is released today, and its new features like Live Unit Testing and configurable code style rules have already been grabbing the headlines. But inside the Visual Studio 2017 installer, another big surprise awaits: Redgate Data Tools. We’ve partnered with Microsoft so Visual Studio Enterprise subscribers can install ReadyRoll Core, SQL Prompt... read more

Database provisioning from backups using SQL Clone

In a previous article, Getting started with SQL Clone, I described how SQL Clone could remove much of the administrative burden from the database provisioning process, the advantages of a new, lightweight process to spin up “real databases” for use in development and test work, and finally how to produce data images and then... read more

SQL Clone: the aspirin for your database provisioning headaches

When developing a database as a team, most team members would generally prefer to work with their own, isolated copy of the database, rather than work on a shared development database. Up to now, however, there have been a number of additional management and security problems with the dedicated database approach and these burdens... read more

Team-based database development with SQL Clone

For most development teams, the database provisioning process involves some element of compromise. Often, developers will work with the up-to-date database schema but only a small sample of test data, for example. It’s a fast, lightweight approach that is sufficient for most simple tests, but it doesn’t necessarily reveal exactly how the application will... read more

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