SQL Server
Microsoft's relational database engine. Licensed per physical core (4-core minimum per instance) or under the Server + CAL model for smaller deployments.
Also known as: MS SQL, SQL Server Standard, SQL Server Enterprise
At a glance
- Licensing model
- Per-core (4-core minimum) OR Server + CAL
- Related entities
- Software Assurance · Always On AG · Passive secondary rights · Enterprise edition · Standard edition
Frequently asked questions
When is Software Assurance worth paying for?
Software Assurance (SA) adds roughly 25–29% per year on top of a perpetual Volume License. It is worth it when you actually use the benefits:
- Version upgrades — the biggest benefit. Without SA, every major upgrade is a fresh purchase.
- License Mobility — needed to run server workloads (SQL Server, SharePoint) on Azure or AWS using your existing license.
- Azure Hybrid Benefit for Windows Server and SQL — saves roughly 40% on Azure VM and SQL DB pricing.
- Training vouchers, planning services, 24/7 problem-resolution support.
SA is rarely worth it for desktop apps you do not plan to upgrade. It almost always pays for itself on Windows Server, SQL Server and Exchange Server in 3 years.
Can I use SQL Server Developer Edition in production?
No. Developer Edition is feature-equivalent to Enterprise but the license restricts use to development, testing and demonstration — never production workloads. The moment a real customer or business process depends on the data, you are out of compliance.
Microsoft enforces this in audits, and converting a Developer install to production after the fact is not a defense. If you need Enterprise features in production, license Enterprise. If Standard is enough, license Standard. For free production use with hard limits, SQL Server Express is the only legitimate path.
How does Windows Server core licensing work?
Windows Server 2019, 2022 and SE are licensed per physical core, sold in 2-core packs. The minimum is 16 cores per server — even if your hardware has fewer, you license to that floor.
Two more rules. Every processor must be licensed for at least 8 cores. The whole server is licensed even if Windows Server runs in only one VM — you do not get to license a slice. In virtualized environments, Standard gives you 2 VM rights per fully licensed server (stackable), Datacenter gives you unlimited VM rights.