DevOps has come a long way since it was first showcased in Flickr’s seminal ’10 deploys per day’ Velocity presentation in 2009. Just eight years later, it is being rapidly adopted and, as the 2017 State of DevOps Report from DORA and Puppet shows, there are big advantages for companies and organizations which embrace... Read more
No plot spoilers – just a data model based on the Game of Thrones TV series. Read more
Bidding sites are a popular way to buy and sell many products. In this post, we look at these online auctions from a buyer’s perspective. What does our data model need to handle the bidding process? Read more
If you’re doing DevOps differently for your database and the rest of your system, there’s something wrong. There shouldn’t be a separate conversation about it, says Microsoft’s Donovan Brown. When DevOps was first talked about in Flickr’s seminal ’10 deploys per day’ Velocity presentation in 2009, it was regarded by some as strange and... Read more
The download count of the tSQLt unit testing framework is surprisingly low, yet this outstanding open source software can revolutionize your SQL Server development process. Hopefully, this post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. This simple technique can have a profound effect... Read more
What goes into marketing a business? And what data model could a marketing agency use to run their organization? Read this article to find out! Read more
In the first two parts of this series we have installed SuiteCRM locally, imported its model into the Redgate Data Modeler 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... 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
