SQL Server 2008 Community Preview

    Registered members of the CTP Program can now download and install SQL Server 2008 (codename "Katmai") ​​June CTP.

    What is there:
    1. Non-relational data types.
    FILESTREAM, sparse columns, user data types, data types for working with geographic information (GEOMETRY, GEOSPATIAL) and their indexing, new types for working with dates.

    2. Dynamic Development.
    Object data access (LINQ, the new Entity SQL query language). Tighter integration with Visual Studio, Office, BizTalk Server, NET 3.0

    3. Business logic.
    Uploading large volumes of various data to storages and integrating them with Integration Services. Advanced capabilities for building and publishing reports (Analysis Services), building and publishing reports using MS Office.

    4. High availability and security.
    Transparent encryption. Access audit. New features for mirroring and protection against failures. New policy-based service model. Ability to add processors without stopping the system.

    5. Opportunities for optimization.
    Data compression. Performance monitoring and analysis. Query Optimization.

    more details ...

    Also popular now: