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…
