We performed a comparison between SQL Server and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."The performance is great."
"It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms."
"Enables us to convert to bigger DBs and more easily move or upgrade between branches."
"For my business requirements, the performance is good."
"SSAS is the most interesting feature to organize the data and let the users play with it."
"Its availability for a secured server is one of its most valuable features. Also its replications - we can manage eight replicas. Their clustering and availability groups are also valuable."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"Partition and join back to node are easy and simple for DBAs."
"I enjoy the cybersecurity and backup features."
"Allows us to take volumes and process them at a very high speed."
"I like the projection feature, which increases query performance."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"I would like to see more integration with other platforms."
"Third-party services from Redgate should be built-in to it, like SQL Search."
"Could have additional security."
"The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."
"There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."
"The solution could offer more integration with other platforms."
"It should provide a GUI interface for data management and tuning."
"I believe the installation process could be streamlined."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"Very bad support, I would rate it two out of 10."
"Documentation has become much better, but can always use some improvement."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The integration with AI has room for improvement."
SQL Server is ranked 1st in Relational Databases Tools with 260 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. SQL Server is rated 8.4, while Vertica is rated 8.2. The top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Informix, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, Oracle Exadata and BigQuery.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.