A stable, scalable solution with excellent administration
What is our primary use case?
We primarily use the solution for transactional processing, our LTP, as well as other processing.
Pros and Cons
"It's quite easy to install and use from a local machine or laptop, as well as on a server."
"The lock files and login are two features we've had issues with. As far as I can see, there's no way to switch off the login in SQL Servers. If there could be a way to switch off the login, for transactions, or in operations, or tables, that'd be great."
What other advice do I have?
We use the on-premises deployment model. In terms of advice I would give to others, I would say that if they want to evaluate it, they should install a SQL Server Express. Install that as a management studio to get a feel for how it works, and then from there decide if it's suitable, in terms of a full license installation. You can get up and running with it, and play around with it quite easily. Once you install SQL Server Express, you can get a good feel for how the full SQL Server would be set up and maintained, and how it works. If you're going to do a large database setup, make sure you…