User Profile

Jose_Manuel_Jurado

Microsoft

Joined 8 years ago

471 Posts271 Likes

View All Badges

User Widgets

Recent Discussions

No content to show

Recent Blog Articles

Lessons Learned #538: Printing One Line Per Field in T-SQL in Azure SQL Database.
Working on a case with a huge number of columns I needed to dump records as one line per field. Happy to share this script that it was useful. For example, I would like to have the data in this way. ...
Oct 30, 2025 Place Azure Database Support Blog
117Views
0likes
0Comments
Lessons Learned #537: Copilot Prompts for Troubleshooting on Azure SQL Database
We had the opportunity to share our experience in several community sessions how SSMS Copilot can help across multiple phases of troubleshooting. In this article, I would like to share a set of promp...
Oct 21, 2025 Place Azure Database Support Blog
265Views
0likes
0Comments
Lessons Learned #536: Error the database type is not understood by the data reader.
This week we have been working on a support case where our customer had the following message 50006: Error the database type is not understood by the data reader when exporting using SQL Server Manag...
Oct 02, 2025 Place Azure Database Support Blog
88Views
0likes
0Comments
Lessons Learned #535: BACPAC Import Failures in Azure SQL Database Due to Incompatible Users
We recently worked on a support case where a customer was trying to import a BACPAC file, generated on a different server and subscription, into their Azure SQL Database. The process kept failing wit...
Sep 19, 2025 Place Azure Database Support Blog
157Views
0likes
0Comments
Lessons Learned #534: Azure SQL Database Connections with Managed Identity and Python ODBC
We worked on a service request that our customer trying to enable their Python application, hosted on Azure App Service, to connect securely to Azure SQL Database using a user-assigned managed identi...
Aug 01, 2025 Place Azure Database Support Blog
205Views
0likes
0Comments
Lesson Learned #533: Intermittent Azure SQL Database Connectivity and Authentication Issues
While working on a recent service request, we helped a customer troubleshoot intermittent connection and authentication failures when accessing Azure SQL Database using Active Directory (Entra ID) au...
Aug 01, 2025 Place Azure Database Support Blog
244Views
1like
1Comment
Lesson Learned #532:Power BI Refresh Failure Due to Connection Pool Exhaustion in Azure SQL Database
We've been working on a service request that a customer experienced frequent failures when refreshing Power BI reports connected to an Azure SQL Database. The error message indicated a problem with a...
Aug 01, 2025 Place Azure Database Support Blog
122Views
0likes
0Comments
Lesson Learned #531: Scalar UDF vs Parallelism
Last week I worked on a support case where our customer reported that the exact same query, executed against two identical databases with the same resources, was taking significantly longer on one of...
Jul 31, 2025 Place Azure Database Support Blog
172Views
0likes
1Comment
Lesson Learned #530: Comparing Execution Plans to Expose a Hidden Performance Anti-Pattern
One of the most powerful features of SSMS Copilot is how it lets you compare execution plans and immediately show you performance issues. In this case, I would like to share with you my lesson lear...
Jul 15, 2025 Place Azure Database Support Blog
182Views
0likes
0Comments
Lesson Learned #529: Troubleshooting Application Slowness Using SSMS Copilot
Some days ago, I worked on a support case where a customer reported application slowness affecting multiple users. Instead of jumping into traces or manually writing diagnostic queries, we used SSM...
Jul 15, 2025 Place Azure Database Support Blog
187Views
0likes
0Comments