--- title: The Coeo Blog | Roberto Marras description: Roberto is a DBA in our managed services team --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://www.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # The Coeo Blog ## Roberto Marras ![](https://blog.coeo.com/hubfs/Profile%20photos/RobertoCircle.jpg) 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](https://blog.coeo.com/database-in-restoring-state-and-single-user-mode) # **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 secondary.. [![Roberto Marras](https://blog.coeo.com/hubfs/Profile%20photos/RobertoCircle.jpg)](https://blog.coeo.com/database-in-restoring-state-and-single-user-mode) [Roberto Marras](https://blog.coeo.com/author/roberto-marras) | June 02 , 2021 ## [Make the most out of your Azure Disks using Storage Pools](https://blog.coeo.com/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 **..** [![Roberto Marras](https://blog.coeo.com/hubfs/Profile%20photos/RobertoCircle.jpg)](https://blog.coeo.com/make-the-most-out-of-your-azure-disks-using-storage-pools) [Roberto Marras](https://blog.coeo.com/author/roberto-marras) | July 15 , 2020 ## [Cyber Security Monthly News – April 2019](https://blog.coeo.com/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](https://www.bbc.co.uk/news/uk-48032286). Former defence secretary Gavin Williamson, who was sacked for disclosing.. [![Roberto Marras](https://blog.coeo.com/hubfs/Profile%20photos/RobertoCircle.jpg)](https://blog.coeo.com/cyber-security-monthly-news-april-2019) [Roberto Marras](https://blog.coeo.com/author/roberto-marras) | May 03 , 2019 ## [What is a SQL Server Deadlock?](https://blog.coeo.com/what-is-a-deadlock)  In this blog post I will talk about a very common issue in SQL Server: deadlocks. [![Roberto Marras](https://blog.coeo.com/hubfs/Profile%20photos/RobertoCircle.jpg)](https://blog.coeo.com/what-is-a-deadlock) [Roberto Marras](https://blog.coeo.com/author/roberto-marras) | April 23 , 2019 ## [Inside the Transaction Log file using fn\_dblog() and fn\_full\_dblog()](https://blog.coeo.com/inside-the-transaction-log-file) In my previous blog post ([https://blog.coeo.com/the-real-difference-between-the-select-...-into-and-insert-...-select-statements](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.. [![Roberto Marras](https://blog.coeo.com/hubfs/Profile%20photos/RobertoCircle.jpg)](https://blog.coeo.com/inside-the-transaction-log-file) [Roberto Marras](https://blog.coeo.com/author/roberto-marras) | September 21 , 2018 ## [The (real) difference between the 'SELECT ... INTO' and 'INSERT ... SELECT' statements](https://blog.coeo.com/difference-between-select-into-and-insert-select) 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’.. [![Roberto Marras](https://blog.coeo.com/hubfs/Profile%20photos/RobertoCircle.jpg)](https://blog.coeo.com/difference-between-select-into-and-insert-select) [Roberto Marras](https://blog.coeo.com/author/roberto-marras) | February 05 , 2018 ### Recent posts ### Categories - [SQL Server (118)](https://blog.coeo.com/topic/sql-server) - [Azure (58)](https://blog.coeo.com/topic/azure) - [Microsoft (49)](https://blog.coeo.com/topic/microsoft) - [Dedicated Support (47)](https://blog.coeo.com/topic/dedicated-support) - [Coeo News (43)](https://blog.coeo.com/topic/coeo-news) - [Professional Development (34)](https://blog.coeo.com/topic/professional-development) - [Industry News (27)](https://blog.coeo.com/topic/industry-news) - [cyber security (27)](https://blog.coeo.com/topic/cyber-security) - [power bi (25)](https://blog.coeo.com/topic/power-bi) - [Opinion (21)](https://blog.coeo.com/topic/opinion) - [Cloud (17)](https://blog.coeo.com/topic/cloud) - [Business Intelligence (16)](https://blog.coeo.com/topic/business-intelligence) - [analytics (15)](https://blog.coeo.com/topic/analytics) - [Security (14)](https://blog.coeo.com/topic/security) - [career (14)](https://blog.coeo.com/topic/career) - [SQL Server updates (13)](https://blog.coeo.com/topic/sql-server-updates) - [windows Updates (11)](https://blog.coeo.com/topic/windows-updates) - [Azure Databricks (10)](https://blog.coeo.com/topic/azure-databricks) - [data platform (10)](https://blog.coeo.com/topic/data-platform) - [Clustering (9)](https://blog.coeo.com/topic/clustering) - [Finance (9)](https://blog.coeo.com/topic/finance-news) - [podcast (9)](https://blog.coeo.com/topic/podcast) - [azure sql database (8)](https://blog.coeo.com/topic/azure-sql-database) - [data (8)](https://blog.coeo.com/topic/data) - [Data Science (7)](https://blog.coeo.com/topic/data-science) ### Popular posts ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top