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

The Coeo Blog

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

Azure Data Studio – Don't Manage SQL Server with a Wooden Racket

How do you manage SQL Server?

Azure Data Studio is the new (ish) open-source, cross-platform tool from Microsoft to manage and interact with your SQL Servers or PostgreSQL instances. If you haven’t used it yet, I recommend you check it out (https://docs.microsoft.com/en-us/sql/azure-data-studio).

Azure Cosmos DB, to Infinity and Beyond

One of the technologies that surprised me when I heard of it was No-SQL databases.

As a database administrator that really distressed me at first; what is no-SQL? How can a database not be a relational database? Well, it’s been a few years, but finally my eyes opened and I’m ready to embrace..

Keeping Your Skills Sharp During the Pandemic

Individuals who believe their talents can be developed, as opposed to believing such talents are innate gifts, are known to have a "growth" mindset. Such people tend to achieve more than those with a "fixed" mindset because they spend less time worrying about looking smart, and more time being..

Adventures with SQL Server 2019 on Linux

There are many posts out there on installing SQL Server 2019 on Linux and in fact the Microsoft tutorials do a pretty good job of taking you through the installation.

This blog post takes you through my experiences with those tutorials and down some of the rabbit holes that I stumbled into along..

Moving SQL Databases and what to do when it goes wrong!

Recently we have helped a number of customers with moving system and user databases from one drive to another. We also regularly receive questions regarding how to do this safely and minimising risks associated. As such, we have produced a step-by-step guide with best practice recommendations..

Troubleshooting memory issues

At Coeo, we have the opportunity to deal with a wide range of problems every day and sometimes they manifest in mysterious ways.

Backup to URL

Backup to URL was introduced in SQL Server 2012 SP1 CU2 and allows backups to be taken directly to an Azure Storage Account. This post will expand on the evolving syntax when using Backup to URL and what I would consider to be best practice for Storage Account access.

If you would like a more..

SQL Server 2008: The Final Countdown

SQL Server 2008 and 2008 left Extended Support on 9th July 2019. In the latest episode of the Coeo Conversations Podcast Sales and Marketing Director James talks about the issue and explores the options available to businesses.

The DBA recruitment challenge

The Database Administrator (DBA) is often the organisation’s main source of technical database operational knowledge and they are difficult to obtain and retain.

Back to top