Saturday, January 2, 2010

New Features in Sql Server 2008


  • Compressed Backup
  • AUDITING => Change Data Capture (CDC)
  • FileStream
  • Sparse Column Support
  • Performance Data Management
  • Encryption => Transparent data encryption (TDE)
  • Resource Governor
  • Freeze Plan
  • LINQ Support

Deprecated Features in future realases (but still available in Sql 2008)

  •  BACKUP {DATABASE | LOG} WITH PASSWORD
  •  BACKUP {DATABASE | LOG} WITH MEDIAPASSWORD
  •  RESTORE {DATABASE | LOG} … WITH DBO_ONLY
  •  RESTORE {DATABASE | LOG} WITH PASSWORD
  •  RESTORE {DATABASE | LOG} WITH MEDIAPASSWORD

Share This