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
356

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Lesson Learned #221:Hands-On-Labs: Activity Monitor in my Azure SQL Managed Instance

Jose_Manuel_Jurado on Jul 09 2022 03:08 PM
We used to have cases where our customers reported a performance issue that is causing delay in their business, In this ...
1,885

Lesson Learned #220:Hands-On-Labs: Activity Monitor in my Elastic Database Pool

Jose_Manuel_Jurado on Jul 09 2022 04:40 AM
To be honest, this post is one of my favorites that I was looking to post due to many questions that we get from our cus...
1,413

Lesson Learned #219:Hands-On-Labs: What do I need to do in case of high CPU wait time

Jose_Manuel_Jurado on Jul 07 2022 04:38 PM
We used to have cases where our customers reported a performance issue that is causing delay in their business. Working ...
1,335

Lesson Learned #218:Hands-On-Labs: What do I need to do in case of high LOG_RATE_GOVERNOR wait time

Jose_Manuel_Jurado on Jul 06 2022 02:21 PM
We used to have cases where our customers reported a performance issue that is causing delay in their business. Working ...
1,000

Lesson Learned #217:Hands-On-Labs:40197-The service has encountered an error processing your request

Jose_Manuel_Jurado on Jul 05 2022 04:42 PM
We used to have cases where our customer faced the following error messages like following: Msg 40197, Level 20, State 4...
1,242

Lesson Learned #216: Hands-On-Labs: How redirect connection policy type works

Jose_Manuel_Jurado on Jul 04 2022 11:29 AM
We used to have cases where our customers asked questions about redirect connection type policy, How works? What is the ...
1,316

Lesson Learned #215: Hands-On-Labs: Communication link failed error message using ODBC.

Jose_Manuel_Jurado on Jul 04 2022 09:42 AM
We used to have cases where our customer faced the following error messages like following: ERROR [08S01] [Microsoft][OD...
1,341

Lesson Learned #214: Hands-On-Labs: How to manage an idle connection state issue

Jose_Manuel_Jurado on Jul 03 2022 01:27 PM
We used to have cases where our customers leave the connection open without any activity, as you could see in this URL w...
1,096

Lesson Learned #213: Cannot set the AccessToken property if the Integrated Security has been set

Jose_Manuel_Jurado on Jul 01 2022 01:43 AM
Today, I worked on a service request where using SQLPackage and Azure Active Directory user our customer got the followi...
1,436

Lesson Learned #212: Hands-On-Labs:TCP Provider: The semaphore timeout period has expired

Jose_Manuel_Jurado on Jun 28 2022 04:11 PM
We used to have cases where our customer faced the following error message: "TCP Provider: The semaphore timeout period ...

Latest Comments

JulioQueiroz
in VA Failed message: Could not authenticate to storage account 'storageaccount.blob.core.windows.net' on Aug 10 2022 09:39 AM
just go to the storage account IAM menu and add the managed identity (resource name) for the resource generating the assessment report. In your case, the SQL server.
0 Likes
adam_schildmeyer
in Restore database across servers(Azure SQL Database and Azure SQL managed instance)- Azure Automation on Aug 09 2022 04:16 PM
@Sabrin_Alsahsah This is a great write up and was almost exactly what I was looking for. I was wondering if you had any tips to do it in bulk across subscriptions? Like when we do restores from production to lower environments it's usually more than just one database. But usually a whole instance/se...
0 Likes
danielsuarezdata
in Lesson Learned #98: Is possible to create an extended event on the server in Azure Managed Instance? on Aug 08 2022 07:48 PM
Thanks for the information, I struggled finding the right type of target to use for Managed Instances.I would like to add that the Kind of the Storage Account to be used should be StorageV2. Using Kind BlockBlobStorage will throw the following error: The target, "xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx....
0 Likes
esteban-bermudez
in Editing a .bacpac file on Aug 07 2022 04:48 PM
step #6 update: you cannot just rezip the bacpac. you need to keep the original bacpac format, open it in winrar/winzip, and just add origin.xml into it. if you unzip the backpack into a folder and then just repack it into a zip it will fail when doing the import, as it will think it has corrupted d...
0 Likes
mcphejoh
in Using Managed Service Identity (MSI) to authenticate on Azure SQL DB on Aug 04 2022 09:29 AM
I have been doing research into the containerization aspect of web applications with Azure connected resources. The code and this blog have been very helpful in understanding how all this works. many thanks.
0 Likes