Skip to main content

What's New in SQL Server 2008

After releasing of SQL Server 2008, We got to feel very easy because so many new features and enhancements introduced by SQL Server 2008.

I enjoyed my work while worked with SQL Server 2008 new features as well new enhancements. Some of the new features lists I have drafted. Links are available for each feature list if posts are available for the same. Please go through below list and let me if I missed anything.
  • HierarchyId new data type
  • Policy based management
  • Performance Data Collection
  • Data compression
  • Resource Governor
  • Transparent Data Encryption
  • External Key Management/Extensible Key Management
  • Data Auditing
  • Hot-Add CPU and Hot-Add Memory
  • Streamlined Installation
  • Server Group Management
  • Upgrade Advisor
  • Partition aligned indexed views
  • Backup Compression
  • Extended Events
  • Grouping Set
  • Merge Statement
  • Greater Support for LINQ and Entity Framework
  • Change Data Capture
  • Table Valued Parameters
  • Entity data model for entity framework.
  • Synchronization Server with ADO.NET
  • CLR Improvements
  • Conflict detection between peer to peer Replication
  • Service Broker Priorities and Diagnostics
  • Spatial Data with Geography and Geometry data types
  • Virtual Earth Integration
  • Sparse Column
  • Filtered Indexes
  • Integrated full text search
  • File stream data
  • Large user defined types
  • Large user defined aggregates
  • Date/Time Data Types
  • Improved XML Support
  • TSQL Debugger
  • Intellisense

I will post for each feature list in details and with examples in future.


  1. Hi Paresh,
    When will you publish your new articles with above mention points in "Whats new in SQL SERVER 2008" with examples in each topics.

  2. Hello Ashish, I wrote some of the new features of SQL Server 2008 in individual posts, you can search with "SQL Server 2008" and find it. I will also future post for the same.

    Thanks for your intrest.

  3. HI, Paresh,
    When will you publish your new articles with above mention points in "Whats new in SQL SERVER'2008'
    Thanks ..Sengu1983@gmail Can u please ur paste Your Link

  4. I have published some of the posts of 2008 but not linked in this article yet, I will.

    But you can search using keyword "2008" in serach this blog, You will get all articles related to it.



Post a Comment