Redgate Blog

31 July 2014

ERD Notations in Data Modeling

An entity relationship diagram (ERD) is a diagram that defines the structure of database instances. Choosing which notation to use is typically left up to personal preference or conventions. Here, you can find some useful information about each notation. Read more

Redgate Data Modeler

28 July 2014

Redgate Data Modeler

28 July 2014

How to Model Inheritance in a Relational Database

In the process of designing our entity relationship diagram for a database, we may find that attributes of two or more entities overlap. In this case, we may create a subtype of the parent entity that contains distinct attributes and supertype entity. The article presents how to model inheritance and what are the... Read more

Chris Smith

21 July 2014

Chris Smith

21 July 2014

Five steps to an effective sprint retrospective

In a typical agile software development process, sprint retrospectives are meetings run at the end a development iteration. In those sessions the team looks back on what they have done and how they have done it, and decides what they can do to improve. More succinctly, the team inspect and adapt. In my experience,... Read more

agile software development

retrospectives

Geoff Bones

18 July 2014

Geoff Bones

18 July 2014

Code kata 7: Producer-consumer problem

First, apologies for nodding off and not posting for the last few weeks. I have the usual set of excuses, which you can guess easily enough without the need to read them here. So, on to the kata: something a bit different, this time. It’s a repeat of a kata we had a go... Read more

Code Katas

Redgate Data Modeler

15 July 2014

Redgate Data Modeler

15 July 2014

How do I create a company account ?

If you need many accounts for your employees and don't want to pay for each account separately, create Vertabelo company account. A company account enables model sharing, inviting people, working on a model at the same time, and paying for group of workers. Read more

Redgate Data Modeler

15 July 2014

Redgate Data Modeler

15 July 2014

N-ary relationship types

When we design a database, we draw an entity relationship diagram (ERD). It helps us understand what kind of information we want to store and what kind of relationships there are. It is imperative that this diagram is easy to read and understand. The number of entities in a relationship is the arity of this... Read more

Redgate Data Modeler

15 July 2014

Redgate Data Modeler

15 July 2014

How do I pay for a company account after the trial period ends ?

If your 14 days company account trial period is going to end and you want to continue using the company account, there is an easy way to set up a monthly subscription for the appropiate number of users. Read more

Emma Armstrong

27 May 2014

Emma Armstrong

27 May 2014

Take security in your STRIDE

When you phone up for house insurance, the insurance company asks you; ”Do you have a five lever mortice deadlock? Does it comply to BS3621? Do you have a burglar alarm and so on? These are all very standard questions for this situation, and we need to make sure we are asking similar questions... Read more

Learn on the Loo

Geoff Bones

24 April 2014

Geoff Bones

24 April 2014

Code kata 6: The classic bowling game scorer, open and closed

The kata Following on from last time, this is based on Uncle Bob’s now-famous bowling game kata, with the added spice of adhering to the open-closed principle of SOLID. The kata is well-documented online, but briefly, the idea is to write a program that takes in a series of scores for each ball a... Read more

10 April 2014

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 code. Use TDD, but... Read more

Code Katas

SOLID

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

ERD Notations in Data Modeling

How to Model Inheritance in a Relational Database

Five steps to an effective sprint retrospective

Code kata 7: Producer-consumer problem

How do I create a company account ?

N-ary relationship types

How do I pay for a company account after the trial period ends ?

Take security in your STRIDE

Code kata 6: The classic bowling game scorer, open and closed

Code kata 5: SOLID chess

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional