Posts by
Redgate Data Modeler
Online or desktop ERD tool? Read on and choose the one best suited for your organization. Read more
A curated list of the best and most up-to-date data modeling books you can find in bookstores. Read more
Learn some good practices for using char columns in SQL! Read more
A foreign key is one of the building blocks of relational databases. Check out this article to find out how to define a foreign key in a physical model. Read more
You may be the best data modeler in town – but if you don’t use proper database documentation on your decisions, your work will not shine. Read more
Nullable columns should not be overused. Learn why in this article. Read more
A case study of migrating an analytical system migration from PostgreSQL to AWS Redshift using the Vertabelo data modeler. Read more
We present a practical example of how to normalize a table that is in the first normal form (1NF) into a set of tables in the third normal form (3NF). Read more
In a relational database, each table should have a primary key. Discover why and how to set a primary key in Vertabelo. Read more
Understand the similarities and differences between online transaction processing (OLTP) and online analytical processing (OLAP). Read more
Redgate Data Modeler