Overview
Microsoft SQL Server is the second-largest commercial relational database by deployed footprint and the dominant database in Windows-centric mid-market and enterprise estates. The flagship on-premise release, SQL Server 2025, was announced at Ignite 2024 and reached general availability in 2025 with native vector data types, T-SQL JSON enhancements, REST endpoints for the database engine, and tighter integration with Microsoft Fabric.
The product line includes the boxed editions (Express, Web, Standard, Enterprise), SQL Server on Linux, Azure SQL Database (managed PaaS), Azure SQL Managed Instance (near-100% feature parity for lift-and-shift), and SQL Server enabled by Azure Arc for hybrid governance. Most enterprises run a mix: traditional on-premise Standard and Enterprise editions for ERP and line-of-business systems, Azure SQL for new applications, and Managed Instance for migrations off self-managed servers.
Key Features
- T-SQL with native VECTOR data type and ANN vector search (2025)
- Always On Availability Groups for synchronous and asynchronous HA/DR
- In-Memory OLTP (Hekaton) and Columnstore indexes for hybrid workloads
- Intelligent Query Processing — automatic plan correction and adaptive joins
- Row-level security, dynamic data masking, and Always Encrypted with secure enclaves
- SQL Server Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS)
- Polybase for federated queries across S3, ADLS, MongoDB, Oracle, Teradata
- Linux support (RHEL, Ubuntu, SLES) and container images on Microsoft Container Registry
- Azure Arc-enabled SQL for centralised on-premise governance through the Azure portal
- Built-in Change Data Capture, temporal tables, and JSON document storage
- Free Developer Edition with full Enterprise functionality for non-production
- Tight Power BI and Microsoft Fabric mirroring for analytic offload
Pricing
| Edition | Model | Cost |
|---|---|---|
| SQL Server Express | Free | $0 (10 GB database, 1 socket / 4 cores limit) |
| SQL Server Standard | Per core (perpetual) | $3,945/core, 4-core minimum per instance |
| SQL Server Standard | Server + CAL | $989 server + $230 per CAL |
| SQL Server Enterprise | Per core (perpetual) | $15,123/core, 4-core minimum per instance |
| Azure SQL Database | vCore or DTU | ~$0.50–$5+ per vCore/hour depending on tier |
| Azure SQL Managed Instance | vCore | From ~$730/month (4-vCore General Purpose) |
Pricing verified May 2026 from Microsoft Volume Licensing price list. Software Assurance adds approximately 25% per year. Azure Hybrid Benefit lets organisations apply existing licences to Azure SQL and reduces effective cost by 30–55%.
Strengths
- Best price-performance among commercial relational databases at the Standard tier
- Tightest integration with the Microsoft developer stack — .NET, Power BI, Visual Studio
- Azure SQL Managed Instance provides near-complete lift-and-shift from on-premise
- Always On Availability Groups handle most enterprise HA requirements without third-party tools
- Mature toolchain — SSMS, SQL Server Data Tools, Database Migration Assistant
- Azure Hybrid Benefit materially reduces cloud TCO for licensed customers
Limitations
- Enterprise edition pricing has risen 15–25% over the past two release cycles
- Linux feature parity has gaps (Polybase, Stretch Database, distributed replay)
- Vector search in SQL Server 2025 trails dedicated vector databases on very large workloads
- HA configurations beyond Always On Basic require Enterprise edition licensing
- Audit complexity around virtualisation, hyperthreading, and Software Assurance terms