At Coeo we are seeing increasing numbers of customers take their first steps towards modernising their data platforms by moving workloads to the public cloud. Here is our quick guide to the options available:
In this blog post I will talk about a very common issue in SQL Server: deadlocks.
The current world record for the number of people to fit into a Mini is 28 people. For SQL Server, the max number of databases you can have on a single SQL Server instance is 32,767. However, like the people in the Mini, just because you can cram that many databases onto one server doesn’t mean..
A common problem with data platform modernisation is gaining application vendor support for newer SQL Server versions, but that has been made easier since Microsoft’s change in position on the long-term use of database compatibility mode announced in 2018.
Updated: February 2020
SQL Server 2008 and SQL Server 2008 R2 have now left Extended Support and no longer receive security updates. This blog and infographic explain what this means and how unsupported products can affect your business:
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:
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..
As its tenth birthday approaches, Microsoft prepares to end extended support for SQL Server 2008 and 2008 R2. This date has been known since product launch, there are now less than 12 months to retire or replace aging SQL Server estates. In the past, when we hit extended support end date, that's..
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…”. Containers offer a new way to think about the services we’re delivering – processing our cattle-like servers into something..
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..