Redgate Blog

31 March 2015

“Concise Guide to Databases” – briefly about everything

There are books that you plan to read. Then, there are books that you actually started reading and then stopped. Then, there are books you started reading and you hope to finish sometime. The last database book I did read was "Concise Guide to Databases" by Peter Lake and Paul Crowther. Read more

Jonathan Hickford

27 March 2015

Jonathan Hickford

27 March 2015

Customer-specific database deployments

A question we often get asked is how to deploy specific variations of a database to different customers. Or how to deploy different static configuration data to each customer, and how to version control, test and deploy this per customer in an automated way. In the post below I’m going to run through an... Read more

continuous integration

automated deployment

Alex Yates

26 March 2015

Alex Yates

26 March 2015

Database CI and automated deployment with Jenkins: a Step by Step Tutorial

This post has now been updated by Alex Yates to reflect the latest software. Read the new post. Read more

automated deployment

SQL Source Control

SQL Change Automation

26 March 2015

26 March 2015

The 5 big benefits of automated deployment

“Every software development team should have a fully automated deployment process.” That’s according to pretty much everyone I meet at conferences and events. It’s not even a debate. It’s a declaration. In actual fact there are only a small number of software development teams who have a ‘one-click’, totally hands-off approach. In Redgate’s latest... Read more

automated deployment

Redgate Data Modeler

26 March 2015

Redgate Data Modeler

26 March 2015

Designing & Deploying a PostgreSQL Database in the Cloud

Our users sometimes say to us: “Vertabelo is awesome but... how can I add the data?” That's why I decided to show you how to set up a simple PostgreSQL database in the Cloud using a database model created in Vertabelo, and cloud-based PostgreSQL server hosted by ElephantSQL. So let's dive into the Cloud! Read more

Redgate Data Modeler

20 March 2015

Redgate Data Modeler

20 March 2015

A Database Model for an Online Survey. Part 2

In part 1 of this article series, we discussed a basic design for an online survey. In the conclusion to that article, I mentioned part 2 would cover more advanced features for our survey. Let’s start by extending the functionality to support different types of questions. Read more

Redgate Data Modeler

12 March 2015

Redgate Data Modeler

12 March 2015

How to Color ERD Diagrams in Vertabelo

When you are designing a database model with hundreds of tables, you can make it more readable and comprehensible by coloring different groups of tables or subject areas. Learn how to do this quick and easy in Vertabelo. Read more

Redgate Data Modeler

5 March 2015

Redgate Data Modeler

5 March 2015

A Database Model for an Online Survey. Part 1

I need to create the design for a new database which will be the data layer for an application; the application will be an online survey or polling like Survey Monkey. My challenge is that the functionality that I require is not supported by existing survey sites, so I need to build my own.... Read more

Redgate Data Modeler

26 February 2015

Redgate Data Modeler

26 February 2015

5 Steps for an Effective Database Model

Database design is the process of producing a detailed model of a database. This model contains the necessary logical (table names, column names) and physical (column datatypes, foreign keys) choices to translate the design into a data definition language (aka SQL), which can be used to create the actual physical database (...) Read more

Redgate Data Modeler

19 February 2015

Redgate Data Modeler

19 February 2015

Modeling a Basic Data Structure to Manage Users, Threads, and Posts

An online discussion forum is a site where people can hold conversations in the form of posted messages. Discussion forums allow conversations to take place when people are not on-line, and messages may be temporarily archived. Also, depending on the forum set-up, a message might need to be approved by a moderator before it... Read more

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Blog

“Concise Guide to Databases” – briefly about everything

Customer-specific database deployments

Database CI and automated deployment with Jenkins: a Step by Step Tutorial

The 5 big benefits of automated deployment

Designing & Deploying a PostgreSQL Database in the Cloud

A Database Model for an Online Survey. Part 2

How to Color ERD Diagrams in Vertabelo

A Database Model for an Online Survey. Part 1

5 Steps for an Effective Database Model

Modeling a Basic Data Structure to Manage Users, Threads, and Posts

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional