Welcome to Sign in | Help
in Search
Home Blogs External Feeds Forums Photos Downloads About Us
» Romanian Section » Articole » Re: Functionalitati noi in SQL Server 2008 (living document)

Functionalitati noi in SQL Server 2008 (living document)

Last post 08-01-2007, 12:40 PM by xmldeveloper. 2 replies.
Sort Posts: Previous Next

  •  07-25-2007, 6:30 PM 2326

    Functionalitati noi in SQL Server 2008 (living document)

    Reply Quote

    • 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: ,

  •  07-27-2007, 2:32 PM 2335 in reply to 2326

    Re: Functionalitati noi in SQL Server 2008 (living document)

    Reply Quote
    Descrierea pe larg la http://www.microsoft.com/sql/techinfo/whitepapers/sql2008Overview.mspx

  •  08-01-2007, 12:40 PM 2364 in reply to 2326

    Re: Functionalitati noi in SQL Server 2008 (living document)

    Reply Quote
    Another list of new functionalities in SQL Server 2008 can be found on Chad Boyd's blog : Katmai (Sql 2008) - The List of New Features
    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 as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems