Top New Features
Resource Governor
Support for relational data, XML, FILESTREAM, and spatial data Watch the short video.
Data compression and sparse columns
Automatic recovery of suspect pages
Visual designer, and add nodes to a peer-to-peer replication configuration without stopping system activity
Extended Events (Xevents) Watch the short video.
Enhanced database mirroring Watch the short video.
Automatic, transparent data encryption
Use Performance Data Collection to troubleshoot, tune, and monitor
Use Policy-Based Management to manage one or more instances of SQL Server 2008 Watch the short video.