Welcome to Sign in | Help

Functionalitati noi in SQL Server 2008 (living document)

  •  07-25-2007, 6:30 PM

    Functionalitati noi in SQL Server 2008 (living document)

    • Transparent data encryption

    • External key management

    • Data Auditing

    • Hot Add CPU

    • Transparent failover for Database Mirroring

    • Automatic recovery from page corruption

    • Log stream compression (Database Mirroring)

    • Declarative Management Framework

    • Server Group Management

    • Streamlined installation

    • Enterprise System Management

    • Performance Data Collection

    • System Analysis

    • Data compression

    • Resource Governor

    • Query Optimization Modes

    • 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

    • FileStream data type

    • Integrated Full-Text Search

    • Sparse columns

    • Large user-defined types

    • Date/Time Data types

    • LOCATION data type

    • SPATIAL data type

    • Data compression
    • Backup compression
    • 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

    In plus:

    • FORCESEEK table hint
    • T-SQL Row Constructors
    • New Dynamic Management Views
    • Visual designer, and add nodes to a peer-to-peer replication configuration without stopping system activity
    • Performance Studio to troubleshoot, tune, and monitor
    • Table-valued parameters
    • Table-valued constructors
    • One statement variable declaration/assignment, increment operators
    • HierarchyID data type
    • Large User Defined Aggregates
    • New versions of ODBC driver, OLE DB provider, and ADO.NET data provider
    • SQLCE Version 3.5

     Alte Facilitati neconfirmate oficial:

    • 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