Today Data Exposed goes live at 12PM 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 for June and July so far.
You can read this blog to get all the updates and references mentioned in the show. Here’s the June 2022 update:
Product updates
You might think that the month after Microsoft Build would be a slow month for releases, but this year that is certainly not the case!
Let’s start with Azure SQL Database. In public preview, we announced the ability to enable new built-in server-level roles in Azure SQL Database for permission management. These built-in server level roles are fixed, meaning they have a set of certain permissions assigned to it that cannot be changed. This is great because the server is a logical concept that previously was complex to manage permissions over the whole server. These roles will also come to SQL Server 2022!
Earlier in June, we also announced Microsoft Purview access policies for Azure SQL Database in public preview. The new access policies feature provides data owners capability to author access policies through Microsoft Purview and then apply them to Azure SQL Database data sources individually or at scale.
In general availability (GA) for Azure SQL Database, we announced Named Replicas for Hyperscale. This is an exciting one that allows you to have read scale on the fly with up to 30 read replicas that spin up in minutes. Earlier in the month, we also announced the GA of geo-replication and auto-failover groups for Hyperscale, which enables transparent cross-region failover of Hyperscale databases.
We also have an interesting update for SQL Server 2016 (yes, you read that correctly). The Azure SQL Managed Instance team has released the public preview of the Link feature you’ve probably been hearing so much about in SQL Server 2022, but now supporting SQL Server 2016 so you can connect your instance to Azure SQL Managed Instance. This enables you to offload workloads to a read-only secondary hosted in Azure or migrate to Azure SQL Managed Instance altogether.
Finally, and this is more of an in-case-you-missed-it than a true update, we recently released a customer story (and neat video) on Lenovo’s use of Azure SQL Database ledger capabilities. Ledger for Azure SQL Database allows you to take advantage of managed centralized blockchain capabilities very easily. Check out the customer story and video.
On the SQL Server front, there was an 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.
One more announcement on the governance front includes Microsoft Purview which announced the general availability of Microsoft Purview Data Estate Insights at the beginning of July. Sunetra Virdi from the Purview team came on to tell us about the announcement and how to learn more.
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 May 2022.
Meredith Moore from the Cosmos DB team came on the show to tell us more about the new and improved free experience.
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!
- [SQL Insider Series] Stephen Giles: Azure SQL DB – Automating scale up and down
- [Azure SQL Security] Ido Keshet: Database Protection with Defender for Cloud (Ep. 5)
- [MVP Edition] Ike Ellis: Seven tips in seven minutes for the SQL Developer
- Lior Kamrat: Azure Arc-enabled data services Jumpstart scenarios updates
- [SQL Insider Series] Nadia Ben El Kadi: SQL Migration tools, which one and when?
- [SQL Insider Series] Mike Bhatt: Exporting Azure SQL DB BACPAC file to Azure with Azure Automation
- [MVP Edition] Bjoern Peters: Migrating your database to Azure SQL - Preparation is everything
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!
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 Cost Management updates – June 2022, Michael Flanakin
- See how 3 industry-leading companies are driving innovation in a new episode of Inside Azure for IT, Erin Chapple
- Supporting openEHR with Azure Health Data Services, Matjaz Ladava
- Start skilling on Azure with these helpful guides, Lanna Teh
- Find out why your SQL Server data belongs on Azure, Peter Carlin
- Power hybrid and multicloud environments with Azure Arc data solutions, Peter Carlin
- Microsoft SQL Server Blog
- SQL Server Tech Community
- How to enable and run SQL best practices assessments on multiple SQL Servers on Azure VMs
- Released: SCOM Management Packs for SQL Server, RS, AS (7.0.38.0)
- Early technical preview of JDBC Driver 11.1.2 for SQL Server released
- Released: Microsoft.Data.SqlClient 5.0 Preview 3
- Hotfix: Microsoft Drivers 5.10.1 for PHP for SQL Server Released
- Security Update for SQL Server 2019 RTM CU16
- Security Update for SQL Server 2019 RTM GDR
- Security Update for SQL Server 2017 RTM CU29
- Security Update for SQL Server 2017 RTM GDR
- Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR
- Security Update for SQL Server 2016 SP3 GDR
- Security Update for SQL Server 2016 SP2 CU17
- Security Update for SQL Server 2016 SP2 GDR
- Security Update for SQL Server 2014 SP3 CU4
- Security Update for SQL Server 2014 SP3 GDR
- Temporal: Encountering Error 13535 Data modification failed on system-versioned table...
- Common Criteria EAL4 Certification for SQL19
- How It Works: Workers, Tasks, Failed Logins - What is my SQL Server Doing?
- SQL Server 2022 public preview is now available on Linux.
- Azure SQL Tech Community
- Restoring a SQL Managed Instance database backup to SQL Server 2022 (Private Preview)
- Azure SQL Database Hyperscale Named replicas now GA
- High Availability in Azure SQL MI: Business Critical service tier
- Gen4 hardware deprecation update impacting SQL database, SQL elastic pools and SQL Managed Instance
- Get up and running faster with the new post-database creation experience on the Azure Portal
- Announcing General Availability (GA) of Active geo-replication & Auto-failover groups for Hyperscale
- Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance – Part 3 (Azure Data Factory)
- User-assigned managed identity (UMI) in Azure AD for Azure SQL
- Azure SQL DevBlog
- Azure Database Support (SQL-related posts)
- Lesson Learned #222:Hands-On-Labs: Configure/Troubleshoot Linked Server Azure SQL Managed Instance
- Lesson Learned #221:Hands-On-Labs: Activity Monitor in my Azure SQL Managed Instance
- Lesson Learned #220:Hands-On-Labs: Activity Monitor in my Elastic Database Pool
- Lesson Learned #219:Hands-On-Labs: What do I need to do in case of high CPU wait time
- Lesson Learned #218:Hands-On-Labs: What do I need to do in case of high LOG_RATE_GOVERNOR wait time
- Lesson Learned #217:Hands-On-Labs:40197-The service has encountered an error processing your request
- Lesson Learned #216: Hands-On-Labs: How redirect connection policy type works
- Lesson Learned #215: Hands-On-Labs: Communication link failed error message using ODBC.
- Lesson Learned #214: Hands-On-Labs: How to manage an idle connection state issue
- Lesson Learned #213: Cannot set the AccessToken property if the Integrated Security has been set
- Lesson Learned #212: Hands-On-Labs:TCP Provider: The semaphore timeout period has expired
- Lesson Learned #211: Monitoring SQLPackage Import Process
- SQL Server Performance: Upper and Lower functions and Database collation.
- Azure SQL connectivity error 10060 example : a DNS resolution issue.
- Lesson Learned #210: Hands-On-Labs:A transport-level error has occurred when receiving results.
- Lesson Learned #209: Hands-On-Labs:10928-Resource ID:1.The request limit for the database is reached
- Lesson Learned #208: Hands-On-Labs:10928-Resource ID:2.The session limit for the database is reached
- Lesson Learned #207: Hands-On-Labs: 40613-Database ‘xyz' on server ‘xyz2' is not currently available
- Lesson Learned #206: Hands-On-Labs: The timeout period elapsed prior to obtaining a connection
- Lesson Learned #205: Best Practices connecting to Azure SQL Database and Managed Instance
- How to restore database using LTR backups with PowerShell
- Learning from Expertise#10: Why no restore point available?!
Events
We have several in-person and virtual events coming this month. Here are a few to put on your calendar and register for from the Azure Data team:
July 19: Microsoft Inspire, Virtual
August 8-12: Visual Studio Live!, Microsoft HQ
September 19-22: Data Platform Summit, Virtual
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
For this month, since Meredith came on to tell us how to get started with Cosmos DB, I wanted to highlight a module Explore fundamentals of Azure Cosmos DB. In this module, you’ll learn how Azure Cosmos DB provides a highly scalable store for non-relational data. After the module, you’ll be able to describe key features and capabilities, identify the APIs supported, and provision and use an Azure Cosmos DB instance. Check it out.
Anna’s pick of the month!
My pick of the month is a special episode of MVP Edition with Ike Ellis, Seven tips in seven minutes for the SQL Developer. If you use SSMS at all for anything, you do not want to miss this episode. Ike showed us so many tips and tricks that I had never seen before, leaving my jaw dropped and I had to watch it back a couple of times after. Don’t miss the free tips.
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
Updated Jul 19, 2022
Version 2.0
Anna Hoffman
Microsoft
Microsoft