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 was a special #maythe4th episode that I think you’ll enjoy.
You can read this blog to get all the updates and references mentioned in the show. Here’s the May 2022 update:
Let’s start with Azure SQL Database. Data storage limits have increased from 1.5 TB to 2 TB for single databases and elastic pools configured with 8 and 10 vCores. This increase applies to both serverless and provisioned compute and both General Purpose and Business Critical service tiers. Change data capture (CDC) also became generally available, and this allows you to record activity on a database whenever tables and rows have been modified. For more information, see the docs (plus embedded Data Exposed episode!). Emily Lisa came on the show to tell us about some zone redundancy updates, including the GA of zone redundancy for the general purpose tier in Azure SQL Database.
On the public preview side for Azure SQL Database, migrations from Hyperscale to General Purpose was announced, which is exciting. It makes it so Hyperscale is no longer a one-way street! There are some limitations in the preview, please see the details. Some other preview updates include the ability to create and utilize AAD server principals in the master of a SQL Database, backup history for SQL DB available in a DMV (sys.dm_database_backups), and, last but not least, Hyperscale now supports point-in-time-restore for up to 35 days, bringing additional parity with General Purpose and Business Critical.
Another big GA announcement was on the migration front – the Azure SQL Migration extension for Azure Data Studio. This makes it easy and self-explanatory to migrate your databases to Azure SQL. You can even do it at scale, with PowerShell and Azure CLI modules.
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 April 2022.
In addition to these updates, we had so many folks on (in theme and costume!) the show. I can’t do it justice by writing about it, you’ll need to go watch on https://aka.ms/AzureSQLYT.
We continued to release new and exciting Azure SQL episodes this month. Here is the list, or you can just see the playlist we created with all the episodes!
- Neel Ball: How to Accelerate Oracle to Azure Database Migration
- [MVP Edition] Armando Lacerda: Choose the Right SQL Engine Size in Synapse
- Mohamed Kabiruddin: Assess, Get Recommendations & Migrate SQL Server to Azure using Azure Data Studio
- Bashar Hussein: Improve your database performance with Azure Database for MySQL – Flexible Server
- Shreya R Aithal: Develop applications faster with Azure Database for MySQL – Flexible Server
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.
- Azure SQL April 2022 News Updates
- Azure SQL March 2022 News Updates – Live from SQLBits!
- Azure SQL & SQL Server 2022: Intelligent Database Futures
- Azure SQL News Update: Year in Review
- Welcome to SQL Server 2022 Live!
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.
- Azure Blog, data-related
- Microsoft SQL Server Blog / SQL Server Tech Community
- Azure SQL Tech Community
- Azure Database Support (SQL-related posts)
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:
May 2-5: DELL Technologies World, Las Vegas, NV
May 7: Global Azure Portugal, Virtual
May 10: Intel Vision, Dallas, TX
May 11: New England SQL Server User Group, Virtual
May 14: SQL Saturday Jacksonville, Jacksonville, FL
May 24-26: Microsoft Build, 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
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