Redgate Blog

8 October 2015

8 October 2015

An overview of Database Lifecycle Management

One of the ways in which many software development teams have tried to improve the quality of their output is by examining what has worked in other organizations and projects in the past. They look to experiment with new techniques and ideas, and implement those items that work. This practice has allowed Agile, Scrum,... Read more

Redgate Data Modeler

8 October 2015

Redgate Data Modeler

8 October 2015

Database Modeling Course (1)

Data modeling is an essential step in the process of creating any complex software. It helps developers understand the domain and organize their work accordingly. In this article, which begins a new series devoted to database modeling, we’ll try to convince you why you should include it in your projects and what it looks... Read more

Redgate Data Modeler

29 September 2015

Redgate Data Modeler

29 September 2015

A Unified View on Database Normal Forms: From the Boyce-Codd Normal Form to the Second Normal Form (2NF, 3NF, BCNF)

Normal forms for relations is a required topic of a database curriculum. Even if at some point you decide to abandon them, you should know what you are doing and how to pay a price for that. Read more

Redgate Data Modeler

24 September 2015

Redgate Data Modeler

24 September 2015

Modeling a Database for Recording Sales. Part 1

Storing sales data properly and later combining it can lead to creating a predictive model with a high rate of accuracy. This new series of articles analyzes a database design for recording sales, starting with a simple example of a database model for sales in a coffee shop. Read more

Redgate Data Modeler

22 September 2015

Redgate Data Modeler

22 September 2015

Tips for Better Database Design

A good database design can be created by following a few simple rules. Here is my subjective list of nine tips for better data modeling. Read more

Redgate Data Modeler

17 September 2015

Redgate Data Modeler

17 September 2015

What Is the Actual Definition of First Normal Form (1NF)?

The First Normal Form (1NF) is exceptional. The other normal forms (2NF, 3NF, BCNF) talk about functional dependencies and 1NF has nothing to do with functional dependencies. Moreover, we have precise definitions for other normal forms and there is no generally accepted definition of 1NF. Read more

Redgate Data Modeler

15 September 2015

Redgate Data Modeler

15 September 2015

Tackling Your Troubles – Building a Bug and Problem Database

Death and taxes – add “software problems” to that list of the inevitable. There is always a new issue, a new failure, a new key opportunity that an organization must address. And to avoid repeating the problems, or to revise your prior fixes, it is critical to capture the problems accurately and... Read more

14 September 2015

14 September 2015

Using PhantomJS to improve UI automated testing

Test automation is a major part of the testing effort conducted at Redgate, and all our teams work hard to continuously improve existing practices. In this post, I’ll describe one of the problems we faced – and our approach for solving it. Scenario: A set of UI automated tests with Selenium were not trustable.... Read more

Automated testing

Redgate Data Modeler

10 September 2015

Redgate Data Modeler

10 September 2015

Defining Identifying and Non-Identifying Relationships in Vertabelo

Various data modeling tools allow modelers to define relationships in a data model as identifying or non-identifying. We can define a relationship as identifying or non-identifying in Vertabelo as well. This article will explain the way to do so. Read more

Redgate Data Modeler

8 September 2015

Redgate Data Modeler

8 September 2015

Managing Roles and Statuses in a System

There are many ways to solve a problem, and that’s the case with administering roles and user statuses in software systems. In this article you’ll find a simple evolution of that idea as well some useful tips and code samples. Read more