Making SQL sense

+44 (0)20 3051 3595 info@coeo.com
coeoClose

Making SQL sense

+44 (0)20 3051 3595 info@coeo.com

Careers

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

Free extended security updates for SQL Server 2008

As its tenth birthday approaches, Microsoft prepares to end extended support for SQL Server 2008 and 2008 R2. This date has been known since product launch, there are now less than 12 months to retire or replace aging SQL Server estates. In the past, when we hit extended support end date, that's..

Servers – Pets, Cattle – mince?

Pet servers are those servers you named, nurtured (loved?). Cattle servers are disposable, numbers only. When they are sick they are “…taken out back, shot, and replaced…”. Containers offer a new way to think about the services we’re delivering – processing our cattle-like servers into something..

Who unscheduled my agent jobs?

Introduction

Due to the large number of different SQL Server instances (and versions) we support, we get the luxury of seeing unusual behaviour more often than most. Something I’ve seen three times now is a curious issue with the SQL Server Agent on SQL 2016 CU5 which rarely crops up following a..

Cyber Security Monthly News – June Summary 2018

While it's been a relatively quiet month in terms of security news, a number of Windows updates have been released, and we have a cumulative update for SQL Server 2014 and 2017. Full details can be found below:

Installing SQL Server 2016 on Windows Server 2012 R2 (the KB2919355 issue)

While performing an in-place SQL Server upgrade for a customer, I came across the KB2919355 issue. This article will show you how to resolve this this problem and point out why this can be misleading.

Cyber Security Monthly News – May Summary 2018

This month has all been about the General Data Protection (GDPR) deadline which came into effect on the 25th May and is why you are likely being bombarded by every company you ever gave a shred of personal information to asking you to review their terms and conditions.

How removing intermediaries improves the ecommerce supply chain

Online retail can involve very long processes leading to the customer, but what if the supply chain could be shorter, and the process leaner?

This article examines how disintermediation — the process of removing intermediaries from the supply chain — can impact online retail.

RDP broken due to Windows Update - and how to fix it

In the past couple of weeks, following the recent Windows update CVE-2018-0886, we have had multiple occurrences of  ourselves and our customers having issues connecting to some of their servers via Remote Desktop Protocol (RDP). When trying to RDP to certain servers, we are presented with the..

Get DRY with Power BI

Save yourself time working with Power BI.

BACKUP LOG was unable to log updates for database in SQL Server 2016

If you’re running SQL Server 2016, you may want to install SQL Server Service Pack 1, CU8. I came across an issue recently that effectively caused the transaction log backups to hang. Through our proactive monitoring, we were alerted to the fact that a log backup had not been taken in 4 hours...