A few days ago, I was working on a case where a customer reported an unexpected behavior in their application: even after switching the connection policy from Proxy to Redirect, the connections were ...

Issue  We recently encountered a support case where a customer was getting an error message while trying to restore a bacpac to an Azure SQL DB as the bacpac file was pointing to Prod external data...

Database Watcher was released in November 2024 and is a managed monitoring solution for databases. It is currently supported only for Azure SQL Database and Azure SQL Managed Instance. The setup proc...

Recently, we have been working on a support case where our customer reported the following error message: ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization...

On a recent case, a customer was trying to set up SQL Managed Instance Link to partner with an on premise Always On Availability Group (AG). Using the public documentation will work, but this will on...

  Optimized locking is a Database Engine feature introduced in 2023 that drastically reduces lock memory, and the number of locks required for concurrent writes. This is enabled by default for Azur...

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

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

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

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