Microsoft SQL Server
Microsoft's relational database, the default choice in .NET and Windows shops, with columnstore indexes for analytics. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- Microsoft
- Created by
- —
- First release
- 1989
- License
- Proprietary
- Open source
- No
- Pricing
- Free with paid plans
- Website
- https://www.microsoft.com/sql-server
- Written in
- C, C++
- Data model
- Relational, Graph
- Storage layout
- Hybrid row and column
- Workload
- Both (HTAP)
- Analytics architecture
- Not an analytics platform
- Query language
- T-SQL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Server, Managed cloud
- Scaling
- Replication
- Create, read, update, delete
- Create: fast (Fast inserts, bulk copy for loads); Read: fast (Mature optimizer, row and column indexes); Update: fast (In-place updates); Delete: fast (Fast deletes, ghost cleanup in the background)