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."SQL Server scales well."
"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."
"The solution is stable."
"The performance is reliable."
"The fact that SQL Server fully integrates within the entire Microsoft ecosystem is a plus."
"I like that it's very easy to use, and Veeam is excellent. There are tons of experts and writers in the area now, and we don't find the same for other databases."
"If you need to, you can scale the solution very easily."
"I would say that it is a stable product."
"Speed and resiliency are probably the best parts of this product."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"The most valuable feature of Vertica is the unmatchable database performance."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"I would like to see the performance improved. Migrating should be easier and the scalability needs improvement."
"While using it, we really didn't experience any pain points."
"I would like to see more integration with other platforms."
"The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite."
"It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load."
"SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance."
"The backup capacity needs to be bigger."
"The tool needs to improve its pricing and technical support."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"The geospatial functionality could be designed better."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"Support is an area where it could get better."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"The integration of this solution with ODI could be improved."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
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, BigQuery and Oracle Exadata.
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.