Floating FB popout byF5debug

List of top new features of SQL Server 2008


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


  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
  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
About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter