SQL Server

What is the use of SQL Server in today's world? And how it is superior to other software of the same category?

If you need a relational database and your using a Microsoft stack then SQL server is a good fit.. superiority depends on the use case really, theres plenty of other options to meet different needs.

SQL is a language, not a particular software. I assume you mean microsoft sql server when you say sql server. To be honest, I never got to use it after college. I am more familiar with Mysql/mariadb and postgres, which should be a direct competition to mssql. In my opinion, these are far better than having to stick to microsoft.

It's easier to integrate for companies that use Microsoft environment with Windows Servers, active directory and other components.

Some ERP software like Sage, SAP Business One use SQL Server as their DB.

It's easy to work with using Microsoft SQL Management Studio.

If you know MySQL or Postgresql, you'll easily work with SQL Server.

For IM things it's better to use MySQL or Postgresql.