No matter what you collect, you need to be able to organize (and trade, and swap) it! We look at a data model for collectors. Read more
Updated November 2018 You’ve no doubt heard at least something about the GDPR, the EU’s new privacy and Data Management law with its greatly increased maximum fines for non-compliance and tighter definitions for acceptable use of personal information. It came into effect in May 2018. If you’ve continued reading past paragraph one of any... Read more
Team sports are very popular, especially among kids and teens. In this article, we look at a data model that can help run a sports school. Read more
We’re excited to be part of Microsoft Ignite this year, in sunny Orlando, Florida. In Microsoft’s own words, this is the event where ‘The community of IT professionals comes together to transform your businesses’. It’s the perfect opportunity to learn about breaking announcements and plans, see the latest technology in action, and ask questions... Read more
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