Gary Varga (2/27/2015)
thottle (2/27/2015)
...One of the restrictions Steve did not mention is that Express, under license, cannot be used for an outward facing web site...I believe that this was the case but I cannot find evidence that it still is. Does anyone?
Microsoft say:
Build web and mobile applications for multiple data types
Support structured and unstructured data while storing business data with native support for relational data, XML, and spatial data. Add geographical information to business applications and build location-aware applications. Increase granularity of temporal data with date and time data types.
Thank you. I have at least one client using Express for an outward facing web site, and went looking when I saw Gary's comment. I couldn't find anything to for or against Gary's comment so nice to see yours.
Obviously mine is a bit of a me too comment. Have Express in a number of production databases for a number of clients. In some cases it is just deferring the cost, often by a few years , and that is fine in all cases so far. The gotcha is always the 1GB limit, I'm yet to hit the 10Gb limit with an express database. Although have a 7Gb at a location that is still on express, but in the next 6 months will need to go up.
Backup and any scheduled jobs I simply handle via windows Task scheduler