Today Data Exposed goes live at 12PM PT on LearnTV. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as well as upcoming events and things to look out for. If you missed the episode, you can find them all at https://aka.ms/AzureSQLYT. This month we’ll recap all the updates and announcements in the database space for June and July so far.
You can read this blog to get all the updates and references mentioned in the show. Here’s the June 2022 update:
You might think that the month after Microsoft Build would be a slow month for releases, but this year that is certainly not the case!
Let’s start with Azure SQL Database. In public preview, we announced the ability to enable new built-in server-level roles in Azure SQL Database for permission management. These built-in server level roles are fixed, meaning they have a set of certain permissions assigned to it that cannot be changed. This is great because the server is a logical concept that previously was complex to manage permissions over the whole server. These roles will also come to SQL Server 2022!
Earlier in June, we also announced Microsoft Purview access policies for Azure SQL Database in public preview. The new access policies feature provides data owners capability to author access policies through Microsoft Purview and then apply them to Azure SQL Database data sources individually or at scale.
In general availability (GA) for Azure SQL Database, we announced Named Replicas for Hyperscale. This is an exciting one that allows you to have read scale on the fly with up to 30 read replicas that spin up in minutes. Earlier in the month, we also announced the GA of geo-replication and auto-failover groups for Hyperscale, which enables transparent cross-region failover of Hyperscale databases.
We also have an interesting update for SQL Server 2016 (yes, you read that correctly). The Azure SQL Managed Instance team has released the public preview of the Link feature you’ve probably been hearing so much about in SQL Server 2022, but now supporting SQL Server 2016 so you can connect your instance to Azure SQL Managed Instance. This enables you to offload workloads to a read-only secondary hosted in Azure or migrate to Azure SQL Managed Instance altogether.
Finally, and this is more of an in-case-you-missed-it than a true update, we recently released a customer story (and neat video) on Lenovo’s use of Azure SQL Database ledger capabilities. Ledger for Azure SQL Database allows you to take advantage of managed centralized blockchain capabilities very easily. Check out the customer story and video.
On the SQL Server front, there was an important announcement and that is SQL Server 2012 has reached end of support. Please see the blog to see the four options you have if you find yourself with SQL Server 2012 instances.
One more announcement on the governance front includes Microsoft Purview which announced the general availability of Microsoft Purview Data Estate Insights at the beginning of July. Sunetra Virdi from the Purview team came on to tell us about the announcement and how to learn more.
Other database updates
Starting in 2022 we’re trying to keep you updated on what’s going on with other database services at Microsoft, as we understand that oftentimes you’re using more than one service. Here are the updates I gathered from May 2022.
Azure Cosmos DB
Azure Database for PostgreSQL-Hyperscale (Citus)
Azure Database for MySQL – Flexible Server
General availability: Azure Database for PostgreSQL—Hyperscale (Citus) supports PostgreSQL minor ver... (11.16, 12.11, 13.7, 14.3)
Meredith Moore from the Cosmos DB team came on the show to tell us more about the new and improved free experience.
We continued to release new and exciting episodes this month. Here is the list, or you can just see the playlist we created with all the episodes!
We’ve also had some great Data Exposed Live sessions. Subscribe to our YouTube channel to see them all and get notified when we stream. Here are some of the recent live streams.
As always, our team is busy writing blogs to share with you all. Blogs contain announcements, tips and tricks, deep dives, and more. Here’s the list I have of SQL-related topics you might want to check out.
We have several in-person and virtual events coming this month. Here are a few to put on your calendar and register for from the Azure Data team:
July 19: Microsoft Inspire, Virtual
August 8-12: Visual Studio Live!, Microsoft HQ
September 19-22: Data Platform Summit, Virtual
And, if you can’t make it to our events, find new, on-demand Data Exposed episodes released every Thursday at https://aka.ms/dataexposedyt
Microsoft Learn module of the month
For this month, since Meredith came on to tell us how to get started with Cosmos DB, I wanted to highlight a module Explore fundamentals of Azure Cosmos DB. In this module, you’ll learn how Azure Cosmos DB provides a highly scalable store for non-relational data. After the module, you’ll be able to describe key features and capabilities, identify the APIs supported, and provision and use an Azure Cosmos DB instance. Check it out.
Anna’s pick of the month!
My pick of the month is a special episode of MVP Edition with Ike Ellis, Seven tips in seven minutes for the SQL Developer. If you use SSMS at all for anything, you do not want to miss this episode. Ike showed us so many tips and tricks that I had never seen before, leaving my jaw dropped and I had to watch it back a couple of times after. Don’t miss the free tips.
Until next time…
That’s it for now! Be sure to check back next month for the latest updates on LearnTV. We also release new episodes on Thursdays at 9AM PT and new #MVPTuesday episodes on the last Tuesday of every month at 9AM PT at aka.ms/DataExposedyt.
Having trouble keeping up? Be sure to follow us on twitter to get the latest updates on everything, @AzureSQL.
We hope to see you next time, on Data Exposed :)
--Anna and Marisa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.