List of 28 new features of Microsoft SQL Server 2008.
Below are the top 28 new features that are introduced as a set in the latest release of the SQL Server 2008 version
[more]- Transparent Data Encryption
- Extensible Key Management
- Auditing
- Enhanced Database Mirroring
- Automatic Recovery of Data Pages
- Log Stream Compression
- Resource Governor
- Predictable Query Performance
- Data Compression
- Hot Add CPU
- Policy-Based Management
- Streamlined Installation
- Performance Data Collection
- Language Integrated Query (LINQ)
- ADO.NET Data Services
- DATE/TIME
- HIERARCHY ID
- FILESTREAM Data
- Integrated Full Text Search
- Sparse Columns
- Large User-Defined Types
- Spatial Data Types
- Backup Compression
- Partitioned Table Parallelism
- Star Join Query Optimizations
- Grouping Sets
- Change Data Capture
- MERGE SQL Statement
