Friday, March 11, 2022

Azure SQL News Update: March 2022

Once a month 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.

 

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

 

Product updates

As always there’s lots going on and lots to cover! We will include some announcements made in the past week, as well as some pre-announcements for things landing next week. This is a special month since we live-streamed the episode from SQL Bits in London, UK. For each of the areas, we were able to have a great member of our team tell us about the updates.

 

Emily Lisa kicked it off by telling us about the latest Azure SQL Database product updates including Azure SQL maintenance windows, zone redundancy for SQL Hyperscale, and configurable backup storage redundancy for SQL Hyperscale.

 

Dani Ljepava from the Azure SQL Managed Instance product team came on to share a range of new features announced at SQL Bits now available in public preview: Link feature for Managed Instance, data virtualization with ADLS, Advanced notifications for planned events, Hybrid Service Broker, Windows authentication for Azure AD Principals, and the general availability of Maintenance windows. Watch the episode to see a special look at Link feature for Managed Instance!

 

Pam Lahoud also came on to talk about about the latest improvements that help you manage your SQL Server in Azure Virtual Machines, including the newly released SQL best practices assessment, all available to you by installing the free SQL IaaS Agent extension!

 

As if those three rockstars weren’t enough, Alexandra Ciortea came on to tell us about the latest news in the migration space, including the Azure Data Studio migration extension and other updates for heterogeneous and homogeneous migrations.

 

Silvano Coriani unfortunately wasn’t able to join us as planned, but prepared some developer-related news:

 

Other database updates

Not a ton of big updates from other databases with the exception of Azure Database for PostgreSQL – Hyperscale (Citus), which actually has a lot of updates! New certifications are available and additional regions are available. Additionally, Private access support and minor version support are now generally available.

 

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!

  • Mustafa Branch: Announcing the New Microsoft Azure Cosmos DB Developer Specialty Certification
  • David Pless: System Page Latch Concurrency Enhancements in SQL Server 2022 (Ep. 6)
  • David Pless: SQL Server 2022: Introducing Buffer Pool Parallel Scan (Ep. 5)
  • [MVP Edition] Warwick Rudd: Connecting the Dots in Azure Data Studio with Database Projects and Source Control
  • David Pless: SQL Server 2022 Storage Engine Capabilities (Ep. 4)
  • Pam Lahoud, Aditya Badramraju: Azure SQL VM: New and Improved SQL on Azure VM deployment & management experience (Ep.8)
  • Bob Ward: Migrate SQL Server to Azure

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 February 2022 News Updates
  • 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.

 

Data Exposed

 

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

 

Live Series:
Something Old, Something New: http://aka.ms/sosn-videos
Azure SQL Security: http://aka.ms/dataexposed-security
Azure SQL Virtual Machines Reimagined: https://aka.ms/azuresqlvmyt

 

Mini-series:
Real-time Operational Analytics: https://aka.ms/dataexposed-operational-analytics
Migrating to SQL: https://aka.ms/migrating-to-sql
Azure SQL Edge: https://aka.ms/dataexposed-azuresqledge
Azure SQL Virtual Machines: https://aka.ms/azuresqlvmyt
SQL Server 2022: https://aka.ms/dataexposed-sqlserver2022

Special:
Around the Clock with Azure SQL and Azure Data Factory: https://aka.ms/aroundtheclockyt

Additionally, 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 PST and new #MVPTuesday episodes on the last Tuesday of every month at 9AM PST 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

Posted at https://sl.advdat.com/36dbxrmhttps://sl.advdat.com/36dbxrm
Labels: ,