Technical Preview: Microsoft SQL Server 2017 Editions and Features

Published 10/30/2018 09:21 AM   |    Updated 10/31/2018 09:29 AM
Microsoft offers five editions of SQL Server 2017 to help you meet your unique database management tasks on Windows or Linux operating systems. The 2017 version provides the flexibility to choose development languages and data types. And it comes with two suites of server and management tools.
 
This Artificial Intelligence (AI)-powered technology simplifies support and development of your infrastructure applications. You can process transactions and analyze data with machine learning tools. In addition, you can deploy your database on premises or in the cloud for optimized performance.
 

SQL Server 2017 system requirements

 
  • 1.4 GHz 64-bit processor
  • 2 server cores (virtual or physical)
  • 4GB RAM
  • 6GB storage
 

SQL Server editions

 
  • Enterprise
  • Standard
  • Web
  • Developer
  • Express
 

Server components

 
  • SQL Server Database Engine
  • Analysis Services
  • Reporting Services
  • Integration Services
  • Master Data Services
  • Machine Learning Services
  • Machine Learning Server
 

Management tools

 
  • SQL Server Management Studio
  • SQL Server Configuration Manager 
  • SQL Server Profiler
  • Database Engine Tuning Advisor 
  • Data Quality Client 
  • SQL Server Data Tools
  • Connectivity Components
 

Frequently asked questions — functionality

 
Q: Can SQL Server run on platforms other than Windows? 
A: Yes. Starting with SQL Server 2017, the software can be installed on Linux and Docker platforms, enabling the use of applications exclusive to these platforms. 
 
Q: What Linux platforms can install SQL Server? 
A: SQL Server is supported by Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu and Docker Engine operating systems. 
 
Q: Can SQL Server 2017 run in Azure?
A: Yes, you can move to the cloud and have your database workloads exist within Azure Virtual Machines. Any SQL Server version and edition works on both Windows and Linux on any virtual machine size in Azure. 
 

Frequently asked questions — features

 
Q: Are all SQL Server components and management tools installed with the software? 
A: No. You can choose which features you’d like to install from the SQL Server Installation Wizard. The default setting has none of the tools selected. You can add the components based on what you need.
 
Q: What programming languages can I use with SQL Server?
A: You can use the R and Python programming languages with SQL Server 2017 for end-to-end business intelligence. The software also supports languages such as Polybase, JSON, XML and more. 
 
Q: What types of containers does SQL Server 2017 support? 
A: It supports Windows, Linux and Docker containers. 
 

Frequently asked questions — editions

 
Q: What are the differences between the five editions of SQL Server 2017?
A: 
 
  • The Enterprise Edition provides a complete set of data center capabilities, such as unlimited virtualization and end-to-end business intelligence. 
  • The Standard Edition is built for departments and smaller organizations to use applications and common development tools. 
  • The Web Edition offers a lower cost of ownership for website hosts. 
  • The Developer Edition provides the same functionality as the Enterprise Edition, but is licensed as a development and test system for application creators. 
  • The Express Edition is a free, entry-level database that allows users to learn and build data-driven applications.
 
Q: Is there an upgrade path from previous versions of SQL Server to SQL Server 2017?
A: Yes, you can seamlessly upgrade to SQL Server 2017 from the following versions: 
 
  • SQL Server 2008 Service Pack 4 or later
  • SQL Server 2008 R2 Service Pack 3 or later
  • SQL Server 2012 Service Pack 2 or later
  • SQL Server 2014 or later
  • SQL Server 2016 or later
 
Q: When will support end for SQL Server 2008, 2008 R2, 2012, 2014 and 2016?
A: Microsoft typically provides five years of mainstream support after a SQL Server version is released, followed by another five years of extended support. It’s important to lock down a successful migration as the following sunset dates approach: 
 
  • SLQ Server 2008 and 2008 R2: July 9, 2019
  • SQL Server 2012: July 12, 2022
  • SQL Server 2014: July 9, 2024
  • SQL Server 2016: July 14, 2026
  • SQL Server 2017: Oct. 12, 2027
 

Is this answer helpful?