New Features & Enhancements of SQL SERVER 2005,2008,2008R2,2012,2014

New Features & Enhancements of SQL SERVER 2005:

·         Integrated installation of SQL Server.

·         Resource database.

·         Client tools are integrated.

·         Database snapshot.

·         Database mail.

·         DAC (Dedicated administration connection) connection.

·         SSIS (SQL SERVER Integration Services).

·         Schema concept.

·         Partially, Copy-only and Mirror backups.

·         Online index rebuilds.

·         Database mirroring.

·         DMV's (Dynamic management views).

·         SNAC (SQLSERVER Native Access Client).

·         Online restores

New Features & Enhancements of SQL SERVER 2008&2008R2:

·         Activity monitor.

·         SQL Server audit.

·         Backup compression.

·         Data compression.

·         Central management servers.

·         Data collector and management data warehouse.

·         Policy-Based management.

·         Resource governor.

·         Transparent data encryption (TDE).

·         Change Data Capture (CDC).

·         Sqlserver 2008R2 datacenter.

New Features & Enhancements of SQL SERVER 2012:

·         Always On Availability groups.

·         Windows server core support.

·         Column store indexes.

·         User-defined server roles.

·         Default schema for Windows groups.

·         Enhanced auditing features.

·         Distributed replay.

·         Indirect checkpoints feature.

·         Partially contained database.

·         Online index create, rebuild, drop for varchar (max), nvarchar (max) and varbinary (max) columns.

New Features& Enhancements of SQL SERVER 2014:

·         In-memory OLTP engine.

·         Always On enhancements.

·         Buffer pool extension.

·         Updatable column store indexes.

·         Backup encryption.

·         Sqlserver managed backup to windows Azure.