Good database engine
January 08, 2016

Good database engine

Alexander Goryainov | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

Microsoft SQL Server is being used on different projects for different customers. I had a chance to use this software several times and it left a very good impression. Microsoft SQL Server has a good set of tools for developers, its T-SQL language is convenient. Microsoft SQL Server can be used both by medium and large size enterprise applications and is pretty easy to scale out using techniques like replication, clustering etc.
  • Good query optimizer. For complex a query it provides helpful tools like Query Tuning Advisor.
  • Reliable database engine.
  • Many options for replications.
  • Good additional out-of-box features like Integration services, Analysis services and Reporting services.
  • No integration with source control like Microsoft TFS.
  • Intellisense can be improved further.
  • Positive user experience with software applications that use SQL Server - faster data retrieval.
  • Positive development experience - easy to develop and maintain databases.
SQL Server is better in some scenarios when all other software products are also from Microsoft.
SolarWinds Server and Application Monitor, VMware vCenter Server, Windows Server
Definitely recommend for enterprise application. Do not recommend for small companies - better to use MySQL.