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 secondary..
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 ..
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..
In this blog post I will talk about a very common issue in SQL Server: deadlocks.
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..
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’..