An upgrade from SQL Server 2008 R2 to 2014 failed after the product key step with: the specified service does not exist. Here is the fix.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.
SQL SERVER – Upgrade Error: Microsoft NET Framework 4.0 Installation Has Failed With Exit Code – 2146498511
The solution of error Microsoft .NET Framework 4.0 installation has failed with exit code -2146498511 which was faced during SQL Server upgrade
SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time
Sometimes we need to find last reboot time of the server via some script. In this blog, I am sharing the script to find the last system reboot time.
SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)
I recently had a very simple and interesting error received while I was performing an upgrade mode with Docker and Persistence Storage for my upcoming workshop.
When Was SQL Server Last Restarted? – Interview Question of the Week #225
When was SQL Server last restarted? It is my first question in every Health Check, because a restart empties the DMVs and their performance history.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
SQL Server Configuration Manager missing from the Start Menu? Open it directly from C:\Windows\System32 with the SQLServerManager msc file for your version.