1.) Yes MSSQL sprocs are much more capable, but it's largely a matter of taste whether you encapsulate biz logic, or implement complexities like great circle distance algorithms, in sprocs or in funcs written in the app's language (Python, PHP, whatever).
2.) Transactional caoabilities are similar
3.) Data Recovery capabilities are similar
4.) Security: The current Linux edition of SQL Server doesn't support replication, you don't want that taken off the table in a robust overall security design, if you're serious about security you may not want your db to be running on Windows.
5.) Scalability: both scale to multi-terabyte db sizes, they're similar, see
http://searchsqlserver.techtarget.com/tip/SQL-Server-vs-MySQL
If your developers are more productive in .Net, MSSQL may be an advantage.
Edited 1 time(s). Last edit at 12/15/2017 09:43AM by Peter Brawley.