User Profile

Jose_Manuel_Jurado

Microsoft

Joined Nov 29, 2018

472 Posts272 LikesLikes received

View All Badges

User Widgets

Recent Discussions

No content to show

Recent Blog Articles

Lessons Learned #539: Azure SQL DB Scale-Down from S3 to S2 Can Fail When Change Feed Is Enabled
Recently, I worked on a service request where a customer reported that an Azure SQL Database could not be scaled down from Standard S3 to Standard S2. The operation failed with the following message:...
Mar 19, 2026 Place Azure Database Support Blog
52Views
0likes
0Comments
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
155Views
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
324Views
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
121Views
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
249Views
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
275Views
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
307Views
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
163Views
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
211Views
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
226Views
0likes
0Comments