An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL Server. We know that it is one of the benefits of Azure SQL Database but now we get some insight into how it’s done.
I am not sure when this became available but for Azure SQL Database 150 compatibility level is now available. Last time I created a database few weeks ago, only level 140 ( SQL Server 2017) was available so I think it is a recent thing.
Upon some testing, if you create a new Azure SQL Database by default it is 150 as per the screen shot below (from the script action command)
I want to do a quick summary post of the many different types of Azure SQL Database available and I am not talking about elastic pools, VMs etc, more so the singleton type.
A small but useful change has been made to the Azure Portal for Data Platform objects.
You should never stop learning, especially within the IT industry. There are many fields to move into nowadays within the data space, you still have your classic / cloud DBA roles (crossing over to roles such as data engineer) and development roles too. Looking at the industry I see things like Big Data and Data Science becoming more popular. This led me to the Microsoft Professional Program where I spent my time completing the Big Data track – unfortunately it will be retired by Microsoft.
All About Tech 