Making SQL sense

+44 (0)20 3051 3595 info@coeo.com
coeoClose

Making SQL sense

+44 (0)20 3051 3595 info@coeo.com

Careers

We're looking for people who share our commitment to excellence in Microsoft's data platform to join us consultants working on exciting business intelligence, analytics, and SQL Server projects on-premises and in the cloud.

Coeo Blog

The Coeo Blog

Beyond SQL Server 2008 End of Life: What does the Microsoft SQL Server Product Lifecycle mean to me? (Infographic)

 

As you’ll probably have heard, SQL Server 2008 and SQL Server 2008 R2 will go out of extended support in July 2019. This blog and infographic explain what this means and how unsupported products can affect your business: 

Cyber Security Monthly News - October Summary 2018

This October, Microsoft released Cumulative Updates for SQL Server 2017 and SQL Server 2014. In addition, we have also seen a number of Windows Updates released this month, see below for more details.

Data strategy for insurers

In today’s data-rich landscape, insurers who already collect vast quantities of information can use it to gain a competitive advantage.

Check your CHECKDBs

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:

Coeo Ltd. Now Available in the Microsoft Azure Marketplace

Microsoft Azure customers worldwide now gain access to Coeo’s Azure Data Jumpstart package to take advantage of the scalability, reliability, and agility of Azure to drive application development and shape business strategies.

Coeo Ltd. Now Available in the Microsoft Azure Marketplace

Microsoft Azure customers worldwide now gain access to Coeo’s Azure Data Optimisation workshop to take advantage of the scalability, reliability, and agility of Azure to drive application development and shape business strategies.

Cyber Security Monthly News - September Summary 2018

This September Microsoft celebrated the 25th anniversary of SQL Server with a big announcement; SQL Server 2019, which is already available to download for Windows, Linux, Docker and Kubernetes.

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

PCI DSS and your data platform

At Coeo we’ve supported a large number of retail organisations to ensure that their data platform is Payment Card Industry Data Security Standards (PCI DSS) compliant. As this topic is so critical for businesses in this sector and beyond, we’ve put together a brief introduction to PCI DSS.

Cyber Security Monthly News - August Summary 2018

In August, Microsoft released cumulative updates for both SQL Server 2014 and SQL Server 2017. We have also seen a number of Windows Updates released, with the most critical detailed below.