Did you know that you can embed your Redgate Data Modeler model in your website? If you haven’t tried this yet, now’s your chance – we’ve recently improved the process. It’s an excellent way to share ideas with readers or make projects available to co-workers. Read more
The simple answer is yes, yes, and, um … yes! While on the surface it may look like nothing much has changed in v5.1 of Redgate Monitor, in reality we’ve completely overhauled the core engine to make it more scalable, stable, and smarter. The latest version is the culmination of all the minor releases... Read more
The first part of this series introduced some basic steps for managing the lifecycle of any entity in a database. Our second and final part will show you how to define the actual workflow using additional configuration tables. This is where the user is presented with allowable options each step of the way. We’ll... Read more
The most recognizable characteristic of crow’s foot notation (also known as IE notation) is that it uses graphical symbols to indicate the ‘many’ side of the relationship. The three-pronged ‘many’ symbol is also how this widely-used notation style got its name. Let’s see where crow’s foot is placed in the history of data modeling... Read more
We’ve recently made a coordinated effort at Redgate to apply a common design to everything we do. You may well have noticed the subsequent changes to our website, the evolution of our product logos, or seen the results in images used at our events. Last week we extended the approach further by releasing a bunch... Read more
Various ERD notations follow different styles for entities, relationships, and attributes. Usually there isn’t much standardization between them, so notations bear little resemblance to each other. Among the plethora of ERD diagram notations, crow’s foot notation is definitely the most used. In this article, we’ll investigate its components within the Redgate Data Modeler database... Read more
What can you do if your data model was done by the book but you still have to improve performance? In that case, denormalization is a technique that should be considered. In this article, we’ll discuss the benefits and disadvantages of denormalization and what situations may warrant it. Read more
Have you ever come across a situation where you need to manage the state of an entity that changes over time? There are many examples out there. Let’s start with an easy one: merging customer records. Read more
People like to play. So we invented games and placed them on boards. And then computers came. Now we can play against the computer or against human opponents all over the world – or right next to us.
Read more
This is the third of our multi-part series on applying information security approaches to data modeling. The series uses a simple data model, something to manage social clubs and interest groups, to provide the content we look to secure. Later we will address modeling for authorization and user management, as well as... Read more
