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


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


Leave a Reply

Your email address will not be published. Required fields are marked *