Redgate Blog

5 November 2015

Interesting Changes in MySQL 5.7

The development release of MySQL 5.7 definitely introduces some exciting changes to the world of database management systems. Is it worth giving a try? Let's have a closer look at a few brand-new features that may help you decide to do so. Read more

Redgate Data Modeler

3 November 2015

Redgate Data Modeler

3 November 2015

The Business Data Vault

In the third part of our series on Data Vault modeling, we will get into the details of how we prepare the Data Vault tables for business user access. Read more

Owen Priestley and Santiago Arias

2 November 2015

Owen Priestley and Santiago Arias

2 November 2015

DLM Dashboard as a team tool

DLM Dashboard is a great collaborative tool, which integrates with lots of different services. However, some teams told us that they couldn’t use DLM Dashboard without support for users and permissions. Previously, access to DLM Dashboard was entirely unrestricted. Essentially, all users were given administrator permissions. As the tool grew in popularity, we started... Read more

DLM Dashboard

Redgate Data Modeler

29 October 2015

Redgate Data Modeler

29 October 2015

Database Model for a Messaging System

People love to communicate. We often joke that any software system always evolves into a messaging system. This article will explain the system requirements and step by step approach to design a data model for a messaging system. Read more

Redgate Data Modeler

27 October 2015

Redgate Data Modeler

27 October 2015

Applying Simple Access Control to a Small Data Model

“Information is the lifeblood of any organization…” We hear a lot of statements like this, or about an “information age,” or an “information economy.” When we agree with belief that amplifies the importance of information in the world today, we have to consider how to make that all-important information secure. The database professional has... Read more

Steve Jones

23 October 2015

Steve Jones

23 October 2015

DLM S4 – Release Management

Deploying database changes to new environments is a very stressful activity. Many organizations and their employees dread migrating changes to a production database because of the potential for problems or downtime. There are ways to minimize the potential issues and build more reliable deployment processes. In fact, many organizations do this, but they do... Read more

20 October 2015

20 October 2015

Data Vault 2.0 Modeling Basics

In my last post, we looked at the need for an Agile Data Engineering solution, issues with some of the current data warehouse modeling approaches, the history of data modeling in general, and Data Vault specifically. This time we get into the technical details of what the Data Vault Model looks like and how... Read more

Steve Jones

19 October 2015

Steve Jones

19 October 2015

DLM S3 – Continuous Integration

In this post, we take a big step forward in engineering the database development process by looking at Continuous Integration (CI) for your database and the characteristics of a software pipeline that begins to implement a repeatable process. This is the S3 stage, named for, and characterized by, the use of CI. S3 –... Read more

DLM

continuous integration

Steve Jones

16 October 2015

Steve Jones

16 October 2015

DLM S2 – Automated Version Control

In my last post, I looked at the first stage of our maturity model, the Manual level. In this post we move to the S2 level, which is characterized by the use of a formal Version Control System (VCS) and process. S2 – Automated Version Control Many software development organizations have implemented a VCS... Read more

12 October 2015

12 October 2015

DLM S1 – The manual stage

At Redgate Software, we’ve been trying to build tools that help developers work with software better. One of our areas of focus in the last few years has been streamlining database development and deployment. To help customers migrate to a smoother workflow and a better engineered software development pipeline, we’ve built our own maturity... Read more

DLM

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

Interesting Changes in MySQL 5.7

The Business Data Vault

DLM Dashboard as a team tool

Database Model for a Messaging System

Applying Simple Access Control to a Small Data Model

DLM S4 – Release Management

Data Vault 2.0 Modeling Basics

DLM S3 – Continuous Integration

DLM S2 – Automated Version Control

DLM S1 – The manual stage

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional