Buy MS SQL Server is a relational database management system based on the client-server model. A lot of new words have been heard - we will now figure out in order what it all means.
Relational bases are databases where all data is stored in the form of tables, and these tables are linked to each other: one to the other, the other to the third, and so on.
"Client-server" means that all logic of working with the data is carried out to the server, and users connect to it through applications-clients. The idea is that we don't have to keep the full version of the database on our computer - just have a good Internet.
Moreover, the SQL Server ecosystem can also be deployed in the cloud: in this case, the database isined by the Microsoft data centers, and you can focus on the development of client applications. The version of SQL Server that allows this is called Azure SQL.
Since SQL Server is a Microsoft SUBD, it is mainly focused on Windows, although it also supports Linux in part. Partly because the version for this system does not have some important functions. Therefore, if you are looking for a SUBD for a Linux machine, it is better to further explore competitors.