Redgate Blog

2 July 2015

Database Design: More Than Just an ERD

Many think that a database modeler’s only job is to create an entity relationship diagram (ERD). Little do they know that data modeling goes way beyond just drawing lines and boxes. In this article, I reflect on the real tasks of a data modeler. Read more

Redgate Data Modeler

23 June 2015

Redgate Data Modeler

23 June 2015

Making a More Advanced Model With User, Thread, and Post Statuses

Continuing my series of articles on designing a database model for an online discussion forum, I will add some more advanced features to my initial concept. Firstly, I will enhance the user details which are stored in our model, adding not only some new personal data but also simple user’s roles and statuses. Then,... Read more

Redgate Data Modeler

23 June 2015

Redgate Data Modeler

23 June 2015

How to Convert a Data Model Between Two Database Management Systems

Even though Vertabelo doesn’t provide a direct conversion of a data model from one database engine to another, this can be easily done in a few simple steps. In this article we will show you how to migrate your Entity Relationship Diagram between two different database engines using the example of a data model... Read more

Simon Holness

15 June 2015

Simon Holness

15 June 2015

Architectural principles of a DevOps team

Trying to tame complexity Over the last few years my team (“DevOps” – the name’s not entirely accurate, but close enough) have been putting together a handful of charter-like documents that we can agree on and work to. This isn’t an especially new idea and we shamelessly cribbed the initial version from one of the other teams.... Read more

8 June 2015

8 June 2015

How to integrate DLM Dashboard with (just about) every service you use

If you haven’t heard of DLM Dashboard, let me fill you in – it’s a new free tool for helping SQL Server DBAs and developers know what database schema is deployed where. One of the main ways DLM Dashboard does this is by sending an email notification as soon as it spots any unexpected... Read more

DLM Dashboard

Ben Rees

3 June 2015

Ben Rees

3 June 2015

Why our customers are ready for ReadyRoll

We’ve just finished the acquisition of ReadyRoll, a database migrations and deployment tool that makes it easy for software teams to develop SQL Server databases within Visual Studio. That’s the headline news, but why did we do it, and are our customers really ready for it? I’ll answer the second question first. Yes. With... Read more

Visual Studio

DLM

SQL Change Automation

Redgate Data Modeler

3 June 2015

Redgate Data Modeler

3 June 2015

Spider Schema – a Bridge Between OLTP and OLAP?

In this article, I look at bridging the requirements between transactional and analytical processing and look particularly at the spider schema as one possible solution. Read more

Steve Jones

28 May 2015

Steve Jones

28 May 2015

DLM training workshops

As I’ve been speaking and training people on Database Lifecycle Management (DLM), I’ve learned one thing. Trying to implement version control, and Continuous Integration (CI), and automated releases of code is hard. The concept is simple, but all of the various processes, tools, and links that need to be connected can be hard. I’ve... Read more

26 May 2015

26 May 2015

A Book Review

In this short, concise book, Kent Graziano, a guru data modeler, shares his view on ensuring the quality of data models using thorough, frequent reviews done by the whole team. His adamant eagerness to eliminate flaws as early as possible looks like a perfect way to model. But is it always applicable? Read more

Redgate Data Modeler

19 May 2015

Redgate Data Modeler

19 May 2015

How (And How Not) to Decompose Relations

The article presents some concepts on how to decompose relations and what can go wrong. These concepts may seem a bit complicated but, on the other hand, they are so basic that you rarely see it written. Still, they are essential for understanding how the normalization process works. One may prepare a perfect meal... 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

Database Design: More Than Just an ERD

Making a More Advanced Model With User, Thread, and Post Statuses

How to Convert a Data Model Between Two Database Management Systems

Architectural principles of a DevOps team

How to integrate DLM Dashboard with (just about) every service you use

Why our customers are ready for ReadyRoll

Spider Schema – a Bridge Between OLTP and OLAP?

DLM training workshops

A Book Review

How (And How Not) to Decompose Relations

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional