Sooner or later there comes a moment when database performance is no longer satisfactory. One of the very first things you should turn to when that happens is database indexing. This article will give you a general overview on what indexes are without digging into too much detail. Read more
I’m a project manager, so unsurprisingly I can find myself in animated conversations with other project managers regarding how best to manage the work that our team members are doing. We all have our favourite techniques and methods, but the process generally starts with making the work each member of the team is planning... Read more
In this article, I will try to compare two database modelers: Vertabelo and Sea Quail Database Diagram Tool. Here is a matrix of each tool’s key features and functionality. Read more
Vertabelo internally stores your model in an XML format. You can download the XML file and use it to extract some information by using a script. Let’s take a look at the structure of this XML file. Read more
Sssshhh. There’s a revolution going on. Quietly, purposefully, and without fanfare, Database Lifecycle Management is looming on the horizon for every developer and DBA. A continuous, agile-based approach to integrating, coordinating and managing the different phases of database delivery. Whoah, there. Database Lifecycle Management? Application Lifecycle Management, yes, but how on earth can you... Read more
We’ve been working on a new product that involves writing Windows PowerShell cmdlets (pronounced “commandlets”) for our customers to use and, to make their lives easy, we want to provide rich built-in help documentation. There’s no easy way to do this out of the box, so I’ve written a tool that allows us to... Read more
The Vertabelo journey continues … We now have almost 10,000 users and the number of Vertabelo advocates keeps growing strong.
Vertabelo users come from over 100 countries and speak various languages. What unites them?
The relational database. Read more
Sometimes you don't want the reverse engineering tool to extract all of the tables in your database. For example, the database may contain technical tables which are logically are not part of the model. This is when the -regexp option comes in handy.
Read more
The “extended” UX team sharpening their swords… At Redgate, our software engineers run regular “code katas”, workshops where developers practise their coding skills on simple problems, then discuss the experience afterwards as a learning exercise. So, a while ago, I thought it might be a good idea to use the same Kata principle on... Read more
UML is popular for its notations. We all know that UML is for visualizing, specifying, and documenting the components of software and non software systems. What's more, UML has many types of diagrams which are divided into two categories. Some types represent structural information, others general types of behavior. Among these, there is one... Read more