AKAWN

Below shows a quick reference guide of the feature selections presented based on the version of SQL Server being installed on Windows.

SQL Server 2022

• Instance Features
  • – R
  • – Python
  • – Java
  • – Java connector for HDFS data sources
• Shared Features
  • – Machine Learning Server (Standalone)
    • – R
    • – Python
  • – Client Tools Connectivity
  • – Client Tools Backwards Compatibility
  • – Client Tools SDK
  • – Distributed Replay Controller
  • – Distributed Replay Client
  • – SQL Client Connectivity SDK

SQL Server 2019

• Instance Features
  • + Java connector for HDFS data sources

SQL Server 2017

• First SQL version to support being installed on Linux
• First SQL version to not include Reporting Services media
  (can be found here)
• First SQL version to not include Documentation media (now online only here)
• Instance Features
  • + Machine Learning Services (In-Database)
  • + R
  • + Python
  • – R Services (In-Database)
  • – Reporting Services – Native
• Shared Features
  • + Machine Learning Server (Standalone)
  • + R
  • + Python
  • + Scale Out Master
  • + Scale Out Worker
  • – R Server (Standalone)
  • – Reporting Services – SharePoint
  • – Reporting Services Add-in for SharePoint Products
  • – Document Components

SQL Server 2016

• First SQL version to use 64-bit media only
• First SQL version to not include SSMS media (can be found here)
• .Net 3.5 no longer required as a prerequisite
• Instance Features
  • + R Services (In-Database)
  • + PolyBase Query Service for External Data
• Shared Features
  • + R Server (Standalone)
  • – Management Tools – Basic
  • – Management Tools – Complete

SQL Server 2014

• First SQL version to not include Data Tools media (can be found here)
• Shared Features
  • – SQL Server Data Tools

SQL Server 2012

• Instance Features
  • + Reporting Services – Native
  • – Reporting Services
• Shared Features
  • + Reporting Services – SharePoint
  • + Reporting Services Add-in for SharePoint Products
  • + Data Quality Client
  • + SQL Server Data Tools
  • + Document Components
  • + Distributed Replay Controller
  • + Distributed Replay Client
  • + Master Data Services
  • – Business Intelligence Development Studio
  • – SQL Server Books Online

SQL Server 2008 R2

• No feature changes from SQL Server 2008

SQL Server 2008

• First SQL version where Reporting Services is not dependent on IIS
• First SQL version to not include sample databases as option (various sample media links can be found here)
• Instance Features
  • + Reporting Services
  • – Notification Services
• Shared Features
  • + Client Tools Connectivity
  • + Client Tools Backwards Compatibility
  • + Client Tools SDK
  • + Management Tools – Basic
  • + Management Tools – Complete
  • + SQL Client Connectivity SDK
  • + Microsoft Sync Framework
  • – Connectivity Components
  • – Management Tools
  • – Software Development Kit
  • – SQLXML Client Features
  • – Legacy Components
  • – Sample Databases
  • – AdventureWorks Sample OLTP
  • – AdventureWorksDW Sample Data Warehouse
  • – AdevntureWorks Sample OLAP
  • – Sample Code and Applications

SQL Server 2005