When should MS SQL Server be preferred over other databases?

Question

SQL Server

Will I get any additional benefits by choosing a database from "Microsoft" instead of PostgreSQL or MySQL?
Is it worth it for the sake of their database, to understand c T-SQL, or are they all more or less the same now? I myself am a Windows user and
don’t really understand databases, so comparative tables don’t tell me much. Explain the difference.

Answer 1

MySQL has much weaker support for query execution
Up until 5.7 it didn't have procedures.
Although the structures of the language allowing the creation of procedures, MySQL after that appeared, as such, a programming language, performing logical operations, MySQL did not exist. Perhaps this has changed. But rather not.
Thus, MySQL cannot be called a full-fledged DBMS.
If someone may not be embarrassed by the creation of clustered indexes "by default", then for me the absence of such levers for managing the layout of digital records is unacceptable.
----
PosgreSQL database is on a completely different level, in terms of academic requirements, but up to the 9th version it suffered from the file-object structure of the record, that is, each table or index is its own file. The inevitable result was failures in the accuracy of data recording when the base was required to solve super-tasks. Transferring responsibility to the OS file system for accurate accounting of write operations led to the loss of user trust by the base itself (Uber).
The situation was fixed in an emergency, and now PostgreSQL is in perfect order. The backbone of the development team managed to quickly improve the situation through unbending will and amazing professionalism (as we all now lack in Russia after it was in abundance in Soviet times).
Therefore, with PostgreSQL today, the question is certainly not an easy one. But here, of course, the base, which is supported by exceptional personal sacrifices by a group of strong-willed and competent associates, is difficult to compete with a team that has a goal, a development plan, and a vision from the inside of the entire diversity of the digital industry.
No database will ever be able to boast full and ever-improving queuing support, built-in data integration catalogs, separate but well-tuned to work together on an OLAP service server, and a full-fledged data processing engine directly in memory resident executable ( Hecaton ). Plus a variety of data storage formats, flawless language support and character encodings, SQL Server is hard to compete with. And the ability to easily open the communication protocol and view requests made by the database through profiler makes the work of both the developer and the support service simple and easy for a person who has a family, children, parents, and something in life other than work.
----
I was writing this post and even then I thought that MySQL and PostgreSQL are not a complete choice from the possible list of SQL Server competitors in place of the DBMS. At one time I was interested in Linter. Previously, this DBMS was considered Russian, but in 2015-17, data on the purchase of the product by foreign citizens slipped through. Leaving the dark history of product rights aside, in my opinion, the base has all the necessary qualities to serve the digital enterprise.
Perhaps there are restrictions on the number of threads, the amount of stored data. This should probably be checked with the supplier.
I am constantly searching and evaluating Russian DBMS products, and I will be grateful for any tips and pointers.

Answer 2

https://www.enterprisedb.com/blog/microsoft-sql-se...