Updated: November 2020
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?"
Updated May 2021
I keep hearing this question being asked. It's not well documented 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 greater..
New vCore purchasing option for Azure SQL Database
Managed Instance is now in public preview and with it is a purchasing option we haven't yet seen with traditional Azure SQL Database offerings, known as the vCore purchasing model. Earlier this month, Microsoft announced this model is now available in preview for Single Database and Elastic Pool..
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 call..
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 is..
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 narrowed..
Azure SQL Data Warehouse vs SQL Database
Update February 2020: Azure SQL Data Warehouse is now part of the Azure Synapse analytics service.
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..
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..
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 be..