SQL Server Review
Updated June 19, 2021
SQL Server Review
Score 8 out of 10
Overall Satisfaction with Microsoft SQL Server
We use MS SQL Server as our main database to store customer data. We have a monolith web application that is using a single MS SQL Server database. MS SQL is one of the best RDBMS in terms of speed and its really easy to use with a lot of pre-built functions that are really convenient for our application.
- It has quite a lot of pre-built function that helps speed up development time.
- One of the fastest SQL database engines.
- Built for enterprise use with enterprise-level of support available.
- It could be very expensive to utilize MS SQL server to its full potential due to the licensing tier limit.
- It does not have a built-in JSON type column, unlike PostgreSQL, although it has built-in functions to help to work with JSON.
- Require more space to install the database engine compared to other SQL databases.
- The faster development time for the application since there's quite a lot of handy built-in functions available to use.
- Single database for fairly large data which relatively easier to maintain.
- Doesn't need to optimize that much since its relatively quick to begin with.
- PostgreSQL and MySQL
MS SQL Server is easier to use compared to other RDBMS which really speeds up development time and relatively easier to find a problem when it happens as well. It's also pretty quick to run a query, especially in a large table make it pretty convenient if we need to monitor the whole data in a table.
While its really convenient to use for me as a web developer, its fairly expensive to use in a production environment. I need to explain or justify the choice of using MS SQL Server against its pricing tier which is pretty expensive. We need to think about how to keep the whole infrastructure cost reasonable while keeping MS SQL Server.
Do you think Microsoft SQL Server delivers good value for the price?
Are you happy with Microsoft SQL Server's feature set?
Did Microsoft SQL Server live up to sales and marketing promises?
Did implementation of Microsoft SQL Server go as expected?
Would you buy Microsoft SQL Server again?
If you need RDBMS for an enterprise that needs to be fast and reliable without looking at the pricing or if you or your company are willing to pay a premium price for the best quality, MS SQL Server is your best choice. However, if you are a small startup that doesn't have a lot of data and not so complex application to use the database, PostgreSQL or MySQL might be better for you.