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
1,159

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Lesson Learned #211: Monitoring SQLPackage Import Process

Jose_Manuel_Jurado on Jun 27 2022 06:08 PM
We used to have cases where our customer asked what is current of SqlPackage state, do I need more resources in my datab...
857

Lesson Learned #210: Hands-On-Labs:A transport-level error has occurred when receiving results.

Jose_Manuel_Jurado on Jun 26 2022 05:37 AM
We used to have cases where our customer faced the following error message: "A transport-level error has occurred when r...

Latest Comments

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
luisaranda
in Testing connectivity against a Managed Instance using a CNAME on Jul 29 2022 04:24 PM
Thank you @Jose_Manuel_Jurado! My pleasure
0 Likes
maximumnull
in Extended Events Capture Step by Step Walkthrough on Jul 29 2022 11:40 AM
@Azure-DB-Support-Team can you please make these images any larger? I can barely see anything in the screenshots.
0 Likes