This article will show you the key architectural differences between Teradata and SQL Server and the similarities and performance implications. The article Teradata versus SQL Server will be regularly expanded or updated.

The bottleneck of database systems has always been accessing the data. As soon as the data is in the main memory, it can be processed. Even though mainly SSDs are now used, and less and less hard disks, copying the data into the main memory is still the slowest process. Teradata WAL is a feature

Teradata moved towards the cloud in order not to lose the connection to modern cloud databases. How the essential things like security, backups, sizing are solved, I show you with the AWS Cloud solution from Teradata.

What Are Zero-Copy Clones? We all know the following situations: For certain operations, we need to make a backup of tables before making changes. If the tables are relatively small, this is not a big issue. A copy can be made quickly, and in case of an error, it is easy to revert to the

Cloud databases put traditional MPP systems in the area of data warehousing under increasing pressure. Why this is so and the advantages and disadvantages of both types of database systems I show you in this blog post. The Architecture Of A MPP Database System MPP database systems are shared-nothing systems. Each node has its CPU,

In this article, I will explain the main differences in the Architecture between Teradata and Snowflake. It is not meant to be a complete comparison of all features or advantages and disadvantages but is limited to the differences from an architecture perspective. Snowflake vs. Teradata Architecture Snowflake vs. Teradata Summary As you have seen, at

This blog post will compare the architecture of these two popular database systems. As you will see, they are not that far apart, and you will find much of what you know about Teradata in Amazon Redshift. Even though Amazon Redshift always stores the data in columns, the similarities are big. And meanwhile, Teradata is