I have a lot of experience working in financial services and I’ve recently been talking to Database Administrators (DBAs) who work in the sector. Unsurprisingly, perhaps, deploying database changes is the most taxing part of their job. They’re often required to review thousands of lines of script and it can take days, depending on... Read more
In order to optimize the value of any website, information about the number of site visitors and their user behaviors is needed. There are a few tools which, with just a few minor changes to your site, will actually do this work for you, the most popular such tool is Google Analytics. While this... Read more
SQL Server 2017 officially landed today and is now on general release. The latest version of the heavyweight platform is more than the sum of its parts, however, because it doesn’t just deliver new functionality. Alongside the list of extra features, it also changes two important ways we think about the platform itself. Time... Read more
DevOps is gaining ground everywhere. By offering a route to releasing software faster, with fewer errors, it can give companies which adopt it an immediate advantage. Unfortunately, it’s not something you can just buy or decide to do tomorrow. Instead, it’s a shift that needs the right guidance to become reality. But while there... Read more
Most of us are familiar with the apartment rental process. But what does it take to run a leasing office? In this article, we look at a data model designed to do just that. Read more
When SQL Server 2017 launched, Microsoft proudly announced that it was the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. In the future, database servers running its software won’t just be able to store, query, and analyse data. Instead, they’ll also be able to perform machine learning, natural language, and neural... Read more
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
