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

xmldeveloper — Wed, 01 Aug 2007 09:40:37 GMT

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

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

marcel soare — Fri, 27 Jul 2007 11:32:53 GMT

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

Functionalitati noi in SQL Server 2008 (living document)

xmldeveloper — Wed, 25 Jul 2007 15:30:08 GMT

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

Articole

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

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

Functionalitati noi in SQL Server 2008 (living document)