This article discusses choosing the right database modeling tools, ER diagrams, and data models to meet your needs. Read more
Create good logical, physical, and conceptual data models using these expert database model preparation tips. Read more
An interesting question came up at the Redgate Summit a few weeks ago: What approach do you take to maintain database releases/changes in-flight that haven’t been applied to Production after them being wiped out after a database refresh? I have to assume that the person asking this question has not taken even the first... Read more
In 2020, Deloitte reported on The four trends that define insurance and showed that the future of the insurance marketplace is going to be significantly different. Life and Property and Casualty insurers, for example, estimated that 93% of their volume already came from propositions that were not offered five years ago. New propositions were... Read more
There are tons of books on data modeling and design, but don’t be overwhelmed. We’ll show you the right one for you. Read more
This article presents PostgreSQL’s database constraints. Discover additional functionalities for your Postgres database! Read more
Flyway can validate your migrations according to its own conventions, giving you the confidence you need to apply new migrations. However, as the lifetime of a project increases, there will inevitably be hotfixes, deleted migrations and other changes that break the conventions of Flyway’s validation. In these cases you need a way to tell... Read more
Live model validation is a special feature of Vertabelo’s online database modeler that checks for potential problems in your diagram. Read more
“It worked on my machine“. You’ve likely either heard this from a colleague or thought this yourself when a Flyway migration failed during a production deployment. The fact is that unfortunately, bad migrations slip through to the release process despite our best efforts. Thankfully, there are solutions to this – testing your Flyway migrations... Read more
The ultimate goal for automating deployments can be the hands-free deployment of all code, including the database, from development to production. However, for many of us, the complete automation of all deployments with zero manual intervention will always remain a goal. We may have systems that are simply too complex for a 100% automated... Read more
