The best RDBMS
April 26, 2016
The best RDBMS

Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
SQL Server is really crucial for our organization. It's used by our internal software (financial, accounting and so on), it is used by our CRM, by our gaming website, but also by our institutional website. So it's used internally but also for our main business (betting system and so on). MS SQL Server is administered by our team (database administrator team).
Pros
- Relational database: I think it's the best one in the market, at the moment
- Integration with tools like Visual Studio
- Business Intelligence
- Reporting
- OLAP Cubes (Analysis services)
- HA & DR (with always-on feature)
Cons
- Support for json, but "really"
- Support for document databases
- A better reporting tool
- Cons: hardware costs, because requires a lot of memory
- Pros: easy to develop on (sw developer already skilled on t-sql)
- Cons: licensing cost, because also read-only servers/nodes (used in ha & dr) have a price
- MySQL and PostgreSQL
Microsoft SQL Server is more secure and offers more robustness for our data. SQL Server is also great because of its integration with Microsoft Visual Studio. It's also great because developers can build reports and stuff like that from scratch. It's faster compared to PostgreSQL and now the integration within the cloud (Microsoft Azure) is unique and a great opportunity for dbas.
Comments
Please log in to join the conversation