Making SQL sense

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

The Coeo Blog

Power BI Security in Ten Steps

Are you fearful of migrating to a new data visualisation solution or hosting data in the cloud? The power of Power BI is too much to ignore and offers many security features to ease your concerns.

Options for Data Platform Modernisation

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:

"Why do I need a Load Balancer for an Availability Group Listener in Azure but not on-premises?"

I keep hearing this question being asked. It's not well documented by Microsoft nor is it widely known, but we know it's associated with the way failover clustering interacts with the Azure networking infrastructure.  My latest blog post attempts to unravel this mystery and explain why the..

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

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

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

Back to top