Difference between revisions of "Microsoft SQL Server"
Jump to navigation
Jump to search
↑ "Installation guidance for SQL Server on Linux". December 21, 2017. Retrieved February 1, 2018.<templatestyles src="Module:Citation/CS1/styles.css"></templatestyles>
Tags: Mobile web edit, Mobile edit |
Tags: Mobile web edit, Mobile edit |
||
| (23 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Draft}} | {{Draft}} | ||
| − | [[wikipedia:Microsoft SQL Server]] | + | [[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 (operating system)|Ubuntu]] & [[Docker (software)|Docker Engine]].<ref>{{cite web | ||
| + | |url=https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup#supportedplatforms | ||
| + | |title=Installation guidance for SQL Server on Linux | ||
| + | |date=December 21, 2017 | ||
| + | |accessdate=February 1, 2018}} | ||
| + | </ref> | ||
| Line 7: | Line 15: | ||
* '''Express''': freely downloadable and distributable | * '''Express''': freely downloadable and distributable | ||
* '''Standard''': includes [[High Availability]] 2-node [[failover cluster]] | * '''Standard''': includes [[High Availability]] 2-node [[failover cluster]] | ||
| − | * Web | + | * '''Web''': under the Microsoft Services Provider License Agreement (SPLA) |
* '''Enterprise''': In-memory ColumnStore, In-memory [[OLTP]], AlwaysOn Availability Groups. | * '''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. | |
| − | *'''Developer edition''': | + | * '''Evaluation Edition''' is a fully functional trial version of SQL Server 2016 software that automatically expires after 180 days. |
| − | |||
* '''SQL Server Parallel Data Warehouse''' | * '''SQL Server Parallel Data Warehouse''' | ||
== Versions == | == Versions == | ||
| − | * SQL Server 2019 | + | * SQL Server 2019: [[HDFS]] included |
* SQL Server 2017 [[RT]] | * SQL Server 2017 [[RT]] | ||
* SQL Server 2016 [[SP2]] | * SQL Server 2016 [[SP2]] | ||
* SQL Server 2014 | * SQL Server 2014 | ||
* SQL Server 2012 | * SQL Server 2012 | ||
| + | |||
| + | == Licensing == | ||
| + | * Server+[[CAL]] | ||
| + | * Per Core | ||
== Cloud Services == | == Cloud Services == | ||
| Line 25: | Line 36: | ||
* [[Amazon Relational Database Services]] (2012) | * [[Amazon Relational Database Services]] (2012) | ||
| + | == 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 | ||
| + | |||
| + | == Products == | ||
| + | * [[Veeam Backup & Replication]] | ||
== Activities == | == Activities == | ||
* Read about [[transation log]]s recommendations: https://www.brentozar.com/archive/2014/02/back-transaction-logs-every-minute-yes-really/ | * Read about [[transation log]]s recommendations: https://www.brentozar.com/archive/2014/02/back-transaction-logs-every-minute-yes-really/ | ||
| − | * Read Microsoft SQL Server License guide https://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US.pdf | + | * Read [[Microsoft SQL Server License]] guide https://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US.pdf |
| + | * Read how to change your license: https://www.sqlservercentral.com/blogs/how-to-change-sql-server-license-or-product-key | ||
| + | :Start->Programs ->Microsoft SQL Server 2016-> SQL Server Installation Center | ||
| + | * 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 | ||
| + | * [[SQL Server Upgrade]] | ||
| + | |||
| + | == Related terms == | ||
| + | * [[wikipedia:Microsoft SQL Server Master Data Services]] ([[MDS]]) | ||
| + | * [[Babelfish]] | ||
== See also == | == See also == | ||
Latest revision as of 04:16, 29 October 2021
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.
Contents
Platforms[edit]
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[edit]
- 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[edit]
- SQL Server 2019: HDFS included
- SQL Server 2017 RT
- SQL Server 2016 SP2
- SQL Server 2014
- SQL Server 2012
Licensing[edit]
- Server+CAL
- Per Core
Cloud Services[edit]
Upgrade from SQL Server Express 2016[edit]
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
Products[edit]
Activities[edit]
- Read about transation logs recommendations: https://www.brentozar.com/archive/2014/02/back-transaction-logs-every-minute-yes-really/
- Read Microsoft SQL Server License guide https://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US.pdf
- Read how to change your license: https://www.sqlservercentral.com/blogs/how-to-change-sql-server-license-or-product-key
- Start->Programs ->Microsoft SQL Server 2016-> SQL Server Installation Center
- 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
- SQL Server Upgrade
Related terms[edit]
See also[edit]
- Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid, RDMS
- Microsoft, Azure, Windows, Encarta, Satya Nadella, SCOM, Bill Gates, Steve Balmer, Kevin Scott, Microsoft Surface, Surface Go 2, Skype, Microsoft Surface Headphones 2, MCITP, Microsoft Defender, Teams, Microsoft Edge, OneNote, Microsoft Malware Engine, Microsoft Defender
Advertising:
