Redgate Blog

10 April 2014

Database Design 101: How to Start Creating a Database Model

In this video you will learn how to start creating your database model. You will find out why nouns are important and how you should handle them when creating a database model. Read more

Redgate Data Modeler

3 April 2014

Redgate Data Modeler

3 April 2014

The Boyce-Codd Normal Form (BCNF)

Why do you need all of this normalization stuff? The main goal is to avoid redundancy in your data. Redundancy can lead to various anomalies when you modify your data. Every fact should be stored only once and you should know where to look for each fact. The normalization process brings order to your... Read more

Redgate Data Modeler

1 April 2014

Redgate Data Modeler

1 April 2014

New Feature: Photo Reverse Engineering

We're happy to announce that Vertabelo has a new feature we've been working on for some time: Photo Reverse Engineering. This is the quickest way to transfer your hand-written design sketches into Vertabelo. Draw your model on a piece of paper, a whiteboard, or a blackbord, take a photo, upload it into Vertabelo and... Read more

Redgate Data Modeler

28 March 2014

Redgate Data Modeler

28 March 2014

SQL Performance Explained – the must-read book

Some time ago, the Vertabelo Team participated in the PostgreSQL Conference Europe 2013. Some of the talks were really nice. One of them stuck in my head for quite a long time. It was Markus Winand's lecture titled "Indexes: The neglected performance all-rounder." Although I had had a solid background in databases, this 50... Read more

Geoff Bones

19 March 2014

Geoff Bones

19 March 2014

Code kata 4: Word ladder

Naming things can be very hard, yet a well-chosen name can really help a reader understand how your code works. This code kata is an old favorite, one that we’ve done before, but this time we’ve added an emphasis on naming things well. The kata A word ladder is a sequence of words (each... Read more

Code Katas

Redgate Data Modeler

13 March 2014

Redgate Data Modeler

13 March 2014

On Keys

Today we continue our series of posts on data normalization. In the previous post on data normalization I explained what functional dependency is. Today we will talk about candidate keys in a table. Read more

Redgate Data Modeler

7 March 2014

Redgate Data Modeler

7 March 2014

On Functional Dependencies

Do you remember the ? I promised you we'd explain how to design tables which have no update anomalies. Today we begin a series of posts on data normalization. We will talk about functional dependencies, a concept that needs to be explained before we dive deeply into database schema normalization. The subject is rather abstract... Read more

Redgate Data Modeler

28 February 2014

Redgate Data Modeler

28 February 2014

Update Anomalies

In this article I will show you an example of the table that looks correct at first glance but when you try to modify data in it, several anomalies can occur. We'll discuss insert anomalies, update anomalies and delete anomalies. Read more

Geoff Bones

24 February 2014

Geoff Bones

24 February 2014

Code kata 3: Refactoring

The kata This kata was inspired by a truly ugly piece of code we came across in Redgate Towers. It had a whole bouquet of code smells: long methods, a lot of indentation, static variables, inconsistent naming, code that was duplicated with small modifications, and a couple of small bugs. And, gloriously, it was... Read more

24 February 2014

24 February 2014

Code kata 2: Amaze me

The kata You are given a program which is capable of traversing 2D mazes. However, the solution isn’t perfect and fails to find the exit in certain types of mazes. Moreover, the current solution is messy, doesn’t follow any sensible coding principles (e.g. SOLID) and is completely untested. The input to the program is... Read more

Code Katas

deliberate practice

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 101: How to Start Creating a Database Model

The Boyce-Codd Normal Form (BCNF)

New Feature: Photo Reverse Engineering

SQL Performance Explained – the must-read book

Code kata 4: Word ladder

On Keys

On Functional Dependencies

Update Anomalies

Code kata 3: Refactoring

Code kata 2: Amaze me

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional