T-SQL is the poorest rdbms language ever existed. Microsoft didn't bother to implement very simple string, datetime functions for 15 years where Postgresql is very rich in that department. So please don't speak about how microsoft tooling is rich.
SQL Server Management Studio is light years ahead of any pgsql management tool
The official pg client, psql, is light years ahead of SQL Server Management "Studio".
We can rehash all the same old arguments from the 90s and 00s about command line vs gui but that would not be productive. If you want to interact with mssql using the command line, use sqlcmd
or pgcli for that matter
The editor in SSMS can do everything pgcli can do and more.
ruh-roh, master-master replication, multithreaded eexecution, vacuuming tables, in-memory OLTP. Yes postgres is cutting edge and without blame. Stay away from the evil SQL Server, nothing to be gained there.
What about true MVCC?
READ_COMMITTED_SNAPSHOT?
It uses tempdb for tracking versions, it is not mvcc in the core