simple-talk.com simple-talk.com

How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant

The series so far: Connecting to PostgreSQL: Learning PostgreSQL with Grant Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant How to back up and restore with PostgreSQL: Learning PostgreSQL with Grant One of the first things I worry about when I’m looking at a new system is the status of the backups. I don’t see anything in PostgreSQL that will lead me to a different conclusion. However, I didn’t...

simple-talk.com simple-talk.com

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

The series so far: Connecting to PostgreSQL: Learning PostgreSQL with Grant Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant You have an instance of PostgreSQL running locally (or you’re connected to the cloud). Now, what to do with it? In the first article in this series, I said I would start by learning about backups. However, I realized I had another thing I needed to do before I could begin learning...

aisto.com aisto.com

Why Would You Pay for Flyway?

Flyway is an open-source database deployment tool that also includes a paid tier called Teams. Since it’s open-source, you can just download Flyway and run it for free. You’ll get a robust DevOps tool to assist you in deploying your databases just like you deploy your code. It just works. So, why would you even bother to pay for Teams? Actually, there are a number of reasons why people pay for advanced tiers of open-source software...

aisto.com aisto.com

How Does Microservices Architecture Change Database Deployment?

This question was raised at the recent Redgate Summit: How does the implementation of a microservices architecture affect the implementation of a database DevOps approach? I could even rephrase it a little: Does a microservices architecture affect a database DevOps approach? Microservices is, or isn’t, one of the hot new trends, depending on how you look at it. The concept of a microservices architecture doesn’t hit the lists of...

aisto.com aisto.com

Code Review and DevOps

Almost every time I teach a class on DevOps, one of the questions that comes up is: How do we do code reviews in this automated process? There are actually a number of answers to this question. Let’s walk through a few. Source Control If you’re automating your deployments, I don’t think I’m going out on a limb to say you almost certainly have your code in source control. So, if you want to review the code, source control is a...

aisto.com aisto.com

Three Steps To Get Started With Database DevOps

Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve already done the hard part, making the decision to shift the culture. Now, what’s involved is just lots of labor. There are three things you can do to begin your Database DevOps journey: Get your database into source control Start using a tool to build databases from source control Automate those builds through a...

aisto.com aisto.com

Database DevOps at Ignite

We’re only a week away from the Microsoft Ignite virtual conference. Ignite runs between March 2nd and March 4th. Follow the link to see the stellar individuals who will be presenting great content. There are a lot of opportunities to learn all you can about Microsoft technologies. I’ve got additional good news. Redgate is going to be there as well. To start with, I’ll be hosting a session that reports on the results from our...

aisto.com aisto.com

State of Database DevOps 2021 Survey Results

I am extremely excited to report that 3,200 of you responded to our State of Database DevOps survey. Developers, DBAs, the C-Suite, we have a little bit of input from everyone. And, we’re going to be releasing the survey results really soon. As a matter of fact, as part of our upcoming event, Redgate Summit: The Future of Database DevOps, I’m presenting a session on the survey results and my thoughts about them. Please, do follow...

aisto.com aisto.com

Challenges to Database DevOps: How Do You Maintain Master Data?

When it comes to deploying databases, one of many challenges that arises is dealing with your master data, lookup data, or sometimes even reference data. It’s those tables that store the lists of choices like a Suffix to a name such as Dr., or Ms. Or something else. In fact, during a recent panel discussion one of the questions that came up was: One of my main challenges is how to maintain master data. I have not been able to find a...