Azure SQL News Update: September 2022
Published Sep 21 2022 06:50 AM 913 Views
Microsoft

Today, Data Exposed goes live on LearnTV and at Data Platform Summit. 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 since August.

 

You can read this blog to get all the updates and references mentioned in the show. Here’s the September 2022 update:

 

By the way, this was a special episode, because it also was a session at the Data Platform Summit. If you missed the live stream, you won’t want to miss the recording: https://aka.ms/AzureSQLYT. Here are some of the references from our awesome guests:

 

Product updates

Let’s start with the general availability announcements for Azure SQL. Azure SQL Managed Instance released Windows Authentication support with Azure Active Directory and Kerberos, including details on how to set it up. For SQL Managed Instance and SQL Database, you can now leverage an assignment of a server or instance identity with user-assigned managed identity in Azure.... Finally, for Azure SQL Database Hyperscale, zone redundancy is now fully supported, similar to other service tiers, more details here.

 

We’ve also had some relatively big announcements in the public preview space, starting with expanded support to standard editions of SQL Server 2019 with link feature for Azure SQL Managed Instance! This is a great one that can help you use SQL Managed Instance for disaster recovery (and even migration). Along the lines of migration, you can now improve your migrations experience with resumable database restore on Azure SQL Managed Instance. Niko Neugebauer came on the show to tell us a little more about what this means for your migrations with Long Replay Service (LRS), Azure Data Studio, and Azure Database Migration Service.

 

Last but certainly not least, in the security space, automatic key rotation for customer managed keys (CMK) in Azure SQL Database and SQL Managed Instance was announced in public preview. This feature simplifies key management responsibilities for customers.

 

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 August 2022.

 

Cosmos DB

Azure Database for MySQL Flexible Server

Azure Database for PostgreSQL

Azure Cache for Redis Enterprise

General availability: Azure Cosmos DB integrated cache

 

Generally available: Audit log for continuous mode with Azure Cosmos DB

General availability: Azure Database for MySQL - Flexible Server data encryption with CMK

 

Public preview: Azure Database for MySQL - Flexible Server major version upgrade

 

General availability: Server logs for Azure Database for MySQL - Flexible Server

 

General availability: Azure Database for PostgreSQL output in Stream Analytics

 

Generally available: Azure Database for PostgreSQL minor versions 11.17, 12.12, 13.8, 14.5 now supported for Hyperscale (Citus)

 

Public preview: Migration tool feature with Azure Database for PostgreSQL – Flexible Server

 

General availability: Reserved instance pricing for Azure Cache for Redis Enterprise

 

Public preview: RedisJSON available in Azure Cache for Redis Enterprise

 

Videos

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!

  • Sravani Saluru: Azure SQL Security: The What, Why & How of Securing your Data with Azure SQL (Ep. 6)
  • Jody Donetti: Caching made easy in Azure SQL DB with FusionCache
  • Timi Oshin: Overview of the Table Designer feature in Azure Data Studio
  • [MVP Edition] Erik Ejlskov Jensen: Start using EF Core with your existing Azure SQL Database in 5 minutes
  • Jose M Jurado: Lessons Learned from the Azure Database Support Blog Series
  • [SQL Insider Series] Manish Kumar: Protect your sensitive data using Azure SQL DB
  • [SQL Insider Series]: Roberto Cavalcanti Azure Advisor Signals – What are they
  • Shireen Bahadur, Chuck Heinzelman: Azure Synapse Link for SQL
  • Daniel Perlovsky: How to explore your data estate using the Microsoft Purview data catalog

 

We’ve also had some great Data Exposed Live sessions this year. 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 News Update: August, live from Microsoft Studios
  • May the 4th be with Azure SQL (News Updates): this was a Star Wars-themed episode and it was so fun! Check it out for costumes, themed demos and slides, and fun!
  • Azure SQL & SQL Server 2022: Intelligent Database Futures
  • Azure SQL News Update: 2021 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.

 

Data Exposed

 

On Data Exposed, we’re always explaining topics, demonstrating features, discussing the latest news, etc. related to Azure Data through live and on-demand episodes. Check out any of the series available now – and note we’re always adding new topics and episodes:

Azure SQL Security: http://aka.ms/dataexposed-security
Azure SQL Virtual Machines Reimagined: https://aka.ms/azuresqlvmyt
Migrating to SQL: https://aka.ms/migrating-to-sql
SQL Server 2022: https://aka.ms/dataexposed-sqlserver2022
SQL Insiders: https://aka.ms/sqlinsiderseries

Plus find new, on-demand Data Exposed episodes released every Thursday at https://aka.ms/dataexposedyt

 

Microsoft Learn module of the month

We’ve been doing some updates to the Architect full-stack applications and automate deployments with GitHub module, which is part of the https://aka.ms/azuremodernapps learning path on Microsoft Learn. This is a great one because you pick the language (.NET, Python, or NodeJS), and we’ll take you through using GitHub to deploy a complete solution including Azure SQL Database, Logic Apps, Functions, Static Web Apps, and more.

 

Anna’s pick of the month!

OK this month my pick of the month is a new thing I’m dipping my toes into on TikTok. The goal is to start sharing database tips in a short, consumable fashion while I walk my dog. Check it out, follow along, and let me know what you think! It’s running on TikTok (https://www.tiktok.com/@analyticanna), Instagram (https://www.instagram.com/analytic.anna/reels/), and Twitter (https://twitter.com/AnalyticAnna).

 

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

 

1 Comment
Co-Authors
Version history
Last update:
‎Sep 20 2022 09:08 AM
Updated by: