The best RDBMS
April 26, 2016
The best RDBMS
Score 8 out of 10
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).
- Relational database: I think it's the best one in the market, at the moment
- Integration with tools like Visual Studio
- Business Intelligence
- OLAP Cubes (Analysis services)
- HA & DR (with always-on feature)
- 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.
MS SQL Server is ok for classical relational databases, but also for datawarehousing db. It's not made for document databases, but it works very well with very large databases or high transactional systems and so on. It's great because with its integration with Visual Studio and other tools, it offers platforms for Business Intelligence, Reporting and OLAP cubes in a single solution. No one has all these features in one software, and Ms Sql Server is great for that! Being always-on, it's also easy to implement a disaster recovery solution or simply high availability. In the past it was a little bit hard work to do log shipping or replica (transactional replication) or mirroring.