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
Add references to your data models in Vertabelo in three easy steps. Read more
The Flyway team are proud to announce the latest update to Flyway, the world’s most popular migrations framework for database deployments. Flyway v8.0 introduces three main areas of improvement, alongside bug fixes and breaking changes. Cloud Capabilities With the latest update we’re bringing the benefits of Flyway migrations into cloud native environments, such as... Read more
Find out which data type should be used for money values in SQL! Read more