Nullable columns should not be overused. Learn why in this article. Read more
Last week, Redgate’s Steve Jones sat down with Troy Hunt to talk about all things security and compliance, which Redgate surveys have found is the biggest concern among IT professionals this year. Troy is a Microsoft Regional Director and MVP, Pluralsight author and world-renowned web security specialist. He spends his time teaching developers how... 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
Check out our updated post about our latest cloning technology, Redgate Clone, and learn how you can get involved. Building on the success of SQL Clone in delivering on-demand SQL Server databases for dev, test and CI, we’re working on adding support for Oracle, PostgreSQL, and MySQL databases too. As we launch our technical beta, we would like to invite you... 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
Use Vertabelo to create and work with data models using SQL scripts. Read more
Find out which data type should be used for money values in SQL! Read more
The sooner you adopt data modeling for working with your databases, the more time you save in your everyday tasks. Read more
