Recent Blog ArticlesMost RecentMost LikesLesson Learned #516:Measuring and Optimizing Application Performance A few days ago, I worked on a support case where the customer reported that their process was taking too long. I want to share the lessons we learned about measuring execution and reviewing performan...Lesson Learned #515:Recommendations for Troubleshooting - Login failed for user 'XXX'. (18456) During a recent support case, a customer encountered the error:pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user 'XXX'. (18456) (S...Lesson Learned #514: Optimizing Bulk Insert Performance in Parallel Data Ingestion - Part1 While working on a support case, we encountered an issue where bulk inserts were taking longer than our customer’s SLA allowed. Working on the troubleshooting scenario, we identified three main fac...Lesson Learned #513: Using SQL Copilot and Python Retry Logic to Resolve Deadlocks in Azure SQL DB A few weeks ago, I worked with a service request where our customer has a Python application that was reporting a deadlock with the following error message: INFO:root:Connected to the Database...Lesson Learned #512: Handling Connection Reuse in ODBC After a Critical Error Working on several connectivity cases with ODBC across different programming languages, I’ve noticed a behavior that I would like to share, as it can lead to incorrect conclusions about whether a con...Lesson Learned #511: Timeout Attempting to Open the Connection in High-Thread Applications Recently, I worked on a service request that a customer application reported the following error connecting to the database:"Timeout attempting to open the connection. The time period elapsed prior ...Lesson Learned #510: Using CProfiler to Analyze Python Call Performance in Support Scenarios Last week, while working on a support case, our customer was facing performance issues in their Python application. After some investigation, I decided to suggestCProfiler to identify which functi...Lesson Learned #509: KeepAliveTime parameter in HikariCP Today, I have been working on a service request where, at certain times, we observed that connections could be disconnected due to external factors such as firewalls or other components due to inacti...Lesson Learned #508: Monitoring Wait Stats and Handling Large Data Set Sometimes, we get asked how much data the client application is receiving from Azure SQL Database, along with the time spent and the number of rows returned. I would like to share a simple example ...Lesson Learned #507:Error 4429 - View or function 'XYZ' contains a self-reference. This last week, we worked on a service request where our customer got the following error message: "Msg 4429, Level 16, State 1, Procedure Viewd, Line 2 [Batch Start Line 9] View or function 'Viewa'...
MicrosoftMicrosoftMicrosoftMicrosoft
