SQL Server Version Feature Selections Reference Guide

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

SQL Server 2019 CTP 3.0

  • 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
    • – 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

continued
continued

Leave a Reply