Welcome to Sign in | Join | Help

New Functionalities in SQL Server 2008 (living document)

  •  10-05-2007, 10:37 AM

    New Functionalities in SQL Server 2008 (living document)

    • Transparent data encryption

    • External key management

    • Data Auditing

    • Hot Add CPU

    • Database Mirroring Improvements

    • Declarative Management Framework

    • Server Group Management

    • Streamlined installation

    • Enterprise System Management

    • Performance Data Collection

    • System Analysis

    • Data compression

    • Resource Governor

    • Query Optimization Modes

    • Extended Events

    • Logging Improvements (Minimal Logging = log only what is necessary for rollback)

    • Entity Data Model

    • Language Integrated Query (LINQ)

    • Visual Entity Designers

    • Entity Aware Adapters

    • SQL Server Change Tracking

    • Synchronized Programming Model

    • Visual Studio Support

    • SQL Server Conflict Detection

    • BLOBS in SQL SERVER 2008

      • FileStream data type

      • Remote BLOB Store API

    • Integrated Full-Text Search

    • Sparse columns

    • Large user-defined types

    • Date/Time Data types

    • LOCATION data type

    • SPATIAL data type

    • Partitioned table parallelism
    • Star join query optimizations
    • Resource Management
    • Grouping Sets
    • Change Data Capture
    • MERGE SQL statement
    • Scalable Integration Services
    • SQL Server Integration Services (SSIS) pipeline improvements
    • SSIS persistent lookups
    • Analysis scale and performance
    • Block computations
    • Writeback
    • Enterprise Reporting Engine
    • Better scale-out configuration
    • Internet report deployment
    • Manage the reporting infrastructure
    • Report Builder enhancements
    • Built-in forms authentication
    • Report Server application embedding
    • Office integration
    • TABLIX

    Add to that:

     Unconfirmed yet:

    • Intellisense
    • Debug in SSMS 

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
    Filed under: ,
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems