I work in computers and my son works in manufacturing, but both of us loathe a single phrase: We have always done it this way. Please allow me to be clear on this. If you can back up this statement with “Because…”, and you list out valid points, even if I disagree with them,... Read more
What is a shortcut table? This Vertabelo feature will help you better organize ER diagrams. Learn how to use shortcut tables effectively! Read more
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
Find out how to keep an eye on data model changes using Git as a source control management tool. 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
Here are the steps to a good database design and how to get the process right. 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
