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:
- SQL Server 2022 (CTP 2.1 available!), Bob Ward
- Azure SQL Database, Davide Mauri and Drew Skwiers-Koballa
- SQL Server on Azure SQL VM, Mohamed Kabiruddin:
- Microsoft Purview, Daniel Perlovsky
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.... 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.
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!
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 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