For example, you can finally, in the year 2016, split strings natively in TSQL:
https://www.brentozar.com/archive/2016/03/splitting-strings-...
Compare that to this SO question:
http://stackoverflow.com/questions/2647/how-do-i-split-a-str...
Note there are 32 answers on that question, many of which fail under various edge cases. Also notice that no one finds this situation absurd in the slightest (Stockholm Syndrome is alive and well in the MSSQL community apparently). This is just one example of the nonsense you have to put up with on SQL Server, there are many others.
And while PG is getting yet another new language capability, it appears Microsoft is pulling SQLCLR support (in Azure, so far):
https://www.brentozar.com/archive/2016/04/breaking-news-lite...
...which probably doesn't matter at the end of the day because almost no DBA would ever let you use it in production.
While it would cause harm to my personal career, nothing would make me happier than to see Postgres crush MSSQL, Microsoft has earned nothing less with their absolute disdain for their users.