--- title: The Coeo Blog | SQL Server (5) description: SQL Server | The latest updates from Coeo on retail, gaming, finance and the Microsoft data platform (5) --- [![](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 ## [Check your CHECKDBs](https://blog.coeo.com/checkdb-blog) To find out when the last successful DBCC CHECKDB for a given database was, we can use the DBCC DBINFO() command and look for the dbi\_dbccLastKnownGood value. Alternatively, Microsoft introduced this information in the form of a DATABASEPROPERTYEX value, starting from SQL Server 2016 SP2: [![Ben Edwards](https://blog.coeo.com/hubfs/Profile%20photos/BenCircle.jpg)](https://blog.coeo.com/checkdb-blog) [Ben Edwards](https://blog.coeo.com/author/ben-edwards) | October 26 , 2018 ## [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 ## [Servers – Pets, Cattle – mince?](https://blog.coeo.com/using-containers-for-virtualisation) Pet servers are those servers you named, nurtured (loved?). Cattle servers are disposable, numbers only. When they are sick they are “…[taken out back, shot, and replaced](http://cloudscaling.com/blog/cloud-computing/the-history-of-pets-vs-cattle/)…”. Containers offer a new way to think about the services we’re delivering – processing our cattle-like servers into something we.. [![Kevin McNamara](https://blog.coeo.com/hubfs/Profile%20photos/KevinCircle.jpg)](https://blog.coeo.com/using-containers-for-virtualisation) [Kevin McNamara](https://blog.coeo.com/author/kevin-mcnamara) | July 18 , 2018 ## [Who unscheduled my agent jobs?](https://blog.coeo.com/who-unscheduled-my-agent-jobs) Introduction Due to the large number of different SQL Server instances (and versions) we support, we get the luxury of seeing unusual behaviour more often than most. Something I’ve seen three times now is a curious issue with the SQL Server Agent on SQL 2016 CU5 which rarely crops up following a.. [![James Murfin](https://blog.coeo.com/hubfs/Profile%20photos/JamesMCircleLow.jpg)](https://blog.coeo.com/who-unscheduled-my-agent-jobs) [James Murfin](https://blog.coeo.com/author/james-murfin) | July 06 , 2018 ## [Installing SQL Server 2016 on Windows Server 2012 R2 (the KB2919355 issue)](https://blog.coeo.com/kb2919355-issue-sql-server-2016) While performing an in-place SQL Server upgrade for a customer, I came across the KB2919355 issue. This article will show you how to resolve this this problem and point out why this can be misleading. [![Ryan Allport](https://blog.coeo.com/hubfs/Profile%20photos/RyanCircle.jpg)](https://blog.coeo.com/kb2919355-issue-sql-server-2016) [Ryan Allport](https://blog.coeo.com/author/ryan-allport) | June 26 , 2018 ## [BACKUP LOG was unable to log updates for database in SQL Server 2016](https://blog.coeo.com/backup-log-unable-to-log-updates) If you’re running SQL Server 2016, you may want to install SQL Server Service Pack 1, CU8. I came across an issue recently that effectively caused the transaction log backups to hang. Through our proactive monitoring, we were alerted to the fact that a log backup had not been taken in 4 hours. Upon.. [![Ryan Allport](https://blog.coeo.com/hubfs/Profile%20photos/RyanCircle.jpg)](https://blog.coeo.com/backup-log-unable-to-log-updates) [Ryan Allport](https://blog.coeo.com/author/ryan-allport) | May 10 , 2018 ## [Is this the end of SQL Server Failover Cluster Instances?](https://blog.coeo.com/is-this-the-end-of-sql-server-failover-cluster-instances) One of the common customer queries we get at Coeo is how to provide high availability for SQL Server. I have been advocating the use of SQL Server Failover Cluster Instances (FCI) to provide high availability for over 10 years. However, during a review of our reference architecture the question.. [![James Baldwinson](https://blog.coeo.com/hubfs/Profile%20photos/JamesBaCircle.jpg)](https://blog.coeo.com/is-this-the-end-of-sql-server-failover-cluster-instances) [James Baldwinson](https://blog.coeo.com/author/james-baldwinson) | May 08 , 2018 ## [Simplifying key management in SQL Server by using Azure Key Vault](https://blog.coeo.com/simplifying-key-management-in-sql-server) Implementing [Transparent Data Encryption](https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption) (TDE), [Backup Encryption](https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-encryption), [Always Encrypted](https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine), Symmetric key and Asymmetric keys all require that a final secret is stored at some point which protects the encryption key(s) used to secure the data. The main difference between a symmetric and asymmetric key is.. [![Jon Gurgul](https://blog.coeo.com/hubfs/Profile%20photos/JonCircle.jpg)](https://blog.coeo.com/simplifying-key-management-in-sql-server) [Jon Gurgul](https://blog.coeo.com/author/jon-gurgul) | April 09 , 2018 ## [Working with Technical Debt](https://blog.coeo.com/working-with-technical-debt) As someone who has worked with many clients across many industries one of the common problems I see is companies who are finding it hard to juggle all the adhoc requests that come in to their data team. Report requests, data modifications, minor deployments, fixes or query performance tuning; no.. [![Emma Zambonini](https://blog.coeo.com/hubfs/Profile%20photos/EmmaCircle.jpg)](https://blog.coeo.com/working-with-technical-debt) [Emma Zambonini](https://blog.coeo.com/author/emma-zambonini) | March 15 , 2018 ## [Using "With (nolock)"? Read this](https://blog.coeo.com/using-with-nolock-read-this) Anyone that's worked with SQL for any length of time will undoubtedly have seen and heard the following [![David Morrison](https://blog.coeo.com/hubfs/Profile%20photos/DavidCircle.jpg)](https://blog.coeo.com/using-with-nolock-read-this) [David Morrison](https://blog.coeo.com/author/david-morrison) | March 12 , 2018 [Load more](https://blog.coeo.com/topic/sql-server/page/6) ### 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