Interviews are two way streets, sometime interviewer asks questions and sometime candidate asks questions. In a recent interview, I was asked by a candidate “How to Get Started with SQL Server 2016?”. I think it is a very good question. Let us discuss that today.
SQL SERVER – Event 17058 – initerrlog: Could not Open Error Log File
If you have ever interacted with me or taken my services, you would notice that I always ask for ERRORLOG in almost all of my contact with my client. Once of my friend contacted me and when I asked for ERRORLOG, he informed that there is no ERRORLOG file and SQL is not getting started. I suggested him that we should analyze event log for further details, after interestingly, we found the following details in the event 17058 about initerrlog: Could not Open Error Log File.
SQL SERVER – Install Error – Could not Find the Database Engine Startup Handle
Note: There are multiple reason of above error and this blog shows just one of them. I am sure that this blog would give you guideline about what do to in case you see this error about install error.
SQL SERVER – Unable to Start SQL Server After Patching
I have an issue on my UAT environment. I was unable to start the SQL server 2008 R2 instance after applying SP1. Let us learm more about it.
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)
Just a day ago while playing with SQL Server I suddenly faced a new kind of error, which I have never seen before. This error happens when clicked on New Query in SQL Server Management Studio. Let us learn in this blog post how we will fix the error – cannot find template file for a new query.Â