A candidate asked me in an interview: how do I get started with SQL Server 2016? Here is my answer for anyone who has not tried it yet.
SQL SERVER – Event 17058 – initerrlog: Could not Open Error Log File
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 – 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.
SQL SERVER – Unable to Start SQL Server After Patching
A reader could not start SQL Server 2008 R2 after SP1 because the script level upgrade failed with error 598. Here is what to check to start SQL Server again.
SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql)
Clicking New Query in SSMS threw cannot find template file for new query. Copying SQLFile.sql from another machine fixed it, and here is how.