Close Menu

SQLSERVER



 



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
Perfomance          
In-memory OLTP*      
In-memory columnstore*    
Buffer pool extension to SSD      
Resource Governor
High Availability          
AlwaysOn*    
Enhanced virtualization support and live migration  
Security          
Transparent data encryption*
Backup encryption support      
Fine-grained auditing
Separation of duties    
Cloud-readiness          
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