You wouldn’t allow simple single-factor authentication for your social media or personal email accounts, so is it appropriate for your corporate highly-sensitive data?
The GREATEST and LEAST functions arrive in Azure SQL Database
Towards the end of 2020, Microsoft introduced two brand new TSQL functions to Azure SQL Databases; GREATEST and LEAST which joined Microsoft’s documented list of TSQL functions online this month (GREATEST and LEAST).
Introducing Private Endpoints for Azure SQL Database
Over the last few years there's been increasing pressure on Microsoft to remove the need for applications to connect to Azure Platform-as-a-Service (PaaS) services via public endpoints. In February 2018 Microsoft announced the general availability of Virtual Network (VNet) Service Endpoints for..
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..
You Must Upgrade SQL Server to Stay Secure
A whole series of “speculative execution side-channel attacks” were disclosed in the first week of 2018, as detailed in this Microsoft article: https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/ADV180002
Major security events like this highlight the severe risk companies are taking..
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..