Difference between revisions of "Microsoft SQL Server"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 52: Line 52:
 
* Download and use [[SQL Server Management Studio]]
 
* Download and use [[SQL Server Management Studio]]
 
* Review SQL computing limits based on editions: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2016
 
* Review SQL computing limits based on editions: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2016
 +
* [[SQL Server Upgrade]]
  
 
== See also ==
 
== See also ==

Revision as of 07:32, 13 May 2020

This article is a Draft. Help us to complete it.

wikipedia:Microsoft SQL Server is a relational database management system developed by Microsoft listening on port 1433.

Platforms

SQL Server 2017, released in 2017, adds Linux support for these Linux platforms: Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu & Docker Engine.[1]


Editions

  • Express: freely downloadable and distributable
  • Standard: includes High Availability 2-node failover cluster
  • Web: under the Microsoft Services Provider License Agreement (SPLA)
  • Enterprise: In-memory ColumnStore, In-memory OLTP, AlwaysOn Availability Groups.
  • Developer edition: SQL Server 2016 Developer Edition is a fully featured version of SQL Server software—including all of the features and capabilities of Enterprise Edition—licensed for development, test, and demonstration purposes only. Since 2016 is available for download from the Microsoft Dev Essentials program.
  • Evaluation Edition is a fully functional trial version of SQL Server 2016 software that automatically expires after 180 days.
  • SQL Server Parallel Data Warehouse

Versions

  • SQL Server 2019
  • SQL Server 2017 RT
  • SQL Server 2016 SP2
  • SQL Server 2014
  • SQL Server 2012

Licensing

  • Server+CAL
  • Per Core

Cloud Services

Upgrade from SQL Server Express 2016

If you upgraded from SQL Server Express, you must perform additional steps before you can use your upgraded instance of SQL Server:

  • Enable the SQL Server Agent service in Windows SCM.
  • Provision the SQL Server Agent service account by using SQL Server Configuration Manager

More info: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-2016&redirectedfrom=MSDN

Activities

Start->Programs ->Microsoft SQL Server 2016-> SQL Server Installation Center

See also

  • "Installation guidance for SQL Server on Linux". December 21, 2017. Retrieved February 1, 2018.<templatestyles src="Module:Citation/CS1/styles.css"></templatestyles>
  • Advertising: