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..

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.

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...

Is this the end of SQL Server Failover Cluster Instances?

One of the common customer queries we get at Coeo is how to provide high availability for SQL Server. I have been advocating the use of SQL Server Failover Cluster Instances (FCI) to provide high availability for over 10 years. However, during a review of our reference architecture the question..

Simplifying key management in SQL Server by using Azure Key Vault

Implementing Transparent Data Encryption (TDE), Backup Encryption, Always Encrypted, Symmetric key and Asymmetric keys all require that a final secret is stored at some point which protects the encryption key(s) used to secure the data. The main difference between a symmetric and asymmetric key..

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

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.