Lesson Learned #262: Database Wait Stats and Log Analytics.

Yesterday, we received a question from our customer that needs to know if it is possible to receive an email or alert about the main database wait stats usage for performance monitoring. Following, I would like to share an example how to do it.&nb… Continue reading Lesson Learned #262: Database Wait Stats and Log Analytics.

Lesson Learned #261: Java vs Permission denied: connect

Today, I worked on a service request that our customer got the following error message using Java code: 
Exception in thread “main” com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host servername.database.windows.net,… Continue reading Lesson Learned #261: Java vs Permission denied: connect

Lesson Learned #260: Java vs Connection is closed error message.

Today, I worked on a service request that our customer got the following error message using Java code: Exception in thread “main” com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.at com.microsoft.sqlserver.jdbc.SQLServerE… Continue reading Lesson Learned #260: Java vs Connection is closed error message.

Lesson Learned #259: Capturing all blocking TSQL in Azure SQL DB and Managed Instance

Today, I worked on a service request that our customer is looking for all blocking issues that is happening in their database. We have many articles about it Lesson Learned #22: How to identify blocking issues? – Microsoft Community Hub and i… Continue reading Lesson Learned #259: Capturing all blocking TSQL in Azure SQL DB and Managed Instance