The Coeo Blog

Enterprise IT getting easier to use is a good thing.  But we have understand why to benefit fully.

In-memory ColumnStore Indexes in SQL Server 2014 can be a performance game changer for workloads involving large datasets.  They can also significantly affect the amount of server resource needed to provide good query performance – but not always in the ways you’d expect.

Ever since cloud services appeared, we’ve heard about their different types: Platform as a Service, Infrastructure as a Service etc. While those terms help us understand a service’s capabilities – and traditional target audience – I wonder whether those terms have now been overtaken by the pace of..

Slow-Running Query Due To Optimizer Timeout

Working as a Principal DBA in Coeo’s Remote DBA Team, I’m occasionally asked to talk to a prospective customer about how our team operates and to give them a technical overview of Coeo’s Remote DBA service. I’m often struck by how pleasantly surprised they are with what they hear about how we..

In my previous post I discussed an instance where SCOM was failing to monitor the space of a SQL Server database.  In this latest post I want to bring to light an issue that was altogether more serious.

I particularly wanted to write this post because, although there are a number of possible reasons..

Over the last few weeks I’ve started writing guest blog articles for the TechNet UK team, around one a month on the theme they’re promoting around that time.

At this week’s series of SQL Server community events hosted under the SQLRelay umbrella, I presented a session titled “Managing multi-vendor technology environments”. It sounds like something large organisations have to do, which is true, but it’s now also something individual solution owners have..