Where to start?
Great range of admin tools (far outnumbers MYSQL) - I like the database tuning tools
Nice BI tools and integration ability.
Evolves quickly due to the monster support from MS
Integrates with the rest of MS products (this is a plus and a minus, of course)
Scalable - a few MBs up to petabytes.
High availability/failover clustering makes DR straightforward.
Own reporting services - if you can't report on it, it's hard to manage.
Problems include - is it an MS product? Then licensing can be a pain if they do an audit.
Also, with AWS's offerings becoming so easy to set up, scale, and work at great speed, MS SQL probably needs to up its game massively if they are ever going to keep up, let alone fully compete with Amazon's database suite.