Microsoft SQL Server Installing SQL Server on Windows Introduction

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Example

These are the available editions of SQL Server, as told by the Editions Matrix:

  • Express: Entry-level free database. Includes core-RDBMS functionality. Limited to 10G of disk size. Ideal for development and testing.
  • Standard Edition: Standard Licensed edition. Includes core functionality and Business Intelligence capabilities.
  • Enterprise Edition: Full-featured SQL Server edition. Includes advanced security and data warehousing capabilities.
  • Developer Edition: Includes all of the features from Enterprise Edition and no limitations, and it is free to download and use for development purposes only.

After downloading/acquiring SQL Server, the installation gets executed with SQLSetup.exe, which is available as a GUI or a command-line program.

Installing via either of these will require you to specify a product key and run some initial configuration that includes enabling features, separate services and setting the initial parameters for each of them. Additional services and features can be enabled at any time by running the SQLSetup.exe program in either the command-line or the GUI version.



Got any Microsoft SQL Server Question?