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
Our v1 of the service is available now, and available for you to try. This initial version spins up an empty database and runs integrity checks. Later releases will enable the hosting of real clones of your near-production database. We’re not only trying to make automating migration testing as simple as possible, but by... Read more
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 Redgate 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 Redgate Data Modeler. Read more
Understand the similarities and differences between online transaction processing (OLTP) and online analytical processing (OLAP). Read more
Use Redgate Data Modeler to create and work with data models using SQL scripts. Read more
