Statements (69)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:Database_Management_System
|
| gptkbp:analyzes |
No analysis services support
|
| gptkbp:application |
Can be used for mobile applications
Can be used for web applications |
| gptkbp:applicationType |
Supports user-defined types
|
| gptkbp:automated |
Supports scripting for automation
|
| gptkbp:canSupport |
Supports JSON data format
|
| gptkbp:community |
Free community edition available
|
| gptkbp:communityFeedback |
Can backup to cloud storage
|
| gptkbp:communitySupport |
Active community support
Supports XML data format |
| gptkbp:compatibleWith |
Compatible_with_SQL_Server_Management_Studio
|
| gptkbp:component |
Can_integrate_with_Azure
|
| gptkbp:dataBusWidth |
10 GB
|
| gptkbp:dataUsage |
Can be used with various data access layers
Limited data compression features Stores data in .mdf files Supports automated backups Supports backup and restore Supports data import and export Supports data migration tools Supports_ODBC_and_OLE_DB_data_access |
| gptkbp:developedBy |
gptkb:Microsoft
|
| gptkbp:developsStrategiesFor |
Supports stored procedures
|
| gptkbp:features |
Basic database functionality
|
| gptkbp:fullText |
Supports full-text search
|
| gptkbp:handles |
Basic error handling features
|
| gptkbp:hasVersion |
Latest version is 2019
|
| https://www.w3.org/2000/01/rdf-schema#label |
SQL Server Express
|
| gptkbp:installation |
Lightweight installation
Can be installed via installer or command line Multiple installation options available Small installation size |
| gptkbp:integration |
Integrates_with_Visual_Studio
|
| gptkbp:is_monitored_by |
Limited monitoring tools available
|
| gptkbp:keyFigures |
Supports foreign keys for relationships
|
| gptkbp:launchDate |
10 concurrent connections
|
| gptkbp:license |
Freeware
|
| gptkbp:localArt |
Includes LocalDB for developers
|
| gptkbp:localNames |
LocalDB is a lightweight version for developers
|
| gptkbp:manager |
gptkb:SQL_Server_Management_Studio
|
| gptkbp:maximumDepth |
1 GB
|
| gptkbp:performance |
Basic performance tuning options
Optimized for performance in small applications |
| gptkbp:platforms |
Windows
|
| gptkbp:portrayedBy |
Limited replication capabilities
|
| gptkbp:releaseDate |
2005
|
| gptkbp:reportsTo |
Limited reporting services
|
| gptkbp:security |
Basic security features
Basic data encryption features |
| gptkbp:serviceHistory |
Uses transaction log for recovery
|
| gptkbp:serviceType |
Service packs available for updates
|
| gptkbp:supportedBy |
Supports indexing for performance
Supports stored functions Supports views |
| gptkbp:supportRole |
Supports triggers
|
| gptkbp:supports |
gptkb:SQL_Server_database_engine
Limited support for partitioning Supports .NET applications Supports constraints for data integrity Supports transactions for data consistency |
| gptkbp:systemRequirements |
Minimum system requirements apply
|
| gptkbp:type |
Supports various data types
Limited data replication options available |
| gptkbp:updates |
Can upgrade to higher editions
|
| gptkbp:userInterface |
User-friendly interface for management
|
| gptkbp:uses |
Ideal for small applications
|
| gptkbp:values |
Uses Transact-SQL
|
| gptkbp:youth_development |
Ideal for local development environments
|