"It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner."
"It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based. It is a very stable product, and it has got backup and recovery tools."
"The performance of the SQL Server is very good."
"Scalability, cluster ability, ease of use, ease of implementation — these are all great."
"A big advantage is the ability to store any type of data in SQL Server."
"SQL Server is a stable product."
"The solution is easy to set up."
"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
"The functionality of the solution is excellent."
"The flexibility in design is very good."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"The performance is great, we are able to query our data in one operation."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"I would like to see the database become fully automated."
"Although I am satisfied with the solution, some clients have asked us to resolve technical issues, such as those involving silver solution and replication."
"There are a few use cases where we do need the Active-Active options instead of Active-Passive, yet those kinds of options are not available for Microsoft."
"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 licensing costs are very high."
"The solution could use better governance on the management side, especially around data governance."
"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."
"The solution could be better when it comes to security."
"I would like to see more integration with many different types of data."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"It could use some more advanced analytics relating to structured and semi-structured data."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"The scalability could be better. The on-premises solution is always more complicated to scale."
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.
Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.
SQL Server is ranked 1st in Relational Databases with 143 reviews while Teradata is ranked 6th in Relational Databases with 7 reviews. SQL Server is rated 8.2, while Teradata is rated 8.4. The top reviewer of SQL Server writes "Veteran solution with critical log shipping feature". On the other hand, the top reviewer of Teradata writes "Good performance, flexible, easy to tune queries, and scales well". SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, IBM Db2 Database and MariaDB, whereas Teradata is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Vertica and Microsoft Azure Synapse Analytics. See our SQL Server vs. Teradata report.
See our list of best Relational Databases vendors.
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.