Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?
How to Get Started with SQL Server 2016? – Interview Question of the Week #086
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.
Msg 15559: Script Level Upgrade for master Failed
Msg 15559 says SQL Server cannot drop the ##MS_AgentSigningCertificate## certificate because a user is mapped to it. The upgrade script then fails with error 912 and the service will not start. Start the instance with trace flag 902, drop the mapped user and the upgrade can finish.
Error 598: SQL Server Fails to Start After Patching
Error 598 can stop SQL Server from starting right after a patch. In this case the script level upgrade failed because the service account could not create a temporary database file. Giving that account permission on the instance folder let the restart succeed.
Why SELECT 28F3 Returns 28: Float Literals and Hidden Aliases
Explain float literals, why SELECT 28F3 creates an alias, how 28E3 uses scientific notation, and why explicit AS prevents confusion.