This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture.
The things I like best about Microsoft SQL are SQL Server Management Studio and SQL Profiler. As far as relational and non-relational database management systems go (I've used Oracle, SQL Server, PostgreSQL, MySQL, DB2, and MongoDB), I would place SQL Server in a close second place tie (with MySQL) behind Oracle for enterprise application development.
Microsoft SQL Server has some really cool features that put it near the top of its game. For instance, SQL Server internally supports a message queueing system call SQL Server Service Broker. It's a little complex, but it allows you to piggy back a SQL Server license with a transactional queue.
Some other features Microsoft SQL offers are things like Business Intelligence, Reporting Services, tabular file storage, and numerous other things.
Compared to MySQL, I've experienced Microsoft SQL queries being faster than MySQL queries after *a little more work applied to query tune those queries*. Review collected by and hosted on G2.com.
Licensing. Microsoft tools are expensive. Oracle is also expensive. If you don't need a lot of the stuff offered by Microsoft SQL, you can often use MySQL or PostgreSQL. If you need replication with Microsoft SQL, you'll pay a lot of money.
If you want direct language support, MySQL or Oracle (both owned by Oracle) would probably be a better choice.
If you want to store and retrieve JSON with Microsoft SQL, you'll need SQL 2016. You can do this with PostgreSQL, without licensing costs and hosting would be cheaper. Review collected by and hosted on G2.com.
The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user.
Validated through LinkedIn
This reviewer was offered a nominal gift card as thank you for completing this review.
Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review.





