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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
Jose_Manuel_Jurado
in Testing connectivity against a Managed Instance using a CNAME on Jul 29 2022 10:21 AM
Great article! Thanks @luisaranda 
1 Likes
Zodian
in Editing a .bacpac file on Jul 28 2022 04:12 AM
Step 5. Instead of stuffing around with scripts you can use Powershell's inbuilt command: "Get-FileHash .\model.xml" this will compute the exact same hash.Also useful for other algorithms.
0 Likes