SQL Server DBA: SQL Error Logs

Search sqlserver-dba.com

Follow sqlserver-dba.com

*Use the Comments section for questions

SQLServer-DBA.com Links

July 20, 2023

Sql certificate chain was issued by an authority that is not trusted

How to solve the certificate chain was issued by an authority that is not trusted? Why the certificate chain was issued by an authority that is not trusted? Read more →

Posted at 12:41 AM in Security Management, SQL Error Logs, SQL problems, SQL Server Error Tips | Permalink | Comments (0)

April 17, 2023

Trace flag 902 in SQL Server and Error 574

What is Trace Flag t902?How to check trace flag in SQL Server? Read more →

Posted at 11:51 PM in Default Trace, SQL Error Logs, SQL Server Error Tips | Permalink | Comments (0)

February 20, 2023

Tcp port is already in use.How do I check if a port is already in use?

how do I check if a port is already in use? Read more →

Posted at 03:48 AM in Powershell, Security Management, SQL Error Logs, SQL Server Error Tips | Permalink | Comments (0)

July 14, 2021

How to fix Invalid comparison due to NO COLLATION

Unusual no collation error on a SQL Server 2017 Read more →

Posted at 08:37 AM in SQL Error Logs, SQL Server Error Tips | Permalink | Comments (0)

April 19, 2021

How to capture deadlocks using system_health Extended Events

Find SQL Server deadlock details easily with Extended Events Read more →

Posted at 02:21 AM in Deadlocks, Default Trace, extended events, SQL Error Logs | Permalink | Comments (0)