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

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

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

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 explains what this means and how unsupported products can affect your business: 

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.

Reserved Capacity for Azure SQL Database

It doesn't seem that long ago when the DTU model was the only way of purchasing Azure SQL Database. In the last year Microsoft has announced some significant changes in the way we can buy it. Earlier in the year I blogged about the introduction of the vCore purchasing model, which provides..

Data visualisation in the insurance industry

The insurance industry is a sector built on data and, with the increasing amounts being generated, data mastery and digital technology will become vital parts of the insurance process.

Cyber Security Monthly News - July Summary 2018

This month, there were a number of Windows updates which aimed to fix known critical system vulnerabilities, summarised here:

Microsoft UK Partner Pledge

During the Microsoft Inspire 2018 partner conference, held in fabulous Las Vegas, Microsoft UK CEO Cindy Rose talked about the real challenges technology businesses face back home in the UK on digital skills, diversity and inclusion, and responsible and ethical AI.  While we're a tiny part of..

Free extended security updates for SQL Server 2008

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

Servers – Pets, Cattle – mince?

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