Archive

Archive for the ‘SQL Server 2008’ Category

SQL Server 2008 Top New Features

September 14th, 2009 rajesh Comments off

Enterprise Data Platform

  • Policy-Based Management
  • Performance Data Collection (Data Collector)
  • Data Compression
  • Resource Governor
  • Transparent Data Encryption
  • External Key Management / Extensible Key Management
  • Data Auditing
  • Hot-Add CPUs and Hot-Add Memory
  • Streamlined Installation
  • Server Group Management
  • Upgrade Advisor
  • Partition Aligned Indexed Views
  • Backup Compression
  • Extended Events

Dynamic Development

  • Grouping Sets
  • MERGE Operator
  • LINQ
  • Change Data Capture
  • Table-Valued Parameters
  • ADO.NET Entity Framework and the Entity Data Model
  • Synchronization Services for ADO.NET
  • CLR Improvements
  • Conflict Detection in Peer-to-Peer Replication
  • Service Broker Priorities and Diagnostics
  • ADO.NET Data Services
Categories: SQL Server 2008 Tags: