SQL Server

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
Get Started

You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.

Become a sharper developer and jumpstart your career.

Basic

$0

$

. 00

monthly

For Basic members:

  • Standard Profile
  • Access learning courses
  • Access free e-books
  • 1x point
Premium

$20

$

. 00

monthly

For Premium members:

  • Earn 2x reward points
  • Premium profile with Verified check
  • Premium Avatar with status update
  • Learning courses
  • Unlimited Certifications and badges on profile
  • Unlimited Book downloads
  • Access to Premium content
  • Online Training
  • Unlimited PDF conversions and downloads
  • Professional Resume Writing
  • Interview Preparations Guide
  • 25 messages per month
  • 1 "Kodzu" avatar, basic
Elite

$45

$

. 00

monthly

For Elite members:

  • Bundle E-books
  • Access to all Learn Series
  • Unlimited Apply Jobs