Making SQL sense

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

The Coeo Blog

MK Marathon Relay: how I learned to love running!

When I was asked if I wanted to sign up for the MK Marathon Relay, I was hesitant. Each person is expected to run one leg of either 10 or 11k and I’ve never been a long distance or race runner. I played football my whole life – my idea of running is dreaded 6am sprints or chasing down an..

What is a SQL Server Deadlock?

 In this blog post I will talk about a very common issue in SQL Server: deadlocks.

New performance insights in MyCoeo Portal

Our Dedicated Support customers can now benefit from new performance insights in the MyCoeo Portal. This area provides high-level performance information on servers, instances and databases. 

Cyber Security Monthly News - March Summary 2019

There have been a number of notable security vulnerabilities uncovered last month including some for Chrome and Magento, while Huawei remains in the limelight:

The Finance Chief Data Officers' Network

At the end of February Coeo's Finance Chief Data Officers' Network met at the Gherkin in London for their quarterly roundtable meeting, based on the findings of our insurance whitepaper

Celebrating International Womens' Day at Coeo

Diversity is important. Increasingly, research shows that businesses with a diverse workforce take a more innovative approach, with those committed to gender, racial and ethnic diversity consistently outperforming those that don't.

Cyber Security Monthly News - February Summary 2019

Whether deliberately or through carelessness, fleshware continues to be a weak link for data security. That’s no excuse for not patching the software though.

"Why do I need a Load Balancer for an Availability Group Listener in Azure but not on-premises?"

I keep hearing this question being asked. It's not well documented by Microsoft nor is it widely known, but we know it's associated with the way failover clustering interacts with the Azure networking infrastructure.  My latest blog post attempts to unravel this mystery and explain why the..

SQL Server: The Problems of Having Thousands of Databases on a Single Instance

The current world record for the number of people to fit into a Mini is 28 people. For SQL Server, the max number of databases you can have on a single SQL Server instance is 32,767. However, like the people in the Mini, just because you can cram that many databases onto one server doesn’t mean..

Certify your application for database compatibility mode, not SQL Server version

A common problem with data platform modernisation is gaining application vendor support for newer SQL Server versions, but that has been made easier since Microsoft’s change in position on the long-term use of database compatibility mode announced in 2018.

Back to top