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

The Coeo Blog

Roberto Marras

Roberto is a DBA in our managed services team

Recent Posts

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

Make the most out of your Azure Disks using Storage Pools

When should you use Storage Pools for your Windows VM in Azure?

If you are creating a SQL Sever failover cluster instance (FCI) in Azure, you can use Storage Spaces Direct (S2D) and configure Storage Pools to set-up the Cluster Storage.

The other main reason for using Storage Pools in Azure is ..

Cyber Security Monthly News – April 2019

Security concerns have risen this month around the government’s controversial plan to allow Chinese telecoms giant Huawei, which is accused of being a gateway for China to spy on Western nations, build the UK's 5G network. Former defence secretary Gavin Williamson, who was sacked for disclosing..

What is a SQL Server Deadlock?

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

Inside the Transaction Log file using fn_dblog() and fn_full_dblog()

In my previous blog post (https://blog.coeo.com/the-real-difference-between-the-select-...-into-and-insert-...-select-statements) I explored the difference between the ‘SELECT … INTO’ and ‘INSERT … SELECT’ and referenced the fn_dblog() function as a tool that can be used to retrieve information..

The (real) difference between the 'SELECT ... INTO' and 'INSERT ... SELECT' statements

In this blog post I will explore the difference between the ‘SELECT … INTO’ and ‘INSERT … SELECT’ statements. I recently moved some data for a customer to a brand-new table due to the bad design of the source table. First, I created the destination table and then I ran the ‘INSERT … SELECT’..

Back to top