Most Helpful Review
Easy to use and integrates well with other Microsoft products, but the performance needs improvement, and there are...
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.
SQL Server is a stable product.
The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful.
The features that we have found the most valuable are reliability, availability perspective, and current scalability.
Very good security features.
The feature that I have found most valuable is that it is easy to code.
It helps with moving the design of the database into reality.
SQL is very easy to manage.
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'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 performance is very good and the aggregate records are fast.
Eighty percent of the ETL operations have improved since implementing this solution.
It maximize cloud economics for mission-critical big data analytical initiatives.
It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands.
The performance needs some improvement and it needs more features integrated into it.
The number of concurrent users is too limited and other databases are better than SQL in this regard.
CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server.
The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience.
Query optimitzer could be simplified.
In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages.
The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient.
Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization.
The geospatial functionality could be designed better.
Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.
Support is an area where it could get better.
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.
When it is about to reach the maximum storage capacity, it becomes slow.
Fact-to-fact joins on multi-billion record tables perform poorly.
It needs integration with multiple clouds.
Pricing and Cost Advice
Pricing is reasonable for small organizations, but the scaling increases the price.
SQL Server is a cost-effective solution for a small database.
It is expensive, but you get what you pay for.
Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license.
From a cost perspective, the software is less than most of its competitors.
It is fast to purchase through the AWS Marketplace.
The pricing and licensing depend on the size of your environment and the zone where you want to implement.
Questions from the Community
Question: What do you like most about SQL Server?
Top Answer: The availability is the most valuable feature. It has high availability. It also has good performance.
Question: What needs improvement with SQL Server?
Top Answer: In terms of improvement, it could use more integration with other products.
Top Answer: I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505
Question: What do you like most about Vertica?
Top Answer: The performance is very good and the aggregate records are fast.
out of 34 in Relational Databases
Average Words per Review
out of 32 in Data Warehouse
Average Words per Review
Compared 17% of the time.
Compared 15% of the time.
Compared 13% of the time.
Compared 10% of the time.
Compared 3% of the time.
Compared 23% of the time.
Compared 11% of the time.
Compared 10% of the time.
Compared 9% of the time.
Compared 6% of the time.
Also Known As
|Microsoft SQL Server, MSSQL, MS SQL||Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand|
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.
Learn more about SQL Server
Learn more about Vertica
|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.|
Computer Software Company13%
Financial Services Firm10%
Comms Service Provider7%
Computer Software Company37%
Comms Service Provider9%
Computer Software Company20%
Marketing Services Firm17%
Comms Service Provider13%
Computer Software Company42%
Comms Service Provider11%
K 12 Educational Company Or School5%
See our list of best Relational Databases vendors.