Redgate Blog

21 February 2014

How to Create a Database Model From Scratch

So you want to create your first database model but you don't know how to start? Read on! I assume you already know a little about tables, columns, and relationships. If you don’t, watch our video tutorials before you continue. Read more

Redgate Data Modeler

10 February 2014

Redgate Data Modeler

10 February 2014

1000 users and growing strong!

It's been already 100 days since we launched Redgate Data Modeler. There is already 1000 satisfied Redgate Data Modeler users. Thank you for your trust and interaction! Read more

Redgate Data Modeler

6 February 2014

Redgate Data Modeler

6 February 2014

Database Design 101: References

In this third part of our Database Design 101 series you will learn about references – how to create a relationship between the tables, how it affects their structure, and how it looks in the data. Read more

Geoff Bones

30 January 2014

Geoff Bones

30 January 2014

Code kata 1: Old money

The kata Imagine: it’s 1968 – the Beatles, Carnaby St and Austin Powers – except there’s all the technology of 2013 as well. Including vending machines. But, being 1968, vending machines have to deal with old money. It’s quite simple; I’ll describe it here. Money is made up of pounds… Read more

28 January 2014

28 January 2014

WordPress Database Finally Unveiled!!!

Sorry for that tabloid title, but I couldn't resist. I'm going to show you how to view the database design of other people’s systems. It will work for legacy systems as well. Of course, you may call show tables and describe table in the database console but that’s a very rudimentary way to examine… Read more

Redgate Data Modeler

28 January 2014

Redgate Data Modeler

28 January 2014

Database Design 101: Tables, Columns, and Data Types

In this video tutorial for beginners, you will learn about table columns and the most commonly used data types. Read more

Redgate Data Modeler

24 January 2014

Redgate Data Modeler

24 January 2014

Designing a Database: Should a Primary Key Be Natural or Surrogate?

Suppose we design a database. We've created some tables, each one has a few columns. Now we need to choose columns to be primary keys (PK) and make references between tables. And here some inexperienced designers face the dilemma – should a primary key be natural or surrogate? There's one and… Read more

Redgate Data Modeler

23 January 2014

Redgate Data Modeler

23 January 2014

Database Design 101: What is a Database

First part of our Database Design 101 series that brings you an easy-to-understand introduction to databases. Read more

Redgate Data Modeler

30 December 2013

Redgate Data Modeler

30 December 2013

Database Design 101: Database Model for an Online Store

A good data modeling exercise for beginners is to create a data model of an online store. Every time I give this exercise to my students, I'm surprised at how difficult it is for them. Let's see how it can be done. We know we have to create a table… Read more

Redgate Data Modeler

16 December 2013

Redgate Data Modeler

16 December 2013

How to import an existing database into Redgate Data Modeler: Reverse Engineering

The newest Redgate Data Modeler feature is Reverse Engineering: a way to import an existing database into Redgate Data Modeler. The Reverse Engineering tool is a simple command-line Java application that you can download from our website. It connects to your database, reads the table and view details and stores… Read more

Previous Next

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 Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

How to Create a Database Model From Scratch

1000 users and growing strong!

Database Design 101: References

Code kata 1: Old money

WordPress Database Finally Unveiled!!!

Database Design 101: Tables, Columns, and Data Types

Designing a Database: Should a Primary Key Be Natural or Surrogate?

Database Design 101: What is a Database

Database Design 101: Database Model for an Online Store

How to import an existing database into Redgate Data Modeler: Reverse Engineering

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

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 Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Cookies on red-gate.com