Redgate Blog

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
Geoff Bones

Geoff Bones

24 February 2014

Geoff Bones

Geoff Bones

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

Code Katas

deliberate practice