Benefits from Data Lifecycle Management

Database Lifecycle Management, DevOps
I spend a lot of time talking about the need for automation within your databases, especially in support of development, deployment, and through process management. It's because I learned the hard way just how important this stuff is. It took a pretty strong developer (in the sense of abilities, he didn't beat me up) to convince me that I was doing database development the wrong way. However, once he made me see the light, I was like one of the Blues Brothers, on a mission. However, I think this is one of the hardest parts to get people to understand. If you have a mostly, or completely, manual deployment process, you're experiencing pain from the inefficiencies that causes. However, it's a pain that's¬†just embedded into the organization so much, that…
Read More

How to do DevOps as a SQL Server DBA

Database Lifecycle Management, DevOps
You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support for your development teams as you possibly can, that you have to have testing in place to ensure protection of the production environment, that you need to speed your processes. In short, you recognize the need for taking on a DevOps approach, an Application Lifecycle Management (ALM) approach, even, a Database Lifecycle Management (DLM) approach. Cool. Now what? Well, there are three¬†fundamentals that you need to get under your belt. You need to get your database into source control. You need to set up a continuous integration process. You need to set up automated deployments. All tough nuts to crack. Hey, we get it. That's why Redgate Software is going…
Read More

Database Lifecycle Management

Redgate Software
There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every application and if you do a similar search, there aren't very many people talking about Database Lifecycle Management at all. Why not? I'm positive you're deploying a database with your applications. I'm also positive, because of the unique problems that databases present, primarily around data persistence, that you need to think about how to get your database(s) deployed. Unfortunately, even for strong, capable data professionals, deployment is something thought about later. Or, you're still doing the old school method of waiting until there's a deployment script that you're going to review, line-by-line, before you run it against production. There's a better way. What you need to do is start thinking…
Read More