Making SQL sense

+44 (0)20 3051 3595

Making SQL sense

+44 (0)20 3051 3595


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

Azure SQL Database Managed Instances - a real game changer!

Since its announcement 8 years ago, Azure SQL Database (DB) has been the go-to Platform-as-a-Service (PaaS) offering for SQL Server workloads in Microsoft Azure. During that time, SQL DB has matured to the point where the chasm that once existed with the boxed product we know and love, has..

Getting started with PowerShell (PoSH)

This is a quick start guide to PowerShell and by the end of reading it, you should be able to be write your own scripts and explore the language confidently.

Musings of a Working Mum

Since becoming a Mum I’ve found working life hard. Really hard. Don’t get me wrong, I expected disruption and compromise but what I didn’t expect was the overwhelming feeling of guilt. Guilt I impose upon myself, I’m sure, but it’s constant. I'm pretty sure that the guilt that comes along with..

Power BI Licensing & Deployment Options

Licensing is confusing at the best of times, but even more so when the product is constantly in flux, improving and evolving. Coeo has recently been delivering more and more training on Power BI and common questions we get from delegates revolve around licensing and deployment options and..

Cyber Security Update - November 2017

The second CU for SQL Server 2017 was released on November 28th which contains a variety of fixes for both Windows and Linux platforms. Since January 2016, SQL Server CU's are certified to the same levels as Service Packs and so Microsoft recommend ongoing, proactive installation of CUs as they..

Data protection and privacy [Webinar]

In a climate where data breaches are all too frequent, and more and more data lives in the cloud, the challenge of protecting your data can seem daunting. Coeo recently took part in a webinar with our partner Redgate Software, looking at the myths around compliance, database DevOps and the..

Azure SQL Data Warehouse vs SQL Database

Recently I was asked what the difference was between Azure SQL Database (SQLDB) and Azure SQL Data Warehouse. (SQLDW) If you connect to them both via Management Studio there doesn't seem to be much difference, but the real answer is 'a lot'.

Securing connections to SQL Server with TLS

Following one of my earlier blog posts about Always Encrypted, I thought I'd stick with the security theme for my latest one.  With the General Data Protection Regulation (GDPR) on the horizon, encrypting connections is one of the most common discussion points that comes up during customer..

How Vulnerable is Your Data? Stop Malware Attacks using Azure SQL Database

"We are going to see 2 or 3 more of these seismic events in the next 12 Months"  RunAsRadio, episode 546

Ransom Demands

People don't notice great security practice. End-users and Business Managers want new features and better performance, sometimes leaving..

Executing Packages with SSIS Scale Out

In my previous post Getting Started with SSIS Scale Out I discussed the use cases for SSIS Scale Out and how to install and configure it. In this post I'll look at how to execute packages in Scale Out, depending on your type of workload and security considerations.