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."It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching."
"SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
"I haven't really experienced any issues that required the assistance of technical support."
"The interface is user friendly."
"The Always On tool improves the SQL server availability."
"They have improved the UI and ease of accessing the database and server which is good. You can load it up and start using it from the very minute it is implemented."
"From a security perspective, we have no complaints."
"The solution is very common. It's easy to use."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Allows us to take volumes and process them at a very high speed."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities."
"The agility of the non-SQL-based features is relevant on the market."
"SQL Server doesn't have proper bitmap indexing, proper columnar databases, or proper implementation of materialized views."
"SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."
"The tool needs to improve its pricing and technical support."
"It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it."
"The solution could be more secure."
"Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems."
"The integration of this solution with ODI could be improved."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"I have found that coding support could be simplified."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"They could improve on customer service."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
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.