Close Menu



SQL- ServerSQL-Server Feature Comparision from 2008 to 2016

There are soomany instances u might end up with a question if you really need to decide for an upgrade. However the question arises "Do we really need to upgrade and to what version should I upgrade"

The below given table cleraly Compares the Most important features and differences between each version from 2008, 2008 R2, 2012, and 2014

Please Note: I will keep updating this page as soon as I come across anything new

SQL-Server Feature Comparison From 2008 to 2016

The below Given Table shows the feature Comparisons while highlighting the Most important Feature upgrades by Version

Features Vs Version

SQL Server 2016 SQL Server 2014 SQL Server 2012 SQL Server 2008 R2 SQL Server 2008
In-memory OLTP*      
In-memory columnstore*    
Buffer pool extension to SSD      
Resource Governor
High Availability          
Enhanced virtualization support and live migration  
Transparent data encryption*
Backup encryption support      
Fine-grained auditing
Separation of duties    
Backup to Azure    
Disaster recovery to Microsoft      
Optimized virtual machine images in Azure gallery    
Management and programmability          
Distributed replay    
Policy-based management
Enhanced programmability
BI and Aanalytics          
PowerPivot for Excel  
Integration services managed as a server    
Hadoop connector via Apache Sqoop
Tabular BI semantic model*  
Master data services*  
Data quality services*    

you can download the Data Sheet here