MonetDB vs Microsoft SQL Server

• It performs very well with both a simple and complex query with multiple join operations.
• It offers more advanced, enterprise level features such as clustering, data partitioning, and distributed query processing.
• Loading bulk data is quite fast by taking advantage of multiple cores/CPUs.

Read full review

• Easy to setup with the included Wizard that helps to get you up and running with the essential components covered. You won't waste a lot of time reading through documentation to just get started.
• There is a large community of support for Microsoft SQL Server that can help to troubleshoot issues and explain how to tackle a problem.
• The other components and modules to the system make is easy to setup backups and connections to other services.

Read full review

• This is an open source software so there are obvious drawbacks, the biggest of which is a lack of documentation.
• MonetDB does not seem to be well known outside of the academic environment so there is less information when you are searching for answers of any type.
• I'd like to see more use cases and/or best practices so that commercial companies like ours can optimally use all of its highly performant features.
• The code is written in C/C++ and this can be negative if you are a mainly java-shop and need UDF - User Defined Function.

Read full review

• There isn't as much that I dislike with SQL Server. It will be good to have features where we have fine grain control over internal things. For example, it would have been a good feature to have historical tracking of the metrics as opposed to setting up custom metrics. Overall SQL Server made my life easy to manage a lot of databases and ease of use while migration projects.
• The database is the target of many attacks from it's SA account, this must come disabled by default and just after the instalation, some of 30 seconds, the attacks start, with many requests per second, it needs to improve the firewall to prevent these attacks, or put the SQL Server inside of a VPN and local network to avoid these attacks.
• It requires knowledge and in-depth technical skills to make complex processes truly performing, especially if we are in very complex infrastructures

Read full review

• If you are familiar with a general database concept and played with open source products before then MonetDB will give you immediate return in terms of productivity since developers can quickly develop and verify their test cases involving back-end database with a large sample data set.
• There is a stiff learning curve due to lack of documentation and sparse information available on the internet.
• Overall experience has been positive since MonetDB gives you another option when it comes to building out a data warehouse.

Read full review

• We can very quickly and easily start up a new database.
• Active Directory integration has been a huge time saver for us.
• It changed the way we did our data backup strategy by giving us a backup 4-5 times a day instead of once at night.

Read full review