I noticed that SQL Server Web is vastly cheaper than SQL Server Standard on Amazon Web Services. Why is that? What am I missing if I use SQL Server Web instead of Standard?
Standard has more roles, like Domain Controller, File Server and all sorts of other enterprise roles. Web has only Web Server, DNS etc, which is good for web hosting. Web is much cheaper, because is designed for scale-up, were you dont need a CAL for each visitor accessing the server via internet, while for the File Server in standard, you pay for each domain user or domain PC.