Redgate Blog

14 April 2016

The Star Schema

Today, reports and analytics are almost as important as core business. Reports can be built out of your live data; often this approach will do the trick for small- and medium-sized companies without lots of data. But when things get bigger – or the amount of data starts increasing dramatically… Read more

David Atkinson

7 April 2016

David Atkinson

7 April 2016

We now offer free community editions of our MySQL tools

In the open source world, there’s an increasing trend to offer personal or community editions of paid-for tools. There’s a damn good reason too. Many charities and educational institutions as well as individual users turn to open source software in an effort to lower costs. The flipside is, while there’s… Read more

6 April 2016

6 April 2016

How to Embed Your Database Model Into a Website

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

Mark Champion

5 April 2016

Mark Champion

5 April 2016

Redgate Monitor v5.1 – is it a big deal?

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

Redgate Monitor

Redgate Data Modeler

5 April 2016

Redgate Data Modeler

5 April 2016

Using Configuration Tables to Define the Actual Workflow

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

Redgate Data Modeler

31 March 2016

Redgate Data Modeler

31 March 2016

Crow’s Foot Notation

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

Kathryn Lye

29 March 2016

Kathryn Lye

29 March 2016

A simpler, faster way of moving between products in the SQL Toolbelt

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

SQL Toolbelt

Redgate Data Modeler

24 March 2016

Redgate Data Modeler

24 March 2016

Crow’s Foot Notation in Redgate Data Modeler

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

Redgate Data Modeler

17 March 2016

Redgate Data Modeler

17 March 2016

Denormalization: When, Why, and How

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

Redgate Data Modeler

15 March 2016

Redgate Data Modeler

15 March 2016

Using Workflow Patterns to Manage the State of Any Entity

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

Previous Next

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

The Star Schema

We now offer free community editions of our MySQL tools

How to Embed Your Database Model Into a Website

Redgate Monitor v5.1 – is it a big deal?

Using Configuration Tables to Define the Actual Workflow

Crow’s Foot Notation

A simpler, faster way of moving between products in the SQL Toolbelt

Crow’s Foot Notation in Redgate Data Modeler

Denormalization: When, Why, and How

Using Workflow Patterns to Manage the State of Any Entity

2025 Stand der Datenbank-Landschaft

Einführung in PostgreSQL für den Datenprofi

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Cookies on red-gate.com