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..
Learn with Coeo at SQL Bits
SQL Bits is a highlight of the year for European data professionals and this February's conference schedule is shaping up to be an exciting one.
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..
SQL Server 2017 will change how we think about it
The next version of Microsoft’s heavyweight database platform came one step closer to arriving this week when Microsoft released Release Candidate 1 of SQL Server 2017. Microsoft usually provides a couple of release candidates, meaning the final version is likely to appear sometime this autumn.
PowerApps – 500 Record Limit, Delegation and How to Work Around it
Update - April 2018:
PowerApps now has an experimental feature that can be turned on to increase the 500 row limit. I've not tested it with large sets but its a nice step forward.
To increase the limit, in the app developer studio (web or desktop) go to File->App Settings->Experimental Features and..
Consortium wins Microsoft Worldwide Partner of the Year for Cloud Productivity
We are delighted to announce that the Consortium, a group comprising Coeo, Content and Code, Inframon, Modality and Program Framework, has been selected from a global field of Microsoft partners for the prestigious Worldwide Partner of the Year for Cloud Productivity.
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.
Why you should always configure a quorum witness on a failover cluster
Since Window Server 2008, the role of what we used to call the “Quorum Disk” in a Failover Cluster has changed significantly and it’s now referred to as a “witness” because its only job is to help the nodes in the cluster decide who should be running the cluster resources in the event that they..
Changes to the Power BI family
Microsoft regularly delivers new functionality for its Power BI data analytics and visualisation services, but rarely does it change how you pay for it or how you deploy it. In May 2017, it has and some of the changes are significant.