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.

All labels observed (3)

How this entity was disambiguated

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 (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 Microsoft SQL Server
linked to: 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 operating system (in newer versions)
linked to: Linux

OLTP workloads
Windows operating system
linked to: Windows

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

How these facts were elicited

Referenced by (6)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server hasEdition Standard Edition
Enterprise Edition (Microsoft SQL Server) comparedTo Standard Edition (Microsoft SQL Server)
subject linked to: Enterprise Edition
linked to: Standard Edition
Express Edition upgradePathTo Standard Edition
SQL Server Integration Services includedWith SQL Server Standard Edition
linked to: Standard Edition
SQL Server Analysis Services featureOf SQL Server Standard Edition
linked to: Standard Edition
SQL Server on Azure Virtual Machines supportsEdition SQL Server Standard Edition
linked to: Standard Edition