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:
Product updates
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.
Videos
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!
Blogs
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
- Announcing new investments to help accelerate your move to Azure , Zia Mansoor
- Azure Purview is now Microsoft Purview , Jessica Hawk
- Enhance your data visualizations with Azure Managed Grafana—now in preview , Arti Gulwadi
- Optimize your cloud investment with Azure Reservations , Diana Gao
- Microsoft SQL Server Blog / SQL Server Tech Community
- Amplify your database development experience with Azure Data Studio - Microsoft SQL Server Blog
- Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed
- Early technical preview of JDBC Driver 11.1.1 for SQL Server released
- How It Works: Temporary Objects - User Transaction Scope
- Cumulative Update #16 for SQL Server 2019 RTM
- Released: Microsoft.Data.SqlClient 5.0 Preview 2
- SQL Server 2022 Early Adoption Program Update - Applications Now Closed
- Early technical preview of JDBC Driver 11.1.0 for SQL Server released
- Announcing general availability of the Ebdsv5 series Azure VMs!
- Azure SQL Tech Community
- Availability of Microsoft Information Protection labels for Azure SQL native data classification
- High Availability in Azure SQL Managed Instance: General Purpose service tier
- Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance - Overview
- CDC on Azure SQL Database
- Azure SQL DB Hyperscale short-term backup retention up to 35 days now in preview
- Microsoft.Build.Sql: the next frontier of SQL projects
- SQL data classification now offers Microsoft Information Protection labels in SSMS
- Zone redundancy for Azure SQL Database general purpose tier
- How to reverse migrate your Azure SQL Database from Hyperscale tier to General Purpose tier
- Announcing Azure SQL Migration extension for Azure Data Studio - General Availability
- Azure SQL DB Backup History - View backups of your Azure SQL Database
- Configure Auditing for Azure SQL Database series - Part2
- Azure Database Support (SQL-related posts)
- Lesson Learned #202: How to reproduce and find a SQL command timeout
- Lesson Learned #201: Performance comparison using INSERT with and without Begin Transaction
- Lesson Learned #200: Slow when fetching large volume of data compared with PYODBC.
- Additional Endpoints Required for AAD Authentication and CRL Checks for Azure SQL DB
- Fixing Problematic Index Spools
- VA Failed message: Could not authenticate to storage account 'storageaccount.blob.core.windows.net'
- Lesson Learned #199:Collect data for performance comparison Azure SQL Managed Instance vs SQL Server
- Lesson Learned #198: Getting the error "has an unresolved reference to object " exporting to bacpac
- Lesson Learned #197: Getting the error "Could not discover a user realm" using AAD
- Learning from Expertise#9: How to restrict users from enabling Azure defender on resource level?
- Lesson Learned #196: Latency and execution time in Azure SQL Database and Azure SQL Managed Instance
- Tips & Tricks #2: SQL Server Profiler (xEvents) for Azure SQL DB
- Lesson Learned #195: Performance Best Practices for Azure SQL Database and Managed Instance.
Events
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
Microsoft
