SQL Server 2014 Compared to older versions
SQL Server 2014 Compared to older versions
| Features | Feature Description | SQL Server 2014 | SQL Server 2012 | SQL Server 2008ÿR2 | SQL Server 2008 |
| Performance | In-memory OLTP* | Yes | No | No | No |
| In-memory ColumnStore* | Yes | Yes | No | No | |
| Buffer pool extension to SSD | Yes | No | No | No | |
| Resource Governor | Yes | Yes | Yes | Yes | |
| Availability | AlwaysOn* | Yes | Yes | No | No |
| Enhanced virtualization support and live migration | Yes | Yes | Yes | No | |
| Security | Transparent data encryption* | Yes | Yes | Yes | Yes |
| Backup encryption support | Yes | No | No | No | |
| Fine-grained auditing | Yes | Yes | Yes | Yes | |
| Separation of duties | Yes | Yes | No | No | |
| Cloud-readiness | Backup to |