I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server, since non-DBA server administrators would like to know more detail on this.  The process is not obvious from Control Panels’ Programs and Features (long list of components), so here’s my preferred method (*), which allows for a more specific uninstall, which can also include all the components at the same time (below you see these as the /Features list).  This can also save DBAs too, since there have been two occasions over the past three or so years, when the wrong instance name was installed, and we had to remove, reboot, and reinstall with the correct one afterwards. 

First thing you need is locate the SQL Server installation media, which is internally stored on our network shares for DBAs, or available from download on Microsoft’s site - just be sure to grab the correct version. If you don’t know the version you have installed, open up from the start menu Microsoft SQL Server, Configuration Tools, and finally SQL Configuration Manager. SQL Server Services…and in the right pane, if you see Service Type SQL Server, right click and view the properties. At the bottom of the Advanced page it should be clearly indicated what version is installed:

Then I went to command line under this directory and pasted the uninstall command from above, with the actual instance name, and with the necessary feature I have to remove (in my case, only a single component):
setup.exe /ACTION="unInstall" /INDICATEPROGRESS="TRUE" /FEATURES=SQLENGINE /INSTANCENAME="MicrosoftSCM"

And then all the dialogue boxes open up, since we asked to indicate progress with the /indicateprogress switch, which means that you’ll still see the command line running still behind the GUI, and can even find the sql server install bootstrap logs afterwards for review, in the case of error. Mine were stored to:

C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20160627_142130\

As of this status window above, I should be safe to proceed:

Chose the MicrosofSCM instance, and confirm the engine is to be removed. If we don’t know all the components installs, here’s the reason we use the show installation progress switch – it thankfully will tell you all that are related to this install automatically (so Select all if you want, in my case the SDK wasn’t the issue):

Confirm the rules, then finally, finally,

REMOVE J

Rejoice when you see that it has almost finished, and confirmed during the removal process.

It may not say it, but it sure is good to reboot after removing this instance and confirm upon restart.

Success, and quite a relief (bet you have rarely seen such a long uninstall, right?).

Note that as soon as you’ve exited the installation, the temporary folder that was created for the media is now gone. If you really want to clean up fully, delete the SQLEXPRE_x86_ENU.exe file from your downloads folder (or your respective version, SQLEXPRE_x64_ENU.exe for that platform).

* Nota Bene. this DB instance I am picking on, is just an example, not to say everyone must run out and remove it, since it could be in use by your workstation admins!