Management Studio

	Includes All Tools
	Object Explorer replaces Enterprise Manager
	Query Editor Replaces Query Analyzer
	New Table Designer
	New Server Properties
	Server Registration Export/Import
	New Database Properties
	Template Explorer
	Solution Explorer
	Projects Management
	Web Browser Window
	Properties Window
	Assisted Editors
	Source Control
	XML Editor
	Toolbars Selection
	Dynamic Help

T-SQL Enhancements

	AdventureWorks Sample Database
	Database Schemas
	Script Storage in Project
	Xquery - XML Query Language
	XML Data Type
	varchar(max) & nvarchar(max) Data Types
	varbinary(max) Data Type
	PIVOT and UNPIVOT
	INTERSECT and EXCEPT
	OVER(PARTITION BY...)
	Recursive Query
	Common Table Expression - CTE
	RANK and DENSE_RANK
	NTILE
	ROW_NUMBER
	Partitioned Table, Partition Function, & Partition Scheme
	DDL Trigger
	.NET Assembly support
	CROSS APPLY and OUTER APPLY
	OUTPUT Clause
	TRY and CATCH for Exception Handling
	TOP and TABLESAMPLE Clauses
	EXECUTE AS Clause
	MARS - Multiple Active Result Sets
	Snapshot Isolation
	Indexes with Included Columns

SQL Server Profiler

	Deadlock Visualization
	Correlate a Trace with Windows Performance Log Data
	Save Trace as XML File

SQL Configuration Manager

	Replaces Services Manager
	Replaces Server Network Utility
	Replaces Client Network Utility

SQL Server 2005 Surface Area Configuration

	Surface Area Configuration for Services and Connections
	Surface Area Configuration for Features

Utilities

	SQLCMD utility with new scripting language
	Dedicated Administrator Connection(DAC) to Server

Security

	CREATE CERTIFICATE
	Encryption
	Decryption
	Asymmetric Key

Operations

	Setup Consistency Checker
	Online Database Restore
	Online Reindex
	Mirrored Backups
	Database Mirroring
	Database Snapshot
	Database Tuning Advisor