SQL Server from One Version to the Next

I love being organized mostly because it’s the only way I can function effectively. As a Microsoft instructor and database consultant, it truly is interesting to see all the new features from one release to the next. However, I find it extremely challenging to remember which version introduced each feature as I work with clients.

Database Administrators and Developers are tasked with making applications and upgrades work efficiently, and they must be able to integrate applications across versions. This matters because most companies cannot suddenly upgrade all of their servers and applications at once, so there is this type of mish-mash blend of versions.

I created this little chart to remind myself (and you) of some of the highlights introduced in each feature. As the next version (Denali) makes it way into the market, check back here for updates. Happy reading!

Feature New in 2005 New in 2008 New in 2008 Feature Pack New in 2008 r2
Dynamic Management Views X
DB Snapshots X
New Replication Types X
Mirrored Backups X
Database Mirroring X (SP1-fix)
Column Encryption X
Online Indexing X
Database Mail X
Table/Index Partitions X
Native XML Support X
Database Engine Tuning Advisor X
DMV Enhancements X
Data Collector X
Resource Governor X
Policy Management X
Powershell Support X
Backup Compression X
DB Encryption (TDE) X
Facets X
Filestream X
Spatial Data Support X
Registered Server Enhancements X
Aggregation Wizard Changes X
Performance and Reliability X
Activity Monitor changes X
Cube Wizard Changes X
Row Compression/Page Compression X
Report Builder 2.0 X
Report Builder 3.0 X
New Report Viewer (VS2010) X
Power Pivot X
Report Part Gallery X
Shared Datasets SSRS X
Shared Report Parts X
Datafeed Subscripts SSRS X
Multi-server MGMT Utility/Utility control Point X
Complex Event Processing/StreamInsight X
Data Tier Application X
LINQ/AJAX Support with SQL X
In this article

Join the Conversation


  1. John.Fetherolf Reply

    This is nice information… will you be expanding this to include SQL 2012?

  2. Gidget Pryor Reply

    Hi John,

    Thank you for your nice comment. Yes, we will be updating this to include 2012 in an upcoming post. Thank you for asking.