Reviews 52164 Published by

Techradar published a review on Microsoft SQL Server 2014



The latest version of SQL Server is a major new release, but not a disruptive one. You get security and backup improvements that you can start using straight away and you can keep working the way you always have while making the changes needed to take advantage of performance increases.And instead of making licencing more complicated, Microsoft actually gives you more with the Standard edition of SQL Server 2014. Especially for smaller businesses that don't have a full-time database admin, the new managed backup feature will make things much simpler.

It's simple to turn this on for a database in the interface or using a script. When you do, as soon as you've made enough changes to a database it automatically gets backed up for Azure and stored for up to 30 days; if you change more than 5Mb of data that triggers a log backup, and if you change more than 1GB of data that creates a full backup (and you get a full backup every day to store smaller changes). You can also turn on encryption and compression for these backups, which saves you money on the third-party tools you'd have needed before.
  Microsoft SQL Server 2014 Review