cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Database Support Blog
Options
752

Azure SQL idle sessions are killed after about 30 minutes

hugo_sql on Sep 29 2022 01:16 AM
Today, I worked on a Service Request where the customer wanted to understand the expected behavior of idle sessions that...
1,271

Deleted Azure SQL Database with existing diagnostic settings

emregokoglu on Sep 29 2022 12:37 AM
In this article, we consider the scenario where customers would like to delete Azure SQL database which has an existing ...
452

Could not connect to mail server. (No such host is known)

Palomag_MSFT on Sep 27 2022 04:45 AM
Azure SQL Managed Instance. Could not connect to mail server. (No such host is known)
694

Azure SQL and Azure SQL Managed Instance - Backup retention polices Loading ...

Palomag_MSFT on Sep 27 2022 03:43 AM
Azure SQL and Azure SQL Managed Instance - Backup retention polices Loading ...
1,159

Lesson Learned #238: Configuring Private Endpoint Connections in Azure SQL Managed Instance

Jose_Manuel_Jurado on Sep 22 2022 07:49 AM
Today, I worked on a service request that our customer had some doubts about how to Configure Private Endpoint Connectio...
1,453

Invoke-Sqlcmd with Azure Automation for Azure SQL database

Sabrin_Alsahsah on Sep 21 2022 02:07 AM
In this blog article, we will be illustrating the required steps to use Invoke-Sqlcmd against an Azure SQL database from...
1,186

Auto scale up/down the Managed instance

amanda_ibrahim on Sep 19 2022 10:11 PM
This blog will help the customer to create a job to auto scale the Managed Instance service tier, vCores, and Storage si...
1,175

Error “SameKeyMaterialNotFoundOnRemoteServer” while coping Azure SQL DB to a different server

mohammad_belbaisi on Sep 18 2022 02:14 AM
In this blog article, will explain error “SameKeyMaterialNotFoundOnRemoteServer” while coping Azure SQL DB to a differen...
55.2K

Principle 'XYZ' could not be found or this principal type is not supported - Azure SQL DB and MI

Sabrin_Alsahsah on Sep 01 2022 04:30 AM
In this blog article, we will be discussing the possible scenarios to get the error "Principle 'XYZ' could not be found ...
1,044

Lesson Learned #237: Long running operation failed with status 'NotFound' managing databases

Jose_Manuel_Jurado on Aug 25 2022 05:55 AM
Days ago, I worked on a service request that our customer is using Microsoft.Azure.Management.Sql ( NuGet Microsoft.Azur...
1,778

Lesson Learned #236: What? .... How much time you said? (CloudShell version)

Jose_Manuel_Jurado on Aug 19 2022 05:25 PM
We usually have service requests when our customers, using different drivers, need to know the connection latency, execu...
1,414

Lesson Learned #235: Finding how Indexed Views impact in my database update performance?

Jose_Manuel_Jurado on Aug 19 2022 04:50 AM
Today, we worked on a very interesting service request where our customer is facing a performance issue running simple q...
1,426

Lesson Learned #234: Parallel vs Single Running a Bulk Insert with Python

Jose_Manuel_Jurado on Aug 18 2022 12:16 PM
Today, We've been working on a service request that our customer wants to improve the performance of a bulk insert proce...
1,368

Considerations on Bidirectional Transactional Replication

Holger_Linke on Aug 18 2022 03:01 AM
This article discusses the advantages, risks, and potential pitfalls of Bidirectional Transactional Replication.
1,985

How to Capture the Actual Execution Plan in Azure SQL Database

Holger_Linke on Aug 17 2022 01:58 AM
This article describes steps how you can retrieve the actual execution plan of a query directly from the runtime statist...
2,262

Resolve tempdb-related errors in Azure SQL Database

Holger_Linke on Aug 12 2022 12:02 AM
This article describes troubleshooting and mitigation steps for resolving tempdb-related errors and exceptions in Azure ...
1,386

Lesson Learned #233: What? .... How much time you said?

Jose_Manuel_Jurado on Aug 10 2022 07:00 PM
We usually have service requests when our customers, using different drivers, need to know the connection latency, execu...
2,097

Bidirectional Transactional Replication in SQL Managed Instance

Holger_Linke on Jul 29 2022 05:00 AM
This article provides a sample script for creating a Bidirectional Transactional Replication between two Managed Instanc...
974

Lesson Learned #232: Microsoft Reactor- Identify an Azure SQL Performance Issue (Spanish Version)

Jose_Manuel_Jurado on Jul 27 2022 04:42 AM
I had another great opportunity to deliver a session within program Microsoft Reactor with my colleague Pablo Javier Fer...
1,558

Resolve Elastic Query issues in Azure SQL Database

Holger_Linke on Jul 27 2022 04:39 AM
Elastic Queries are used to implement cross-database queries in Azure SQL Database. Elastic Query makes data located in ...
1,902

Lesson Learned #231: Hands-On-Labs: What is Azure SQL working on

Jose_Manuel_Jurado on Jul 24 2022 05:00 PM
One of the main questions that we have in a live performance troubleshooting scenario is to answer the question what is ...
1,030

Lesson Learned #230: Microsoft Reactor -Azure SQL Developer and DBA Best Practices (Spanish Version)

Jose_Manuel_Jurado on Jul 22 2022 10:00 AM
We had the great opportunity to deliver a session within initiative Microsoft Reactor with our colleague Pablo Javier Fe...
1,214

Lesson Learned #229: Hands-On-Labs - Connection is busy with results for another command

Jose_Manuel_Jurado on Jul 20 2022 07:04 PM
We used to have cases where our customer faced the following error messages like following: "ERROR [HY000] [Microsoft][O...
1,140

Lesson Learned #228: Using sp_validatelogins in Azure SQL Database

Jose_Manuel_Jurado on Jul 20 2022 06:41 PM
Today, we worked on a service request that our customer needs to use sp_validatelogins to verify if the user exists or n...
2,670

SQL Error Code 40532 Cannot open server 'azuresqlserver1' requested by the login.

Mohamed_Baioumy_MSFT on Jul 20 2022 03:14 AM
SQL Error Code 40532 Cannot open server 'azuresqlserver1' requested by the login. The login failed. (.Net SqlClient Data...
1,297

Lesson Learned #227: How much data is using my database per table

Jose_Manuel_Jurado on Jul 19 2022 08:34 AM
Today, we worked on a service request that our customer reported an unusual space used by their database. Checking the s...
801

Lesson Learned #226: Using a connectivity Retry-Logic with SQLCMD command line

Jose_Manuel_Jurado on Jul 19 2022 05:39 AM
Today, We have been working on a service request that our customer needs to implement a connection retry-logic using SQL...

Latest Comments

javiestevezuy
in Lesson Learned #238: Configuring Private Endpoint Connections in Azure SQL Managed Instance on Sep 24 2022 08:12 AM
Thanks for the article. I was under the impression that MI already offered private and public endpoints with different FQDN listening on different ports (1433/3342), which avoids problems with name resolution. If my understanding is correct…what would be the need for creating a private endpoint? Tha...
0 Likes
Colin_Hunter
in Azure SQL Database - GEO Replication across subscription with private endpoints on Sep 13 2022 06:04 AM
Hi,Are there issues with Geo Replication and SQL PrivateEndpoints when creating SQL servers initially (using ARM templates)?Trying to ascertain if this issue is only encountered post-creation
0 Likes
Ahmed_S_Mahmoud
in Principle 'XYZ' could not be found or this principal type is not supported - Azure SQL DB and MI on Sep 01 2022 08:59 AM
Thank You @Sabrin_Alsahsah for posting this blog, this really helping!
1 Likes
Johannes_Vink
in Principle 'XYZ' could not be found or this principal type is not supported - Azure SQL DB and MI on Sep 01 2022 06:14 AM
I ran into this recently: if you do not have rights to view users/groups in AAD, then you cannot add principals in Azure SQL DB. Check 1 listed in the document will show that the user/group is not visible to you.
1 Likes
jeanabedford-8211
in Get creation dates of all Azure resources under an Azure subscription on Aug 30 2022 10:40 AM
I also would like to see a way to verify who created an azure ad group ? the group is a year old. The date and time when the group was created is accessible in the overview. But not the initiator, or upn that created the group. And i can't search past 90 day in the activity log Any response would be...
0 Likes