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
968

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,191

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,009

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,028

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...
55K

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,002

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,754

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,380

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,387

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,318

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,914

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,179

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,360

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,018

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...
950

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,509

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,877

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,005

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,180

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,118

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,420

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,273

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...
771

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...
1,548

Lesson Learned #225: Has an unresolved reference to object using Linked Server or External Table

Jose_Manuel_Jurado on Jul 16 2022 05:29 PM
We used to have cases when our customers are trying to export their database using SQLPackage or Export service in the P...
2,096

Lesson Learned #224:Hands-On-Labs: Checking the performance with Perf Collector Analyzer

Jose_Manuel_Jurado on Jul 16 2022 05:59 AM
One of the main problem that we have when we are working with multiple databases in an Elastic Databases Pool or Azure S...
2,155

Lesson Learned #223:Hands-On-Labs: How to improve a bulk insert process

Jose_Manuel_Jurado on Jul 16 2022 05:05 AM
We used to have cases where our customers reported that they need more throughput using a bulk insert process for their ...
1,914

Lesson Learned #222:Hands-On-Labs: Configure/Troubleshoot Linked Server Azure SQL Managed Instance

Jose_Manuel_Jurado on Jul 11 2022 02:41 PM
We used to have cases where our customers reported configuration and connectivity issue at the moment of the creation of...

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