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

Azure Service Endpoints - how do they work?

It’s been a while since my last blog post, but the beauty of time marching forwards is that lovely new features get released in Azure for me to write about.

Something I always remember as a kid is that when we got a cool new bit of technology, I'd use it for a while and then my next port of..

Simplifying key management in SQL Server by using Azure Key Vault

Implementing Transparent Data Encryption (TDE), Backup Encryption, Always Encrypted, 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..

Azure - Planned VM Maintenance for January 2018

Update @ 8AM, January 4th - Microsoft have accelerated the planned maintenance window for updates due an Intel CPU vulnerability (more details here [Microsoft] and here [Google]). This may mean that your VMs have already been automatically maintained by Microsoft by the time you read this. If..

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

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

Make your Azure automation more flexible

Hi everyone! I’m Chris and I’ve recently joined Coeo as a Cloud Consultant. I specialise in helping customers looking towards the cloud with all aspects of Azure cloud adoption and usage..

I’m quite a fan of automation when it comes to Azure. Automating the build of your environments in Azure has..

Azure updates from Ignite 2017

Keeping up with the pace of the Azure cloud evolution is tough at the best of times. Just when you think you are getting on top of it, Ignite comes along and Microsoft drop a cluster of feature bombs which means you spend most of your Saturday updating your Visio architecture diagrams. Thanks a..

Backing up your databases in Microsoft Azure

Configuring scheduled database backups has always been an important activity for database professionals.  As we transition our SQL Server workloads into Microsoft Azure Infrastructure-as-a-Service (IaaS), we now have a number of options available for backing up databases which at first glance can..

Using an Azure cloud witness in your failover cluster

I’ve blogged previously about the need to configure a quorum witness on failover clusters and now with Windows Server 2016 there’s a great new quorum option – a cloud witness.

Azure Data Factory Best Practices: Part 1

Recently I have been working on several projects that have made use of Azure Data Factory (ADF) for ETL. During these projects it became very clear to me that I would need to implement and follow certain key principles when developing with ADF. This is the first of a series of posts which will..