List of top new features of sql server 2008

List of 28 new features of Microsoft SQL Server 2008.

  1. Transparent Data Encryption
  2. Extensible Key Management
  3. Auditing
  4. Enhanced Database Mirroring
  5. Automatic Recovery of Data Pages
  6. Log Stream Compression
  7. Resource Governor
  8. Predictable Query Performance
  9. Data Compression
  10. Hot Add CPU
  11. Policy-Based Management
  12. Streamlined Installation
  13. Performance Data Collection
  14. Language Integrated Query (LINQ)
  15. ADO.NET Data Services
  16. DATE/TIME
  17. HIERARCHY ID
  18. FILESTREAM Data
  19. Integrated Full Text Search
  20. Sparse Columns
  21. Large User-Defined Types
  22. Spatial Data Types
  23. Backup Compression
  24. Partitioned Table Parallelism
  25. Star Join Query Optimizations
  26. Grouping Sets
  27. Change Data Capture
  28. MERGE SQL Statement


Ebook Download
View all
Learn
View all