We changed our name from IT Central Station: Here's why
Cancel
You must select at least 2 products to compare!
SQL Server Logo
19,554 views|14,983 comparisons
Vertica Logo
9,414 views|6,807 comparisons
Featured Review
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: January 2022.
564,322 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""The solution is easy to use.""I have seen that this is a very stable product.""The solution is stable.""I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.""We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use.""SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer.""It's more user-friendly than most databases."

More SQL Server Pros →

"I have found the solution to be scalable.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""The performance is very good and the aggregate records are fast.""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.""Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.""It has improved my organization's functionality and performance.""Speed and resiliency are probably the best parts of this product."

More Vertica Pros →

Cons
"While this is a reliable product, it has room for improvement.""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.""It would be ideal if the solution offered better integration capabilities.""Performance could be better. But I don't know if it's a problem with my application or with my database.""In terms of exceptionally large databases, it doesn't scale as well as Oracle.""Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits.""The treatment of database storage could be improved.""The solution needs to be more secure. It's lacking, compared to, for example, Oracle."

More SQL Server Cons →

"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.""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.""I have found that coding support could be simplified.""Support is an area where it could get better.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""They could improve on customer service.""When it is about to reach the maximum storage capacity, it becomes slow.""They could improve the integration and some of the features in the cloud version."

More Vertica Cons →

Pricing and Cost Advice
  • "SQL Server is a cost-effective solution for a small database."
  • "Pricing is reasonable for small organizations, but the scaling increases the price."
  • "We didn't have any licensing costs for SQL Server."
  • "We pay approximately $12,000 USD per month for both the server and the license."
  • "The price could be cheaper."
  • "Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • More SQL Server Pricing and Cost Advice →

  • "From a cost perspective, the software is less than most of its competitors."
  • "It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
  • "The price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • "The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    564,322 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    I have found SQL Server easy to use.
    Top Answer: 
    SQL Server could improve by having better usability or user guidance.
    Top Answer: 
    Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have… more »
    Top Answer: 
    The pricing could improve, it is a little expensive.
    Top Answer: 
    Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible. I know that's… more »
    Ranking
    1st
    Views
    19,554
    Comparisons
    14,983
    Reviews
    135
    Average Words per Review
    462
    Rating
    8.2
    3rd
    out of 30 in Data Warehouse
    Views
    9,414
    Comparisons
    6,807
    Reviews
    7
    Average Words per Review
    501
    Rating
    9.4
    Comparisons
    Also Known As
    Microsoft SQL Server, MSSQL, MS SQL
    Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
    Learn More
    Overview

    SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

    Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

    Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

    To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

    Offer
    Learn more about SQL Server
    Learn more about Vertica
    Sample Customers
    Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
    Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
    Top Industries
    REVIEWERS
    Financial Services Firm18%
    Computer Software Company13%
    Manufacturing Company11%
    Comms Service Provider5%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider22%
    Financial Services Firm7%
    Government5%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company32%
    Comms Service Provider21%
    Financial Services Firm7%
    Media Company4%
    Company Size
    REVIEWERS
    Small Business43%
    Midsize Enterprise21%
    Large Enterprise36%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    REVIEWERS
    Small Business31%
    Midsize Enterprise26%
    Large Enterprise44%
    Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: January 2022.
    564,322 professionals have used our research since 2012.

    SQL Server is ranked 1st in Relational Databases with 143 reviews while Vertica is ranked 3rd in Data Warehouse with 11 reviews. SQL Server is rated 8.2, while Vertica is rated 9.2. The top reviewer of SQL Server writes "Veteran solution with critical log shipping feature". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, IBM Db2 Database and Amazon Aurora, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, Oracle Exadata and Microsoft Azure Synapse Analytics.

    We monitor all Relational Databases 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.