This article is contributed. See the original author and article here.

Today Data Exposed goes live at 9AM 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 July.


 


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


 


By the way, this was a special episode, because we filmed it live, for the first time in over two years, from the studios on Microsoft campus in Redmond, WA! If you missed the live stream, you won’t want to miss this in-person action: https://aka.ms/AzureSQLYT. Here are some of the references from our awesome guests:


 



 


Product updates


We technically discussed this in the last update, but I wanted to make sure everyone saw the 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.


 


The other big update (apart from the updates already covered by our guests) is the general availability of premium-series hardware for Azure SQL Managed Instance. This new hardware is what led to the study by Principled Technologies which shows how Azure SQL Managed Instance significantly outperformed Amazon RDS. Offering between double and five times the performance depending on workload, the three SQL Managed Instances tested also offer better price/performance by as much as 90.3%. The new hardware is available across different service tiers and might offer you more storage and more memory per vCore if you need it.


 


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


 














Azure Database for PostgreSQL-Hyperscale (Citus)



Flexible Server



General availability: Azure Database for PostgreSQL—Hyperscale (Citus) supports PostgreSQL minor versions (11.16, 12.11, 13.7, 14.3)


 


General availability: Citus 11 support for Azure Database for PostgreSQL – Hyperscale (Citus)


 


Public preview: Cross-region read replicas for Azure Database for PostgreSQL – Hyperscale (Citus)


 


Generally available: Basic tier updates for Azure Database for PostgreSQL – Hyperscale (Citus)


 


Generally available: vCore compute options for Azure Database for PostgreSQL – Hyperscale (Citus)



General Availability: Azure Database for MySQL – Flexible Server – On demand backups


 


Public preview: Azure Database for MySQL – Flexible Server data encryption with CMK


 


Generally available: New extensions for Azure Database for PostgreSQL – Flexible Server


 


Generally available: PostgreSQL 14 with Azure Database for PostgreSQL – Flexible Server


 


Generally available: Same-zone high availability for Azure Database for PostgreSQL – Flexible Server



 


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!



  • Daniel Perlovsky: How to explore your data estate using the Microsoft Purview data catalog

  • [MVP Edition] Wolfgang Strasser: Track your data supply chain using Azure Purview

  • Aditi Gupta: Backup and Restore your Azure Database for MySQL – Flexible Server workload

  • Pieter Vanhove: Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger

  • [SQL Insider Series] Stephen Giles: Azure SQL DB – Automating scale up and down


 


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.



  • 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.


 



 


Events


We have several in-person and virtual events coming in the next couple months. Here are a few to put on your calendar and register for from the Azure Data team:

August 8-12: Visual Studio Live!, Microsoft HQ
September 19-22: Data Platform Summit, Virtual
September 24: Data Saturday Dallas
October 1:
Data Saturday Atlanta

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


Jumping the gun on the pick of the month, but in the case that any of you are newer to Azure SQL, it’s been a long time since I highlighted the Introduction to Azure SQL module. In this module, you’ll start with a brief history of why and how Microsoft built Azure SQL. You’ll then learn about the various deployment options and service tiers, including what to use for your organization, and when. These options include Azure SQL Database, Azure SQL Managed Instance, and SQL Server in an Azure virtual machine. Understanding what platform as a service (PaaS) encompasses and how it compares to a traditional SQL Server environment will help you understand what you do and don’t get when you move to the cloud.


 


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

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

%d bloggers like this: