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

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

Cyber Security Monthly News – April Summary 2018

April has seen the release of a number of Windows patches, Service Pack 2 for SQL Server 2016 and a new cumulative update for SQL Server 2017. See more details below:

Recovering from Disaster - a five-point plan

Too often, a disaster recovery plan can look a little like it was put together by the underpants gnomes.

Phase 1: Take database backups

Phase 2: ???

Phase 3: Recovered from disaster

Starting with taking backups isn’t the worst idea (can’t say the same for collecting underpants), but this..

New vCore purchasing option for Azure SQL Database

Managed Instance is now in public preview and with it is a purchasing option we haven't yet seen with traditional Azure SQL Database offerings, known as the vCore purchasing model.  Earlier this month, Microsoft announced this model is now available in preview for Single Database and Elastic..

Azure Service Endpoints - how do they work?

It’s been a while since my last blog post, but the beauty of time marching forwards is that lovely new features get released in Azure for me to write about.

Something I always remember as a kid is that when we got a cool new bit of technology, I'd use it for a while and then my next port of..

Data is the new black - read our latest research

At Coeo, we find fashion retail is one of the most fast-moving and innovative industries we work with. Despite the diverse size and style of businesses in this sector, we have found that success is driven from some common ways of working - all of which recognise the value of data as a key..

Cyber Security Monthly News – March 2018

March 2018 will be remembered as the month of the Facebook and Cambridge Analytica scandal; it is believed that Facebook shared the data of over 80 million people, which has then been improperly harvested and used by Cambridge Analytica to target American and British voters during the 2016 US..

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

Making sense of business intelligence for retail

Our new on-demand webinar introduces the latest research in retail reporting and the ways data mastery can drive your business forward - from building omnichannel capability to identifying the most profitable parts of your estate.