SQL Server would not start and there was no ERRORLOG. Event 17058, initerrlog: Could not open error log file, came from missing permissions on the Log folder.
SQL SERVER – What is Deadlock Scheduler? How to Reproduce it?
If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler.
SQL SERVER Installation – FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed
SQL Server Installation failed on rule FeatureUpgradeMatrixCheck: the edition upgrade from Enterprise to Evaluation is not supported. Here is why and the fix.
SQL SERVER – Install Error – Could not Find the Database Engine Startup Handle
Install error: Could not find the Database Engine startup handle. This error has many causes, and here is one I found while helping a client.
Reading the system_health File Target With Plain T-SQL
Locate the system_health file target, read its retained events with T-SQL, and inspect serious errors, connectivity records and waits.
SQL SERVER – Detected a DTC/KTM in-doubt Transaction with UOW
A client database went SUSPECT after a cluster failure and DTC reinstall. The ERRORLOG showed a DTC/KTM in-doubt Transaction with UOW. How we fixed it.
SQL SERVER – Fix Error Msg 13602 working with JSON documents
Working with JSON documents in SQL Server 2016? You can’t use FOR JSON inside an UPDATE statement, and trying gives Msg 13602. Here is how to work around it.