+44 (0)20 3051 3595 | info@coeo.com | Client portal login

The Coeo Blog

How to avoid a rabbit hole while troubleshooting SQL Server performance

Performance analysis can be a tricky landscape at the best of times and looking at the performance of your SQL Server is no different. An initial glance at your recent high CPU usage can often spiral into a lengthy investigation, deviating far from the initial investigation.

In this blog I aim..

Please wait your turn: A basic Introduction to Latches in SQL Server

Following on from my recent blog post on locking, a level deeper in the concurrency chain leads us to latches. A lot of people will have heard of them or will have seen the related waits within SQL, for example in the sys.dm_os_wait_stats DMV, but, I would wager, not many people could give me a..

A Basic Overview of Locks in SQL Server

We have all heard of locks and can probably even name a few; shared or exclusive locks, for example. We notice them more when something goes wrong and we run into blocking or other performance problems, but what are locks and how do they work in SQL Server?

In this blog, I aim to give a basic..

Configure Kerberos for Availability Groups

Today I want to tell you about an issue we ran into while working on one of our customers and, while it’s easy to understand when explained, it might be tricky to get done when you don’t look at the whole picture.

Five Cool Things You Can Do Using Partitioning

It’s been a while since I last wrote about my favourite piece of tech, which is not the latest neither sometimes the greatest, but we’ve been together for over a decade now and I still love it. That is the SQL Server engine.

Troubleshooting - stay C.A.L.M.

So, you're supporting a server. It might be yours directly, it might belong to a customer. Doesn't matter. You've got an urgent issue - an alert, a ticket, an end-user reporting a problem - and you need to get moving. Where do you start? Everyone has a method, and if you haven't developed yours..

A Consultant's guide to saving money on your Microsoft data platform

Amidst the COVID-19 pandemic, businesses have been forced to implement short-medium term plans to protect not only their ability to transact, but also the health and wellbeing of their customers, partners and employees.  Video calls, queueing at shops (and on websites) and home deliveries have..

The Dirty (Baker’s) Dozen of SQL Server Technical Debt

The Baker’s dozen originated from bakers adding the thirteenth loaf to avoid a beating for underselling bread. There will (hopefully?) be no such penalties for SQL Server indiscretions, but try to avoid adding technical debt to undersell your future happiness.

Killing Your SQL Server with Kindness

When you discover a poor, uncared for SQL Server instance that has been neglected for years, your immediate response is to get maintenance going and give it some love. Get it back to its former glory and running optimally.

But you need to approach this with caution.

An Ode to the DBA

It has been now quite a few years since I was sitting in school, being pleasantly bored by the works and sonnets of Shakespeare, and failing to grasp the meanings and intricate language he used. Now in hindsight, I realise that I just never understood (or tried to understand) some of the..

Back to top