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:
- Ebru Ersan
- Bradley Ball
- Silvano Coriani
- Niko Neugebauer – see the Azure SQL Techcommunity blog for lots of SQL Managed Instance content!
- Ledger in SQL Server 2022, Peter Vanhove
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 Active Directory. 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.
- Azure Blog, data-related
- Elevate your visualizations with Azure Managed Grafana—now generally available, Arti Gulwadi
- Azure Data Explorer: Log and telemetry analytics benchmark, Arun Ulagaratchagan
- Microsoft named a Leader in 2022 Gartner® Magic Quadrant™ for Data Integration Tools, Jessica Hawk
- Gain deeper insights with Microsoft Intelligent Data Platform, Vicki Beizer
- Announcing Microsoft Dev Box preview, Anthony Cangialosi
- Microsoft SQL Server Blog
- Intelligent Query Processing: feature family additions
- Query Store hints in SQL Server 2022
- Get more out of SSRS with improved user experience
- Azure Data Studio August Release
- Register today—Free Azure Data training at Data Platform Summit 2022
- Query Store is enabled by default in SQL Server 2022
- Microsoft Purview access policies for SQL Server 2022
- Establish digital trust in your data with ledger in SQL Server 2022
- SQL Server Tech Community
- Released: Microsoft.Data.SqlClient 2.1.5
- Released: Microsoft.Data.SqlClient 4.0.2
- Released: Microsoft.Data.SqlClient 4.1.1
- Hotfix: JDBC Driver 11.2.1 for SQL Server Released
- SQL Server 2022 Release Candidate 0 is now available on Linux
- Deploy Always On Availability Groups (AG) on SQL Server RHEL based Azure VMs - The Ansible Way!
- Released: Microsoft.Data.SqlClient 2.1.5
- HOW IT WORKS: dm_os_ring_buffer vs XEvent *_ring_buffer_reported events
- Updates to the modern servicing model for SQL Server 2017 and future versions of SQL Server on Linux
- SQL Server 2022 Release Candidate 0 is now available
- New granular permissions for SQL Server 2022 and Azure SQL to improve adherence with PoLP
- Released: Microsoft.Data.SqlClient 3.1.1
- Cumulative Update #17 for SQL Server 2019 RTM
- JDBC Driver 11.2 for SQL Server Released
- ODBC Driver 18.1 for SQL Server Released
- Released: General Availability of Microsoft.Data.SqlClient 5.0
- Azure SQL Tech Community
- Migrating SQL Server workloads FAQ
- Data virtualization now generally available in Azure SQL Managed Instance
- User Managed Identity support for Auditing SQL Azure database:
- Announcing General Availability (GA) of Zone Redundancy for Azure SQL Database Hyperscale tier
- Backup restore speed improvement for SQL Managed Instance
- Automated key rotation for TDE BYOK now available in preview for Azure SQL!
- Azure Data Community Newsletter Jul/Aug 2022
- Windows Authentication for Azure AD principals for SQL Managed Instance is now Generally Available
- Start Planning Your Free, Azure Data Platform Training at Data Platform Summit 2022
- Prevent Data Exfiltration in Azure SQL Managed Instance
- Azure Database Support (SQL-related posts)
- Principle 'XXX' could not be found or this principal type is not supported
- Lesson Learned #237: Long running operation failed with status 'NotFound' managing databases
- Lesson Learned #236: What? .... How much time you said? (CloudShell version)
- Lesson Learned #235: Finding how Indexed Views impact in my database update performance?
- Lesson Learned #234: Parallel vs Single Running a Bulk Insert with Python
- Considerations on Bidirectional Transactional Replication
- How to Capture the Actual Execution Plan in Azure SQL Database
- Resolve tempdb-related errors in Azure SQL Database
- Lesson Learned #233: What? .... How much time you said?
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
Microsoft
