SQL Server Express

GPTKB entity

Statements (54)
Predicate Object
gptkbp:instanceOf relational database management system
gptkbp:compatibleWith gptkb:SQL_Server_Integration_Services
gptkb:SQL_Server_Profiler
gptkb:SQL_Server_Data_Tools
gptkbp:developedBy gptkb:Microsoft
gptkbp:edition gptkb:Microsoft_SQL_Server
SQL Server Express LocalDB
SQL Server Express with Advanced Services
SQL Server Express with Tools
gptkbp:excludes gptkb:SQL_Server_Analysis_Services
gptkb:SQL_Server_Reporting_Services
gptkb:SQL_Server_Agent
gptkbp:firstReleased 2005
gptkbp:hasFeature automatic backups
basic reporting
basic security features
database mirroring (witness only)
https://www.w3.org/2000/01/rdf-schema#label SQL Server Express
gptkbp:intendedUse learning
small-scale applications
entry-level database solutions
gptkbp:latestReleaseVersion gptkb:SQL_Server_2022_Express
2022
gptkbp:license freeware
gptkbp:limitation no Analysis Services
no Reporting Services
no SQL Agent
gptkbp:maximumCPU 4 cores
gptkbp:maximumDatabaseSize 10 GB
gptkbp:notableRelease gptkb:SQL_Server_Developer
gptkb:SQL_Server_Enterprise
gptkb:SQL_Server_Standard
gptkb:SQL_Server_Web
gptkbp:operatingSystem gptkb:Windows
gptkbp:partOf gptkb:Microsoft_SQL_Server_family
gptkbp:RAM 1410 MB
gptkbp:supports encryption
authentication
backup and restore
indexes
constraints
ACID transactions
foreign keys
stored procedures
triggers
views
primary keys
replication (as subscriber only)
gptkbp:supportsLanguage gptkb:Transact-SQL
gptkb:ANSI_SQL
gptkbp:website https://www.microsoft.com/en-us/sql-server/sql-server-downloads
gptkbp:bfsParent gptkb:MSDE
gptkb:Microsoft_SQL_Server_family
gptkbp:bfsLayer 7