Today and every Wednesday 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. We’ve included an iCal file, so you can add a reminder to tune in live to your calendar. If you missed the episode, you can find them all at https://aks.ms/AzureSQLYT.
You can read this blog to get all the updates and references mentioned in the show. Here’s the May 2021 update:
Product updates
The two main updates for this month are for Azure SQL Managed Instance and Azure SQL Database Hyperscale.
Azure SQL Managed Instance announced the general availability of service-aided subnet configurations. Service-aided subnet configuration allows users to remain in full control of TDS traffic, and Azure SQL Managed Instance takes responsibility to ensure uninterrupted flow of management traffic in order to meet SLAs. This configuration builds on top of the virtual network subnet delegation feature to make it easier for customers, by providing automatic network configuration management and enabling service endpoints.
These service endpoints or ‘service tags’ provide a was to reference essentially all IP addresses related to a given service in a specific region. For example, if you want to configure access to storage accounts to keep backups and audit logs in the region of West US, you could use the tag Storage.WestUs. Then, you can create a user-defined route (UDR) as the mechanism that allows traffic to leave the SQL MI virtual network and reach your storage account.
The other major announcement is a public preview for geo-replication in the Azure SQL Database Hyperscale service tier. This has been available in other Azure SQL Database tiers for a while, and this capability enables cross region business continuity and disaster recovery by allowing you to create one or more replicas in the same or different regions. This announcement brings Azure SQL Hyperscale one step closer to full feature parity with Azure SQL Database. Learn more about the preview here.
From a tools perspective, special guest Alexandra Ciortea came on to talk about SQL Server Migration Assistant (SSMA) and the latest release. She mentioned several great references for how to stay up to date, which you can find below:
- What's New in SSMA for Oracle (OracleToSQL)
- What's New in SSMA for Access (AccessToSQL)
- What's New in SSMA for MySQL (MySQLToSql)
- What's New in SSMA for SAP ASE (SybaseToSQL)
- What's New in SSMA for DB2 (DB2ToSQL)
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!
- Kate Smith: Understanding the Benefits of Intelligent Query Processing
- [MVP Edition] Argenis Fernandez: Storage 101 for Azure SQL and SQL Server Engineers
- Aaron Nelson: How to Parameterize Notebooks for Automation in Azure Data Studio
- Amit Khandelwal: Use Helm Charts from Windows Client Machine to Deploy SQL Server 2019 Containers on Kubernetes
- Manoj Raheja: Get Started with Azure Data Explorer using Apache Spark for Azure Synapse Analytics
- Mohamed Kabiruddin: Get Started with the New Database Migration Guides to Migrate your Databases 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.
- Something Old, Something New: Do Kangaroos Prefer Cake or Frosting?
- Azure SQL Security Series: Understanding Access and Authentication
- Ask the Experts: SQL Edge to Cloud
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
- Azure Cost Management and Billing updates – April 2021 , Michael Flanakin
- Upgrade your infrastructure with the latest Dv5/Ev5 Azure VMs in preview , Paul Nash
- Teaming up with Coursera on new Azure Specializations and Scholarships , John ‘JG’ Chirapurath
- Azure Trivia is back and it’s bigger, better, and faster than ever
- Why wait? SaaS-delivered data management for the pace of change , Tajinder Pal Singh Ahluwalia
- SQL Server Tech Community
- Early technical preview of JDBC Driver 9.3.1 for SQL Server released
- Inference of ML Models in SQL Server via External Languages
- Released: Microsoft.Data.SqlClient 3.0 Preview 2
- SQL Server 2019 on Ubuntu 20.04,python2 dependency removed for SQL Server 2019 across distributions
- Cumulative Update #10 for SQL Server 2019 RTM
- What’s new with SQL Server Big Data Clusters—CU10 release
- Azure SQL Tech Community
- Azure SQL Devs’ Corner
- N/A
- Azure Database Support (SQL-related posts)
- Lesson Learned #170: Connection Pooling caches IP address
- Azure SQL DB and Managed Instance tempdb
- Revocation of the SSL certificate failed for AAD authentication
- How-to auto-scale Azure SQL Databases
- Lesson Learned #169: Bulk Insert using Python in Azure SQL
- Custom RBAC to access QPI's query text with minimal permissions
Special Segment: SQL in a Minute, Microsoft Docs
We introduced a new segment this month, SQL in a Minute, led by Cheryl Adams. Cheryl and Jason Roth came on to talk about the latest updates and how to contribute to Microsoft Docs. You can find the documentation at https://aka.ms/sqldocs and the contributors guide at https://aka.ms/editsqldocs.
Special Segment, Citus and Open source updates
Claire Giordano, Principal PM Manager in Azure Data, came on the show to share some resources and updates around Citus and open source databases. Here are some references if you want to learn more:
- https://aka.ms/citus - Citus open source GitHub repo
- https://citusdata.com/download - Instructions for downloading Citus open source packages
- https://aka.ms/citus10 - The definitive blog post about the latest Citus 10 release
- https://aka.ms/citus-newsletter - Monthly technical newsletter
Upcoming events
As always, there are lots of events coming up this month. Here are a few to put on your calendar and register for:
May 10: SQLDay 2021
Azure SQL Workshop, Bob Ward and Anna Hoffman
Keynote, Bob Ward
SQL Day Q&A, Bob Ward and Buck Woody
Inside the Memory of SQL, Bob Ward
Presentation Skills for the Data Professional, Buck Woody
May 11: Azure Webinar Series: Debugging Web Apps on Azure App Service and Azure SQL
May 14: PyCon 2021
What we learned from Papermill to operationalize notebooks, Alan Yu and Vasu Bhog
May 15: Data Weekender
Keynote – Into the Dataverse, Buck Woody
May 15: Data Saturday Southwest US
Keynote, Buck Woody
May 18: Redgate Azure SQL Managed Instance Webinar
Inside Azure SQL Managed Instance, Bob Ward
May 18: Techorama
From Oops to Ops: Incident Response with Notebooks, Julie Koesmarno and Shafiq Rahman
May 20: Azure Webinar Series: Implementing DevOps Best Practices on Azure SQL
May 25- 27: Microsoft Build
Keynote, Rohan Kumar and Jason Anderson
Learn Live: Build full stack applications with Azure Static Web Apps and Azure SQL Database, Anna Hoffman and Davide Mauri
Roundtable: Develop Apps with SQL DB, Anna Hoffman, Davide Mauri, Sanjay Mishra
Roundtable: Mission Critical workloads on Azure SQL DB, Anna Hoffman, Abdul Sathar Sait, Sanjay Mishra, Roberto Bustos, Emily Lisa
In addition to these upcoming events, here’s the schedule for Data Exposed Live:
May 12: Azure SQL Virtual Machine Reimaged Series with David Pless and Pam Lahoud
May 19: Deep Dive: Azure SQL Insights with Alain Dormehl
Plus find new, on-demand Data Exposed episodes released every Thursday, 9AM PT at aka.ms/DataExposedyt
Featured Microsoft Learn Module
Learn with us! This month I highlighted the Deploy highly available solutions by using Azure SQL. Check it out!
By the way, did you miss Learn Live: Azure SQL Fundamentals? On March 15th, Bob Ward and I started delivering one module per week from the Azure SQL Fundamentals learning path (https://aka.ms/azuresqlfundamentals ). Head over to our YouTube channel https://aka.ms/azuresqlyt to watch the on-demand episodes!
Anna’s Pick of the Month
This month I am highlighting the Azure SQL Digital Event that happened on May 4th. This was an amazing event led by Azure Data CVP Rohan Kumar. Rohan spoke about the current and future innovations in Azure SQL, and it was hosted by Bob Ward with cameo from Scott Guthrie. I got to demo a few cool things, along with several other Microsoft Product Group members and Microsoft MVPs. You don’t want to miss the on-demand! Register at https://aka.ms/AzureSQLDigitalEvent to get the recordings.
Until next time…
That’s it for now! Be sure to check back next month for the latest updates, and tune into Data Exposed Live every Wednesday at 9AM PST 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. You can also download the iCal link with a recurring invite!
We hope to see you next time, on Data Exposed 🙂
--Anna and Marisa
Microsoft
