Difference between revisions of "Microsoft SQL Server"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
Tags: Mobile web edit, Mobile edit |
||
| Line 25: | Line 25: | ||
* [[Amazon Relational Database Services]] (2012) | * [[Amazon Relational Database Services]] (2012) | ||
| − | ==Upgrade | + | == 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: | If you upgraded from SQL Server Express, you must perform additional steps before you can use your upgraded instance of SQL Server: | ||
Revision as of 08:12, 7 April 2020
This article is a Draft. Help us to complete it.
wikipedia:Microsoft SQL Server
Contents
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.
- SQL Server Parallel Data Warehouse
Versions
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
Activities
- 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
See also
- 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:
