List of SQL Server 2014 Enterprise Edition Features

There are some new features introduced with SQL Server 2014 and some are being changed to support advanced functions. Below are some of the top SQL Server 2014 features supported by SQL Server 2014 Enterprise Edition, Evaluation Edition, Developer Edition, Business Intelligence Edition.

Server Core support
Log Shipping
Database mirroring
Backup compression
Database snapshot
Alwayson Failover Cluster Instances
AlwaysOn Availability Groups
Connection Director
Online page and file restore
Online indexing
Online schema change

Fast recovery
Mirrored backups
Hot Add Memory and CPU
Database Recovery Advisor
Encrypted Backup
Smart Backup
Multi-instance support
Table and index partitioning
Data compression
Resource Governor
Partition Table Parallelism
Multiple Filestream containers
NUMA Aware Large Page Memory and Buffer Array Allocation
Buffer Pool Extension
IO Resource Governance
In-Memory OLTP
Delayed durability
Basic Auditing
Fine Grained Auditing
Transparent database encryption
Extensible Key Management
User-Defined Roles
Contained Databases
Encryption for Backups
SQL Server change tracking
Merge replication
Transactional replication
Snapshot replication
Heterogeneous subscribers
Oracle publishing
Peer to Peer transactional replication
Policy automation
Performance data collector
Standard performance reports
Plan guides and plan freezing for plan guides
Direct query of indexed views
Automatic indexed view maintenance
Distributed partitioned views
Parallel indexed operations
Automatic use of indexed view by query optimizer
Parallel consistency check
Change Data Capture Service for Oracle by Attunity
Change Data Capture Designer for Oracle by Attunity
High performance Oracle destination
High performance Teradata destination
SAP BW source and destination
Data mining model training destination adapter
Dimension processing destination adapter
Partition processing destination adapter
Change Data Capture components by Attunity
Connector for Open Database Connectivity
Create cubes without a database
Auto-generate staging and data warehouse schema
xVelocity memory optimized columnstore indexes

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

Changes to Editions and Components of SQL Server 2014

Microsoft SQL Server 2014 software Editions are categorized into different sets based on the features offered mentioned as below.
Principal Edition(Enterprise, Business Intelligence, Standard Edition) – The premium offering, SQL Server 2014 Enterprise version conveys extensive top of the line datacenter abilities with bursting quick execution, boundless virtualization, and end-to-end business insight.
Specialized editions(Web Edition) – SQL Server 2014 Business Intelligence version conveys extensive stage enabling associations to manufacture and convey secure, adaptable and sensible BI arrangements.
Breadth editions(Developer, Express Edition) – SQL Server 2014 Standard version conveys essential information administration and business brainpower database for offices and little associations to run their applications and backings basic advancement devices for on-reason and cloud

On an Internet server, for example, a server that is running Internet Information Services (IIS), you will normally introduce the SQL Server customer instruments. Customer apparatuses incorporate the customer network segments utilized by an application uniting with an example of SQL Server. You can introduce simply the SQL Server customer segments on a PC that is running customer/server applications that associate specifically to a case of SQL Server. A customer segments establishment is likewise a decent choice in the event that you direct an example of SQL Server on a database server, or on the off chance that you plan to create SQL Server applications.

Below are the SQL Server Components which can be installed with the SQL Server media.
SQL Server Database Engine
Analysis Services
Reporting Services
Integration Services
Master Data Services

Along with SQL Server services, there are also additional tools that can be installed to management and development purposes. Below are some of the components that can be installed on SQL Server box or on application servers or remote servers.
SQL Server Management Studio
SQL Server Configuration Manager
SQL Server Profiler
Database Engine Tuning Advisor
Data Quality Client
SQL Server Data Tools
Connectivity Components
SQL Server Books Online

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2012
SQL Server 2014

Thanks,

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings