just ended up googling "how to fucking install bullshit ms sql 2014 local db on fucking win 7 workstation" - was quite surprised about the amount of (more or less) matching results

It's quite easy actually. Double click and follow the wizard. Nothing like installing Postgresql and making sure to edit the right settings file and update the right permissions with the right string, before moving on to another config file and make the server listen to all IPs