Redgate Blog

7 December 2021

What Are Facts and Dimensions in a Data Warehouse?

Facts in data warehousing are the events to be recorded, and dimensions are the characteristics that define those events. Read more

Redgate Data Modeler

4 December 2021

Redgate Data Modeler

4 December 2021

How to Work With Historical Data: Log Data Changes

Learn how to store active and historical records. Read more

Redgate Data Modeler

2 December 2021

Redgate Data Modeler

2 December 2021

What Is a Database Modeling Tool?

What features should you expect in a database modelling tool? We discuss the must-haves and nice-to-haves in any data modeling program. Read more

Ellie Buckle

2 December 2021

Ellie Buckle

2 December 2021

7 Trends in Database DevOps & Monitoring – Download the infographic

Earlier this year, we surveyed over 5,700 global IT professionals and asked them what the most pressing challenges they faced in Database DevOps and Monitoring are. We also asked specific questions to gauge what trends we could spot in the industry and compared the responses to the last 3-5 years… Read more

Redgate Data Modeler

30 November 2021

Redgate Data Modeler

30 November 2021

What Is a Foreign Key?

What is a foreign key? Why is it important? Find out all about foreign keys in this article. Read more

Redgate Data Modeler

27 November 2021

Redgate Data Modeler

27 November 2021

How to Work With Historical Data: Use Separate Tables for Active and Historical Data

Learn how to store active and historical records. Read more

Redgate Data Modeler

25 November 2021

Redgate Data Modeler

25 November 2021

What Are Document Types in Redgate Data Modeler?

Create logical data model documents, physical data model documents, and SQL script documents using Redgate Data Modeler. Read more

Redgate Data Modeler

23 November 2021

Redgate Data Modeler

23 November 2021

What Does Cardinality Mean in a Database?

Radu loves SQL and anything data-related. He works as a full-time data engineer; in his spare time, he likes to put his data to work by building data pipelines and training machine learning models to predict the best time of the day for him to drink his coffee. He also… Read more

Redgate Data Modeler

20 November 2021

Redgate Data Modeler

20 November 2021