Making SQL sense

+44 (0)20 3051 3595

Making SQL sense

+44 (0)20 3051 3595


We're looking for people who share our commitment to excellence in Microsoft's data platform to join us consultants working on exciting business intelligence, analytics, and SQL Server projects on-premises and in the cloud.

Coeo Blog

The Coeo Blog

Player harm and technological change – high stakes for operators as well as players?

In 2005, the Gambling Act came into force, designed to set out a legislative structure that included measures for player protection that could cope with modern electronic gambling. However, the increasing pace of technological change has led to concerns that this legislation has fallen behind..

Working with Technical Debt

As someone who has worked with many clients across many industries one of the common problems I see is companies who are finding it hard to juggle all the adhoc requests that come in to their data team. Report requests, data modifications, minor deployments, fixes or query performance tuning; no..

Using "With (nolock)"? Read this

Anyone that's worked with SQL for any length of time will undoubtedly have seen and heard the following

Cyber Security Monthly News - February 2018

During February, we’ve seen the tech industry warn ministers not to drop EU data laws when Brexit eventually kicks in. We’ve seen the biggest ever DDoS attack, and we’ve seen a robot autonomously open a door while giving us flash backs to one of the more recent Black Mirror episodes (for those..

SQL Agent history - A most confusing dialog box

On a new installation of a SQL Server instance, by default, SQL Agent will automatically manage the job history retention, however this may not work the way you expect it to. This post explains why, and how you should set this up for best results.

First Fix and Second Fix

When DBAs are troubleshooting issues, solutions are sometimes applied in the heat of a critical incident which solve the problem, which are then walked away from because the issue has been “fixed”. With experience and a better understanding of the broader issue of long-term solutions, you..

The (real) difference between the 'SELECT ... INTO' and 'INSERT ... SELECT' statements

In this blog post I will explore the difference between the ‘SELECT … INTO’ and ‘INSERT … SELECT’ statements. I recently moved some data for a customer to a brand-new table due to the bad design of the source table. First, I created the destination table and then I ran the ‘INSERT … SELECT’..

Understanding COPY_ONLY backups

When you have a database which has just been created and is in the FULL recovery model, or you have an existing database you are changing from SIMPLE to FULL, you need to take a full backup before you are able to take log backups, as there needs to be a starting point for the log chain. There is a..

What happens when TempDB grows?

The TempDB database is special in many ways, but an interesting aspect is that when its files automatically grow when they become full, this growth is not persisted and will be undone on the next restart of the SQL Server service. We can see how this works by looking at two system tables:..

Public Speaking - My Favourite Nightmare

Speaking at events isn’t something that comes naturally to me and I think many people who work in the tech industry find computers easier to interact with than humans. Nevertheless, I think public speaking is a really worthwhile skill; whether to small groups or large conferences it’s important..