How do you organize your entity relationship diagram (ERD)? Vertabelo can help you effectively organize your ERD for better readability and discovery. Read more
When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, pretty quickly, you are going to come to the question that’s the title of this post: Who is responsible for building tests? I have two flippant answers... Read more
When I first started trying to figure out how to automate database deployments, over 15 years ago, I will freely admit, I was both skeptical and reluctant. I had to be dragged up to the notion that automating getting the database code out the door wasn’t just an excuse by the developers to find... Read more
This article presents the most common database constraints in SQL along with examples. We show how to easily define and use them in the Vertabelo data modeler. Read more
Almost every time I teach a class on DevOps, one of the questions that comes up is: How do we do code reviews in this automated process? There are actually a number of answers to this question. Let’s walk through a few. Source Control If you’re automating your deployments, I don’t think I’m going... Read more
Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve already done the hard part, making the decision to shift the culture. Now, what’s involved is just lots of labor. There are three things you can do to begin your Database DevOps journey: Get your database into... Read more
Cardinality is a vital concept to understand and implement. Learn about the role it plays in defining the entity relationships in an ER diagram. Read more