Usually, Data Exposed goes live at 9AM PT on LearnTV on the first Wednesday of the month. 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. This month, we didn't do an episode, but if you want to catch other episodes, you can find them all at https://aka.ms/AzureSQLYT.
You can read this blog to get all the updates and references for February. Here’s the February 2022 update:
Product updates
The Azure SQL, SQL Server and other database teams at Microsoft have been hard at work the past month. We have so many cool things in the oven that I cannot wait to share out over 2022 as they land.
In January, one of the big updates for SQL Server was the release of Cumulative Update 15 for SQL Server 2019. This included some fixes as well as several improvements to the SQL Engine for Linux. One Linux improvement is that mssql-conf and adutil (utilities for running SQL Server on Linux) have been added to SQL Server 2019, enabling you to reduce the number of Active Directory (AD) customer service requests on Linux by simplifying deployment and rotate AD key tabs without downtime.
As with most months, several drivers/packages also have released updates, including for PHP, JDBC, and .NET. It’s nice to see that the changes and improvements we are making that are not language specific are being applied across the packages.
Additionally, there were several updates mentioned last month, that now have deeper dive blogs posted on both the Azure SQL Techcommunity and Azure Database Support blogs. Two that caught my eye are around backup storage redundancy and outbound firewall rules. There have also been some great blogs on cost management and automation. For the full list, keep reading!
Other database updates
Here are some updates from our open-source databases and Cosmos DB:
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!
- Drew Skwiers-Koballa: Introduction to Azure SQL Bindings for Azure Functions
- [MVP Edition] Heini Ilmarinen: Azure AD for Azure Data Services: Synapse Edition
- Chris Rininger: How to Leverage Centrally-managed Azure Hybrid Benefit to Save Money, Manage Cost and Stay Compliant
- Ebru Ersan: Azure SQL VM: Optimally Configure SQL Server on Azure Virtual Machines with SQL Assessment (Ep. 7)
- Lior Kamrat: Azure Arc-enabled Data Services Directly Connected Mode Breakdown
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 January 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.
- Azure Blog, data-related
- Microsoft launches landing zone accelerator for Azure Arc-enabled servers, Vijay Kumar
- Save big by using your on-premises licenses on Azure, Diana Gao
- Azure DDoS Protection—2021 Q3 and Q4 DDoS attack trends, Alethea Toh
- Rightsize to maximize your cloud investment with Microsoft Azure, Diana Gao
- 7 reasons to attend Azure Open Source Day, David Dennis
- Delivering the connected shopping experience: How Microsoft and Avanade are reimagining retail , Tony Shakib
- SQL Server Tech Community
- JDBC Driver 10.2 for SQL Server Released - Microsoft Tech Community
- Microsoft Drivers 5.10 for PHP for SQL Server Released
- Cumulative Update #15 for SQL Server 2019 Big Data Clusters
- Cumulative Update #15 for SQL Server 2019 RTM
- Negative Blocking Session Ids (-5 = Latch ANY TASK RELEASOR)
- Released: Microsoft.Data.SqlClient 4.0.1
- Cumulative Update #28 for SQL Server 2017 RTM
- Microsoft SQL Server Blog
- Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation, Peter Carlin (CVP Azure Databases)
- Azure SQL Tech Community
- Azure Database Support (SQL-related posts)
- Create and Assign Managed Identity using Powershell to SQL MI
- How to enable Outbound firewall rules for Azure SQL Databases
- Lesson Learned #184: Row Level Security and Parallelism - Microsoft Tech Community
- Blog - Automating DB maintenance for all SQL Databases in a single server using Azure Data Factory pipeline
- Automate native database backup of Azure SQL Managed instance to Azure blob storage
- Primary Key Violation in Bidirectional Replication
- Lesson Learned #183: TDSDump in Python connecting to Azure SQL Managed Instance
- Automating Azure SQL DB index and statistics maintenance using Azure Data Factory - Single Database
Upcoming events
As always, there are a lot of events coming up. Here are a few to put on your calendar and register for from the Azure Data team:
2/25: Northern Virginia Data Platform MeetUp
3/8 -12: SQL Bits 2022
4/4-7: SQL Server & Azure SQL Conference
Plus 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
Microsoft
