Voice of the DBA

Tag: Redgate

Changing the Cardinality of a FK in Redgate Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this easy, and this post will show you how.

This is part of a series on Redgate Data Modeler.

Altering a Constraint

In a previous post, I looked at adding a FK. Let’s do things a little differently here. Let’s change a constraint to better reflect the relationships between entities. In this case, let’s look at a part of my model. I have the User and Author entities linked as shown below. Note that we have a User with a 1:many relationship to Author.

This isn’t correct. A User cannot be a part of multiple authors. This is, logically, a 1:1 relationship. Each Author is related to one and only one User. Each User can be an author, but only one Author. So let’s fix this.

If I click on the relationship, it turns blue and highlights.

On the right side, the properties pane displays the relationship properties. Note that there is a relationship type below the comment.

If I click the drop down, I can change this to whatever cardinality makes sense.

I’ll choose one to one. When I do that, I can see the diagram changes.

I can also change this for other entities. Here I have a One to Many, but this is really a many to many relationship. So I need to change it.

I can adjust the properties in the drop down and you can see both the diagram and the right properties pane match.

Summary

We may model our entities incorrectly, either because of incomplete information or simple mistakes. In any case, if you need to change cardinality in a relationship, it’s easy to do in the relationship properties.

Give Redgate Data Modeler a try and see if it helps you and your team get a handle on your database.

Video Walkthrough

Here’s a short video of my working with Redgate Data Modeler and changing cardinality.

April 13, 2026
Monday Monitor Tips: A New Analysis Page

We have multiple teams (8) working on Redgate Monitor. Some work on the Standard Edition, a few on the Enterprise Edition, and others handling core work, like the Linux/PostgreSQL option.

We also have designers, and they regularly research how well the product works for customers, what is difficult, and they propose changes. One of them was recently release. We have a new analysis page in Redgate Monitor and this post looks at the changes.

Video walk-through of this post below.

This is part of a series of posts on Redgate Monitor. Click to see the other posts.

The New Experience

If you go to monitor.red-gate.com, you can see this at: https://monitor.red-gate.com/Analysis. This shows the new analysis graph, which is easier to see and takes up the entire screen.

If you haven’t used this, I’ve added metrics below this for certain servers. You can see in the legend that I’m looking at CPU time along with batch requests for both sides of my cluster. I can compare these to see if the number of batches is impacting CPU. A correlation I might use to research how a workload affects my system.

If I put my cursor over the graph, I can get info on the metric, the current time and the value/min/mean/max. These values are for the time period.

If I change my time period, I see the values change for the stats.

Below this, for the metrics, it’s a little cleaner as well. The interface hasn’t changed a lot, but it’s a little larger and spread out. I can see that I pick a metric for a cluster, and then for a machine. This is the same.

What has changed is the “add a metric” is now at the top on the side. If I click this, I get a new set of metrics to pick below this. Note the “same as above” for the cluster, which is very handy. I can also type in the box to search.

At the right, the explanation of the metrics and statistics are still on the far right.

This makes an interesting experience that works smoother to ensure that

The Classic Experience

If you don’t like this, there’s a link in the upper right to switch back.

Clicking this loses my metrics, but if I add them back, you can see the old view. It’s a little less appealing to me. The other thing I hated is that the “add a metric” is below the list shown below, which is annoying. I often scroll down to find it.

I also have statistics which only show one of the metrics (first one?) and not both. I’m also missing stats of the average.

Summary

This is a small change, but a nice one, IMHO. The ease with which the UX is designed can make a big difference to how users can interact with the data. This is a small one, but one that I really appreciated.

If you have feedback in general, please let us know as we value your opinions and comments on how we shape the future of Redgate Monitor.

Redgate Monitor is a world class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.

Video Walk-through

Video of this post below.

April 6, 2026
The Book of Redgate: No Politics

In today’s world, this might mean something different, but in 2010, we had this value:

In our context, this was about being open and transparent. This is the text from the facing page:

No gossiping, no intrigue, no pussy-footing around problems and no telling people what you think they want to hear whist privately disagreeing. We will be transparent in our dealings.

In a small company (2010 must have been 200-ish people), this made a lot of sense and I think overall we minimized politics. I don’t know this will ever be a “no politics” world for Redgate or any other, but we were better about publicly disagreeing.

I think we’ve lost a little of this over the years, as I see more people talking a bit inconsistently to smaller, private groups than they do to large ones. I try hard not to do this, though I’m sure my open-ness sometimes rubs people the wrong way.

I’m OK with some conflict. I’m also OK debating and disagreeing about what we do or why/how we do things. I think it’s healthy to do so.

I have a copy of the Book of Redgate from 2010. This was a book we produced internally about the company after 10 years in existence. At that time, I’d been there for about 3 years, and it was interesting to learn a some things about the company. This series of posts looks back at the Book of Redgate 15 years later.

March 27, 2026
The 2026 Redgate Summit in New York City

We’re coming back to New York, which is exciting for me. I love NYC.

The Redgate Summit 2026 – New York City comes back on May 5, 2026. You can register today and I’ll see you back in Manhattan the first week of May. Once again Bob Ward is giving the closing keynote, with me and fellow Redgater’s giving the opening one.

We’ll have three tracks, but I’ll be hosting a session with one of our customers, so you can hear how and why Redgate Monitor helps them out and what it’s like to work with Redgate. We did this in Chicago, and there were some great questions from the audience.

We’ve chosen customers who have had good experiences, but feel free to ask them anything about how Redgate Monitor works and how we are as a vendor. I’m certainly proud of how we partner with customers, so come get a first-hand view from a large financial services organization.

New York City is such an amazing place, and we’ll have a drinks reception after, but there is lots to do. I’ll be bringing my wife and we’ll likely go see a Broadway or comedy show the night before. You should do the same.

We also have a Redgate track and an AI one, so this is a great chance to see how Redgate views the world and how we’re approaching building software that helps you become more efficient inside your organization.

Register for the Redgate Summit 2026 – New York City and I’ll see you in May.

March 25, 2026