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

The Coeo Blog

Database in restoring state and single user mode? See why and how to resolve

Background...

We recently came across an interesting issue when performing some planned work for a client. In order to move the databases' data files to a different disk, we had to temporarily remove the databases from the availability group (AG) but had an issue when trying to join the..

Podcast: Managed Services for Data Platforms (with Kieran Sutherland)

Discover why migrating to a cloud platform comes with its own set of challenges and the considerations that companies need to make when selecting a managed services provider.Kieran Sutherland - Commercial Lead for Coeo's Dedicated Support Service - talks about the myths around cloud migration,..

Concurrency with Azure Backup for SQL Server

For SQL Server IaaS VMs, Microsoft provides Azure Backup for SQL Server – a PaaS service allowing you to leverage the Azure Backup service to back up SQL Server databases easily and in a centralised manner.

In this post, we’ll discuss a recent pitfall we came across with backup concurrency, and..

8 Reasons to Choose Dedicated Support

We know how tough the recruitment marketing for database professionals is right now. If you're concerned about downtime and want peace of mind when it comes to mission-critical data assets, our Dedicated Support team can help.

Podcast: Data Platform Modernisation (with Simon Osborne)

Coeo's Simon Osborne (Cloud, Data & AI Architect) explores the benefits of modern data platforms, how organisations can embark on their modernisation journey and the future of SQL Server as a Microsoft product.

Cyber Security Monthly News - October 2020

Many SQL Server and Windows Updates were introduced in September and early October, including the latest Cumulative Update for SQL Server 2019, which addresses the snapshot issues introduced by CU7.

Stay C.A.L.M. - Analyzing Space Alerts

Hello again. We've talked about a process to help you deal with alerts - so now let's start looking at some specifics, shall we? I'm going to lay these out in no particular order - this one is inspired by a colleague of mine, who asked me a great question: "Why do we care about low disk space?"..

Preventing Brute Force Attacks in SQL Server

SQL Server provides two different forms of authenticating the users that connect to the database server: Windows Authentication, which is the default and preferred method, and SQL Server Authentication, which needs to be explicitly enabled.

Is your transaction as lonely as you think? A cheat sheet for isolation levels in SQL Server

This post aims to give you a brief introduction into what isolation levels are and how they work within SQL Server. In short, they are a measure for controlling concurrency on the server.

Managing SQL Server Compatibility Levels using Query Store

Managing SQL Server production databases can become a nerve-wracking situation for administrators, especially when your organisation or business can have hundreds of databases that are vital to its existence and commerce.

Back to top