SQL server comparison

Comparison between versions of SQL Server

Features		SQL Server 2014	SQL Server 2012	SQL Server 2008 R2	SQL Server 2008
Performance	In-memory OLTP*	​
	In-memory Column Store*	​	​
	Buffer pool extension to SSD	​	​
	Resource Governor	​	​	​	​
Availability	Always On	​	​
	Enhanced virtualization support and migration	​	​	​
Security	Transparent data encryption	​	​	​	​
	Backup encryption support	​	​	​	​
	Fine-grained auditing	​	​	​	​
	Seperation of dutites	​	​	​	​
Cloud-readiness	Backup to Microsoft Azure	​	​	​	​
	Disaster recovery to Microsoft Azure	​	​	​	​
	Optimized VM images in Microsoft Azure gallery	​	​	​	​
Management & programmaility	Distrubuted reply	​	​	​	​
	Policy-based management	​	​	​	​
	Enhanced programmability	​	​	​	​
BI & analytics	PowerPivot for Excel	​	​	​	​
	Integration services managed as a server	​	​	​
	Hadoop connector via Apache sqoop	​	​	​	​
	Tabular BI semantic model	​	​	​	​
	Master data services	​	​	​	​
	Data quality services	​	​		​