Redgate News - February 2015

In 2015, 40% of outages on mission critical services will be caused by change management or deployment failures - Gartner

Solving the database deployment problem with Database Lifecycle Management (DLM)

Databases are particularly vulnerable to these outages. Cumbersome manual processes, together with the requirement to protect data at all costs, have often led to the database being a bottleneck during deployment. Databases are also notoriously difficult to deploy safely. Database Lifecycle Management (DLM) is changing this.

With a combination of team practices, collaboration, and tooling, your database deployments can now gain all the benefits of automation with continuous delivery: greater predictability, reduced risk, and the flexibility to deliver releases regularly and on demand. This whitepaper explores what DLM means for your team and how to build a DLM approach into your development and deployment processes.

Download the whitepaper


Discussions

Grant Fritchey

The database: the elephant in the room

Grant Fritchey and Jonathan Hickford join Arrested DevOps' Matt Stratton and Trevor Hess for a discussion around continuous delivery, databases, DevOps, and DBAs.

Listen to the podcast

Database Lifecycle Management

"Now, it literally takes a few clicks to deploy"

Anthony Hall, IT Operations Manager at Move with Us explains how database updates used to take a full working day to deploy, but with Redgate's DLM tools they now take 15 minutes.

Read the case study


Research
Can you help with SQL Gemini research?

SQL Gemini research

SQL Gemini is an experimental new approach for version controlling databases. We’re building it to automatically keep your database in sync with a scripts folder, which is version-controlled using your existing version control system.

We’re looking for people to help us research a new prototype we’ve created. This isn’t a full tool yet, or a beta. Instead we’re trying out a new approach to get early feedback, and we need people who are willing to give some of their time to help us move further forward.

Help with the research


Betas

SQL Release

Releasing databases with SQL Release and Octopus Deploy

SQL Release team member Brian Harris explains how you can release a new version of your database using SQL Release and Octopus Deploy. He also shows how you can pause and review the script and other resources before releasing.

Read the walkthrough

SQL Lighthouse

What have we learnt from SQL Lighthouse beta, spaghetti sauce and the Mom Test?

There’s no one-size-fits-all approach to implementing an automated database deployment pipeline. SQL Lighthouse’s designer Jonathan Roberts talks about the challenges of designing a database lifecycle management (DLM) dashboard and alerting system, and what approaches the team have taken to make sure they’re creating the right product for real users.

Read the article