SQL Server Configuration Manager missing from the Start Menu? Open it directly from C:\Windows\System32 with the SQLServerManager msc file for your version.
SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation
Removing extra TempDB files failed with Msg 2555: Cannot move all contents of file to other places to complete the emptyfile operation. Let me show you the steps.
SQL SERVER – Which Settings Change in sp_configure Needs Restart to Take Effect?
Which settings changed in sp_configure need a restart to take effect? You do not need to remember them, because a catalog view added in SQL Server 2008 tells you.
SQL SERVER – Cluster Install Failure – Code 0x84cf0003 – Updating Permission Setting for Folder Failed
A SQL Server cluster install failed with code 0x84cf0003: Updating permission setting for folder failed. Here is why volume mount points can cause it.
SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components
My SQL Server 2017 install got stuck at Offline Installation of Microsoft Machine Learning Server Components. Here is why it happens and how to move forward.
SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect
Uninstalling SQL Server from the command line, I got: The syntax of argument “/ACTION” is incorrect. Here is what the error means and how to fix the command.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
My machine crashed mid-install, and uninstalling SQL Server 2017 then failed with: Index was outside the bounds of the array. This is how I cleaned it up.