In the first two parts of this series we have installed SuiteCRM locally, imported its model into the Vertabelo database, and created relationships based on assumptions. In Part 3 we took a closer look at the most important parts of the CRM, how to use them, and how the data is stored in the... Read more
Visiting a hospital or a clinic is never a pleasant situation. But it would be even worse if nothing was automated. Not so long time ago almost all documents were in a paper form. That not only polluted the environment but slowed down a process a lot. In some cases, patients should take care... Read more
In this post, we imagine how auto-classification of data can be used to build better documentation that helps you trust that your organization can use data without posing a risk or compromising regulatory compliance. You may have read recently about how we’ve spent the last month exploring the theme of data classification in Foundry,... Read more
City-building and management games have been very popular for decades. If you were to build your own city management game, what kind of data model would you need to run it? Let’s find out. Read more
Not too long ago I was assisting a client with an issue they were experiencing while running some compliance software to check for sensitive data. Sensitive data was picked up in the SQL Server data file but when the DBAs checked, the data was nowhere to be found in the database. It’s fairly widely... Read more
Knowing a foreign language is an important skill, especially in a global economy. In this article, we look at a data model that can help run a language school. Read more
SQL Data Mask is the latest prototype to come out of Foundry, Redgate’s research and development division. It copies your database while anonymizing personal data. You can use it to mask your databases right now, free of charge, so download the latest on-premises version. We’re working closely with a select group of people who... Read more
Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible. This was true for our SQL Source Control team when I started working with them. From pushing a commit to getting a complete set of tests took almost 12 hours. Then you had to rerun the raft of tests that sometimes... Read more
Vertabelo’s new SQL Script tool lets you write and save SQL scripts and run them against a connected database. Read more
In this three-part series, guest bloggers from DevOpsGroup look at the real role of Ops in DevOps. Where it changes, how it changes, and why Ops has an important part to play in the brave new world of DevOps. The top ten DevOps operational requirements One of the key tenets in DevOps is to... Read more
