Management Studio

T-SQL Enhancements

	AdventureWorks2008 Sample OLTP Database
	AdventureWorksDW2008 Sample Data Warehouse
	DATE Data Type
	TIME and DATETIME2 Data Types
	Date/Datetime Functions
	HIERARCHYID Data Type and Hierarchy Functions
	Geometry & Geography Data Types and Spatial Functions
	TABLE Data Type
	TABLE-Valued Parameters
	MERGE Statement for Combination INSERT/UPDATE/DELETE
	Enhanced INSERT...VALUES For Multiple Rows of Data
	Local Variable Initialization in DECLARE Statement
	Compound Operators: +=, -=, *=, /=, %=, &=, ^=, |=
	Sparse Columns
	Filtered Indexes
	Enhancements to DDL Triggers
	Change Data Capture
	Enhancement to CONVERT Function
	Enhancements to CLR User-Defined Aggregates
	Enhancements to Plan Guides
	Filestream Storage
	Lock Escalation Control

Database Engine

Optimize for Ad Hoc Workloads

SQL Server Installation Center

	Replaces Surface Area Configuration
	Planning, Installation, Maintenance, Tools
	Resources, Advanced & Options Nodes

SQL Server Configuration Manager

	SQL Server Services Replaces SQL Server 2005 Services
	Network Services Replaces 2005 Network Services

Utilities

PowerShell Scripting Language

Administration

	Policy Management
	Data Collection
	Resource Governor

Security

	Transparent Database Encryption
	Database Backup File Encryption
	Cryptographic Providers

Operations

	Database Audits
	Server Audits