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

Make your Azure automation more flexible

Hi everyone! I’m Chris and I’ve recently joined Coeo as a Cloud Consultant. I specialise in helping customers looking towards the cloud with all aspects of Azure cloud adoption and usage..

I’m quite a fan of automation when it comes to Azure. Automating the build of your environments in Azure has..

Cyber Security Update - September 2017

New Servicing Model for SQL Server

Last week, following the confirmation of SQL Server 2017 being generally available on Oct 2nd, Microsoft announced a major change to the way they will be releasing updates in future. They will no longer be producing Service Packs, instead relying on regular..

Azure updates from Ignite 2017

Keeping up with the pace of the Azure cloud evolution is tough at the best of times. Just when you think you are getting on top of it, Ignite comes along and Microsoft drop a cluster of feature bombs which means you spend most of your Saturday updating your Visio architecture diagrams. Thanks a..

SQL Saturday Cambridge 2017

The latest SQL and SharePoint Saturday Cambridge took place on 9th September 2017, organised by Mark Broadbent. It was a huge success with a good turnout of very engaged delegates and interesting and entertaining speakers in a great venue. We were delighted to support the event as a sponsor and I..

Cyber Security Monthly News – August 2017

August brings us patches for 48 vulnerabilities contained within Windows, Hyper-V, Sharepoint, Internet Explorer and notably fixes for 28 Microsoft Edge vulnerabilities and for the Flash Player ADV170010 advisory. This addresses vulnerabilities that Adobe classify as "Priority 1" as they can lead..

How to prevent Robocopy from hiding your files and how to fix it when it does

I recently had a scary moment at a customer when I was testing to see how long it would take to copy a data file between two of their disks using Robocopy and an old and relatively small backup file. If you haven't heard of Robocopy, then you should look into it as a command line (cmd) tool for..

Corruption detected when attaching/restoring master database

Recently, while working with a customer to help restore their SQL services, I came across an issue I hadn’t seen before and more interestingly, one where little information can be found within the community.

Backing up your databases in Microsoft Azure

Configuring scheduled database backups has always been an important activity for database professionals.  As we transition our SQL Server workloads into Microsoft Azure Infrastructure-as-a-Service (IaaS), we now have a number of options available for backing up databases which at first glance can..

Cyber Security Monthly News – July 2017

July has brought some exciting news to the SQL Server community and, at the same time, Microsoft has released a bunch of security updates for Windows that will help in keeping our environments protected from malware vulnerabilities. See below the latest SQL Server and Windows updates along with..

Watching out for SELECT * with UNION ALL

UNION ALL returning incorrect results? I recently came across an interesting behaviour when executing queries that included a UNION ALL statement, the examples below were created using SQL Server 2016 Service Pack 1.