Standard Edition
E56736
Standard Edition is a mid-tier edition of Microsoft SQL Server that provides core database, reporting, and analytics features suitable for small to medium-sized applications and organizations.
Observed surface forms (3)
| Surface form | Occurrences |
|---|---|
| Microsoft SQL Server Standard Edition | 0 |
| SQL Server Standard Edition | 1 |
| Standard Edition (Microsoft SQL Server) | 1 |
Statements (46)
| Predicate | Object |
|---|---|
| instanceOf |
relational database management system edition
ⓘ
software product edition ⓘ |
| comparedTo |
has fewer features than SQL Server Enterprise Edition
ⓘ
has more features than SQL Server Express Edition ⓘ |
| developedBy | Microsoft ⓘ |
| editionTier | mid-tier ⓘ |
| firstReleasedAsPartOf | early Microsoft SQL Server versions (1990s) ⓘ |
| hasLimitation |
fewer advanced BI and analytics features than Enterprise Edition
ⓘ
fewer high availability options than Enterprise Edition ⓘ lower maximum compute and memory limits than Enterprise Edition ⓘ |
| includesComponent |
SQL Server Analysis Services
ⓘ
surface form:
SQL Server Analysis Services (limited or basic, depending on version)
SQL Server Reporting Services (SSRS) basic capabilities ⓘ |
| licenseModel |
Server+CAL licensing (for many recent versions)
ⓘ
core-based licensing (for many recent versions) ⓘ |
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| positionInProductLine | between Express Edition and Enterprise Edition ⓘ |
| productFamily | Microsoft data platform ⓘ |
| providesFeature |
SQL Server Agent
ⓘ
Transact-SQL support ⓘ analytics features ⓘ authentication and authorization ⓘ basic backup and restore ⓘ basic high availability features ⓘ basic partitioning support (depending on version) ⓘ basic performance tuning tools ⓘ core database engine ⓘ database mirroring (deprecated in newer versions) ⓘ encryption features ⓘ indexing ⓘ query optimization ⓘ relational data storage ⓘ reporting features ⓘ security features ⓘ |
| supports |
Linux
ⓘ
surface form:
Linux operating system (in newer versions)
OLTP workloads ⓘ Windows ⓘ
surface form:
Windows operating system
backup compression (depending on version) ⓘ basic Always On availability groups (limited compared to Enterprise) ⓘ basic data warehousing ⓘ |
| targetApplicationType |
medium-sized applications
ⓘ
small applications ⓘ |
| targetUser |
medium-sized organizations
ⓘ
small organizations ⓘ |
| useCase |
branch office databases
ⓘ
departmental databases ⓘ line-of-business applications ⓘ |
Referenced by (4)
Full triples — surface form annotated when it differs from this entity's canonical label.
subject surface form:
Enterprise Edition (Microsoft SQL Server)
this entity surface form:
Standard Edition (Microsoft SQL Server)
this entity surface form:
SQL Server Standard Edition