Yes, you can spin an instance up and configure everything with Power Shell (if you have a lot of instances).

SQL Server's a little harder to setup but it scales really well vertically (unsurprising given its Enterprise origins). As with most databases it really needs to be installed on physical hardware for the best performance.