Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Microsoft SQL Server

microsoft.com

  • Free plan
  • Windows
  • Linux
  • API
  • Self-hosted
7.1 Club score Visit microsoft.com

What Microsoft SQL Server is

Microsoft SQL Server is a database platform for storing, processing, and securing data. Its Database Engine includes replication, full-text search, relational, XML, and JSON management, as well as Python and R machine learning services. Integration Services provides graphical tools and programmable objects for moving, copying, and transforming data. PolyBase can query sources such as Azure Storage, S3, and ODBC data sources. SQL Server 2025 adds vector search, embedding generation, text chunking, and DiskANN vector indexing, and integrates with LangChain, Semantic Kernel, Entity Framework Core, Azure, and Microsoft Fabric. Microsoft provides downloads for Windows and Linux, plus a Docker container image. The freemium offering includes a free plan. Express is a free entry-level edition for learning and smaller applications, with a 50 GB database size; a Database Engine instance is limited to the lesser of one socket or four cores. Developer editions include Enterprise or Standard functionality but are licensed for development and testing, not production. Enterprise and Standard licensing options are listed, with no prices provided. SQL Server 2025 does not support SUSE Linux Enterprise Server.

Who it suits

SQL Server can suit organizations needing a database engine alongside data integration or virtualization tools. Microsoft describes Enterprise for complex workloads and Standard as a balance of performance, security, and affordability for businesses.

Good to know, and what to watch

  • Supports relational, XML, and JSON data
  • PolyBase queries Azure Storage, S3, and ODBC
  • SQL Server 2025 includes vector search
  • Downloads available for Windows and Linux
  • Express is free for learning and small applications
  • Express database size is 50 GB
  • Express instance limited to one socket or four cores
  • SQL Server 2025 does not support SUSE Linux Enterprise Server
  • Developer edition is licensed for non-production use

Standard per core

—

Standard per core

—

Standard server

—

Standard server

—

Free plan

Getting started

  1. Open the Microsoft SQL Server website
  2. Choose Windows or Linux downloads, or use the Docker container image
  3. Select an edition or licensing plan
  4. Use Developer for non-production development and testing
  5. Use Express for learning or desktop and small server applications
  6. Configure security, permissions, encryption, and secure connections

Limits to check

Express is limited to a 50 GB database and a single Database Engine instance using the lesser of one socket or four cores. Developer is restricted to non-production development and test use, and SQL Server 2025 does not support SUSE Linux Enterprise Server.

The Club's review

Overview

Microsoft SQL Server is a database platform for storing, processing, and securing data, with companion tools for integration and virtualization. It suits organizations that need a capable relational engine across Windows, Linux, or self-hosted deployments. Its broad feature set is a strong draw, but edition limits and production licensing deserve close attention.

Key features

The SQL Server Database Engine supports relational, XML, and JSON data, replication, full-text search, and Python and R machine-learning services. High availability and read replicas are supported, with a stated maximum of 32,767 connections. That range gives organizations options for demanding database setups, though it does not erase the need to select an edition that fits the workload.

Integration Services provides graphical tools and programmable objects for moving, copying, and transforming data. PolyBase can query Azure Storage, S3, and ODBC data sources, useful when information is spread beyond the database engine. SQL Server 2025 adds vector search, embedding generation, text chunking, and DiskANN vector indexing, and integrates with LangChain, Semantic Kernel, Entity Framework Core, Microsoft Azure, and Microsoft Fabric.

Microsoft's SQL Server security guidance covers platform and network security, permissions, encryption, and secure connections. These controls matter to teams responsible for protecting data, but they still need to be applied as part of a secure deployment.

Pricing

SQL Server uses a freemium model. Express is the free entry-level edition for learning and desktop or small-server applications, and its database size is capped at 50 GB. A single Database Engine instance is also limited to the lesser of one socket or four cores, so it is not the free route to an unrestricted production deployment.

Developer editions provide Enterprise or Standard functionality at no charge for development and testing, but their license excludes production use. They suit teams building and validating applications, not organizations seeking a free live database.

Enterprise is offered as a 2-core pack through volume licensing and hosting, for organizations with complex workloads. Standard comes as a 2-core pack, a server license, or a client access license; Microsoft positions it as a balance of performance, security, and affordability for businesses. These paid plans use custom pricing, so buyers should weigh the edition and licensing model against their deployment needs.

Platforms

SQL Server is available for Windows and Linux, with a Docker container image. Its supported platforms also include API and self-hosted deployments. SQL Server 2025 does not support SUSE Linux Enterprise Server, a meaningful constraint for organizations standardized on that distribution. The deployment model is both, and SQL Server is not a managed service, so teams should account for operating and maintaining their deployment.

Who it's for

SQL Server is a strong fit for businesses that need a full-featured database engine, data movement and transformation tools, and the ability to query external storage. Enterprise is aimed at complex workloads; Standard is a more balanced option for businesses. Developers can use Developer edition for non-production work, while learners and small applications can start with Express within its size and instance limits.

It is less suitable for buyers seeking a managed database service or a free edition without production restrictions. Linux users should also check distribution support before choosing SQL Server 2025.

Pros and cons

Pros

  • Broad database capabilities: Relational, XML, and JSON management, replication, and full-text search cover varied data needs.
  • Integration beyond the engine: Integration Services and PolyBase support data movement and querying external sources, including Azure Storage and S3.
  • Free ways to start: Express supports learning and small applications, while Developer provides Enterprise or Standard functionality for development and testing.
  • Multiple deployment options: Windows, Linux, self-hosted, and Docker deployments give teams flexibility in where they run it.

Cons

  • Edition rules are consequential: Developer cannot be used in production, and Express has a 50 GB database cap plus an instance limit of one socket or four cores, whichever is lower.
  • Paid licensing is custom-priced: Buyers must assess core, server, and client access licensing rather than rely on a published price.
  • No managed-service option: Organizations choosing SQL Server must plan for operating their deployment.
  • Linux support has a gap: SQL Server 2025 does not support SUSE Linux Enterprise Server.

Alternatives

Consider MySQL if you want a free-plan database with a Community Edition for SQL and NoSQL applications, replication, and high-availability components, as well as a free trial. Azure SQL Database is a better fit for readers drawn to its free offer of 100,000 vCore seconds, 32 GB each of data and backup storage, and 10 databases per subscription. For a different database approach, Amazon DynamoDB has a free tier with 25 WCUs, 25 RCUs, 25 GB of storage, and 25 replicated WCUs per region and payer account.

Firestore, Amazon RDS, SQLite, Azure Cosmos DB for NoSQL, and MarkLogic are also alternatives to consider.

Browse more options in Database Software, Relational Databases, and Spatial Databases.

Verdict

Choose SQL Server if your organization needs a capable database engine with integration and virtualization tools, and can match its workload to the right edition and license. Its breadth, deployment choices, and free development and learning editions are compelling. Look elsewhere if you need a managed service or cannot accept the production restrictions and limits attached to the free editions.

The verdict

SQL Server offers multiple editions and deployment options, with features spanning database management, integration, and virtualization. Review the edition limits and licensing terms carefully, especially when choosing Express or Developer for a specific workload.

Questions people ask

Is SQL Server free?

Yes. A free plan is available. Developer is a free download for non-production development and test use, and Express is a free entry-level edition.

What platforms does it support?

SQL Server is available for API use, Linux, self-hosted deployments, and Windows. Microsoft also provides a Docker container image.

What is the Express database limit?

Express lists a 50 GB database size. A single Database Engine instance is limited to the lesser of one socket or four cores.

Can SQL Server handle JSON data?

Yes. The Database Engine includes JSON management, and JSON data support is listed.

Does it support high availability?

Yes. High availability and read replicas are listed capabilities.

What is Developer licensed for?

Developer editions include Enterprise or Standard functionality but are licensed for development and testing, not production use.

What the maker publishes

AI features
SQL Server 2025 includes vector search, vector embedding generation, text chunking, and DiskANN vector indexing. source
Database engine
SQL Server Database Engine stores, processes, and secures data and includes replication, full-text search, relational, XML and JSON management, and Python and R machine learning services. source
Data integration
Integration Services provides graphical tools and programmable objects for moving, copying, and transforming data. source
Data virtualization
PolyBase can query storage sources such as Azure Storage and S3, as well as ODBC data sources. source
Developer edition limits
Developer editions include Enterprise or Standard edition functionality but are licensed for development and testing, not production use. source
Express edition limits
Express is a free entry-level edition for learning and desktop or small server applications; a single Database Engine instance is limited to the lesser of one socket or four cores. source
Free plan
Yes source
Integrations
SQL Server 2025 integrates with LangChain, Semantic Kernel, Entity Framework Core, Microsoft Azure, and Microsoft Fabric. source
Linux support limit
SQL Server 2025 does not support SUSE Linux Enterprise Server. source
Security
Microsoft's SQL Server security guidance covers platform and network security, permissions, encryption, and secure connections. source
Who it serves
Microsoft describes Enterprise as intended for organizations with complex workloads and Standard as a balance of performance, security, and affordability for businesses. source
Windows and Linux
Microsoft provides SQL Server downloads for Windows and Linux, as well as a SQL Server container image for Docker. source

Checked against the maker's pages on 11 Oct 2026.