Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server - Windows only
The Database Engine component of SQL Server is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications in your enterprise.
SQL Server supports up to 50 instances of the Database Engine on a single computer. To create a typical SQL Server installation, see Install SQL Server from the Installation Wizard (Setup).
Important
For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.
The following features are installed when you select SQL Server Database Engine on the Components to Install page of the SQL Server Installation Wizard:
Database Engine
SQL Server Replication - is an optional component
Full-Text Search - is an optional component
Data Quality Services - is an optional component
Note
In this release, selecting the Data Quality Services check box in setup doesn't install the Data Quality Services (DQS) server. You'll have to perform additional steps post installation to install DQS server. For more information, see Install Data Quality Services.
PolyBase Query Service for External Data - is an optional component. In SQL Server 2019 (15.x), a Java connector for HDFS data sources is also available.
The following additional features are options for many typical user scenarios:
Note
By default, sample databases and sample code aren't installed as part of SQL Server Setup. To install sample databases and sample code, see Microsoft SQL Server Samples. See older samples on CodePlex.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Get started with Azure SQL Database for modern application development - Training
Learn how Azure SQL Database works, the key concepts, and practical examples to help developers effectively utilize Azure SQL Database in their cloud-based applications.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.