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!
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.