Redgate Blog

Geoff Bones

Geoff Bones

10 April 2014

Geoff Bones

Geoff Bones

10 April 2014

Code kata 5: SOLID chess

The kata Let’s get this clear: we’re not going to write a chess-playing AI in this kata. The idea is a bit more humble: to write a program that can work out valid moves for a set of chess pieces. The purpose of this kata is to practise writing SOLID… Read more

Code Katas

SOLID

Geoff Bones

Geoff Bones

19 March 2014

Geoff Bones

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… Read more

Code Katas

Redgate Data Modeler

Redgate Data Modeler

13 March 2014

Redgate Data Modeler

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

Redgate Data Modeler

7 March 2014

Redgate Data Modeler

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… Read more
Redgate Data Modeler

Redgate Data Modeler

28 February 2014

Redgate Data Modeler

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