Microsoft SQL is very robust but easy to install and maintain. The available tools such as SQL Server Management Studio really simplify the maintenance process and also allows developers to easily access their databases with powerful and speedy queries. The ability to schedule jobs, setup custom alerts based on message contents, easily setup security access, connect to remote or local databases and just the overall simplicity in managing all of your critical databases and also backup databases on a schedule with little disruption really all contributes to a very powerful solution for most applications that require a database. Review collected by and hosted on G2.com.
We find that there are issues when you run SQL on VMs and when you take a VM snapshot it can mess with your incremental backups which is kind of a huge problem if you are not aware of it. A company definitely needs to have a regular testing plan for data backups as there are some finicky things about SQL that if you do not have a strong DBA or at least a good understanding of SQL, you can easily get into trouble. Also, I am not happy about the pricing for SQL as it is very confusing and when they start talking about per core pricing, it is like being punished because you happened to purchase yourself a decent server. Review collected by and hosted on G2.com.
