SQL Server 2014 Compared to older versions

 

SQL Server 2014 Compared to older versions

 

 

FeaturesFeature DescriptionSQL Server 2014SQL Server 2012SQL Server 2008ÿR2SQL Server 2008
PerformanceIn-memory OLTP*YesNoNoNo
In-memory ColumnStore*YesYesNoNo
Buffer pool extension to SSDYesNoNoNo
Resource GovernorYesYesYesYes
AvailabilityAlwaysOn*YesYesNoNo
Enhanced virtualization support and live migrationYesYesYesNo
SecurityTransparent data encryption*YesYesYesYes
Backup encryption supportYesNoNoNo
Fine-grained auditingYesYesYesYes
Separation of dutiesYesYesNoNo
Cloud-readinessBackup to Microsoft AzureYesYesNoNo
Disaster recovery to Microsoft AzureYesNoNoNo
Optimized VM images in Microsoft Azure galleryYesYesNoNo
Management & programmabilityDistributed replayYesYesNoNo
Policy-based managementYesYesYesYes
Enhanced programmabilityYesYesYesYes
BI & analyticsPowerPivot for ExcelYesYesYesNo
Integration services managed as a serverYesYesNoNo
Hadoop connector via Apache SqoopYesYesYesYes
Tabular BI semantic model*YesYesYesNo
Master data services*YesYesYesNo
Data quality services*YesYesNoNo

Leave a Reply

Your email address will not be published. Required fields are marked *