Table of Contents

The latest version of Microsoft SQL Server is SQL Server 2025 (version 17.x). Microsoft made it generally available on November 18, 2025, and it is the current major release as of November 2026. The previous release, SQL Server 2022 (16.x), reached general availability on November 16, 2022.
Microsoft keeps improving SQL Server 2025 through cumulative updates (CUs). The most recent one is CU11, build 17.0.5065.9, released on November 12, 2026, as listed on the Microsoft SQL Server latest updates page. If you are installing SQL Server today, start with SQL Server 2025 and apply the latest CU.
This guide explains what is new in SQL Server 2025, how it compares with SQL Server 2022, the version history, and a step-by-step upgrade plan. All feature details come from Microsoft’s What’s new in SQL Server 2025 documentation.
SQL Server version history at a glance:
| Release | Version number | General availability |
|---|---|---|
| SQL Server 2025 | 17.x | November 18, 2025 |
| SQL Server 2022 | 16.x | November 16, 2022 |
| SQL Server 2019 | 15.x | November 4, 2019 |
| SQL Server 2017 | 14.x | October 2, 2017 |
| SQL Server 2016 | 13.x | June 1, 2016 |
Brolly Academy in Hyderabad is a top training institute offering courses in Core Java, Full-Stack Java, Data Science, Machine Learning, Snowflake, Digital Marketing, Generative AI, Prompt Engineering, Azure Admin, Azure DevOps, Azure Data Factory, and React. All programs include hands-on training, placement support, and certification. WhatsApp us or Enroll Now!
SQL Server Latest Version - SQL Server 2025: What's New
The most recent version of SQL Server, SQL Server 2025, builds on SQL Server 2022 and adds AI features directly inside the database engine. Microsoft groups the changes into AI, developer, analytics, availability, security, database engine, query processing, language and tools. Here are the four areas that matter most for developers and DBAs.
1. Built-in AI and Vector Search
SQL Server 2025 adds a native vector data type to store embeddings for similarity search and machine learning applications. New functions such as VECTOR_DISTANCE, VECTOR_NORM and VECTOR_NORMALIZE work on these vectors inside T-SQL.
You can also register AI models with CREATE EXTERNAL MODEL, generate embeddings with AI_GENERATE_EMBEDDINGS and split text with AI_GENERATE_CHUNKS. Approximate vector indexes (CREATE VECTOR INDEX and VECTOR_SEARCH, based on DiskANN) are still in preview and need the PREVIEW_FEATURES database scoped configuration.
2. Developer Features: JSON, Regular Expressions and REST
Developers get a native JSON data type that stores JSON in a binary format, plus JSON indexing and new JSON_OBJECTAGG and JSON_ARRAYAGG functions. Regular expression support arrives through functions like REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR and REGEXP_COUNT.
The stored procedure sp_invoke_external_rest_endpoint lets the database call REST or GraphQL endpoints, and change event streaming (preview) can publish inserts, updates and deletes to Azure Event Hubs or Fabric Eventstream. Smaller additions include the || string concatenation operator, CURRENT_DATE, PRODUCT() and BASE64_ENCODE / BASE64_DECODE.
3. Security and Database Engine Improvements
On the engine side, optimized locking reduces blocking and lock memory and avoids lock escalation. Tempdb space resource governance stops runaway workloads from filling tempdb, and accelerated database recovery now covers tempdb too. A new ZSTD backup compression algorithm gives faster, smaller backups.
For security, PBKDF2 password hashing is on by default, TLS 1.3 with TDS 8.0 is supported across many features, and SQL Server enabled by Azure Arc can use managed identity with Microsoft Entra authentication.
4. Editions, Tools and Microsoft Fabric
SQL Server 2025 raises the Standard edition limit to the lesser of 4 sockets or 32 cores and 256 GB buffer pool memory, and Express edition now supports databases up to 50 GB. There are two free developer editions, Enterprise Developer and Standard Developer. Web edition is discontinued. Full limits are on the SQL Server 2025 editions page.
Mirroring in Microsoft Fabric replicates on-premises SQL Server 2025 data to Fabric continuously, and GitHub Copilot is available in SQL Server Management Studio. Basic Python and R language integration is still included for in-database analytics.
SQL Server 2025 vs. SQL Server 2022: What's the Difference?
Microsoft SQL Server is a relational database management system (RDBMS) used by businesses of every size. SQL Server 2022 focused on Azure-connected features, while SQL Server 2025 focuses on AI inside the database, developer productivity and higher edition limits. Here is how the two versions compare.
1. Performance Improvements:
SQL Server 2022 introduced Parameter Sensitive Plan optimization, DOP feedback and Query Store on by default for new databases. SQL Server 2025 extends SQL Server query processing with optional parameter plan optimization (OPPO), cardinality estimation feedback for expressions and optimized sp_executesql, and turns DOP feedback on by default.
Optimized locking is also new in 2025, which helps busy OLTP systems that suffered from blocking on SQL Server 2022. Actual gains depend on your workload, so test with your own queries.
2. Security Enhancements:
SQL Server 2022 added Microsoft Entra authentication, the ledger feature and Always Encrypted with secure enclaves improvements. SQL Server 2025 adds PBKDF2 password hashing by default, TLS 1.3 support across more components, OAEP padding for RSA encryption and managed identity support for Azure connected features through Azure Arc.
Before upgrading, read Microsoft’s breaking changes list, because the stronger encryption defaults affect linked servers, replication and log shipping.
3. Integration with Azure and Microsoft Fabric:
SQL Server 2022 offered Azure Synapse Link and the link feature for Azure SQL Managed Instance. In SQL Server 2025, Synapse Link is discontinued and replaced by Mirroring in Microsoft Fabric. SQL Server 2025 also adds change event streaming, Data API builder for REST and GraphQL endpoints, and the ability to call Azure OpenAI and other REST endpoints from T-SQL.
4. Availability and Resilience:
SQL Server 2022 introduced contained availability groups and improved accelerated database recovery. SQL Server 2025 adds full and differential backups on secondary replicas, fast failover for persistent availability group health issues, faster asynchronous page request dispatching during failover, and backup to immutable Azure Blob storage. Basic availability groups remain the option for Standard edition.
Brolly Academy in Hyderabad is a top training institute offering courses in Core Java, Full-Stack Java, Data Science, Machine Learning, Snowflake, Digital Marketing, Generative AI, Prompt Engineering, Azure Admin, Azure DevOps, Azure Data Factory, and React. All programs include hands-on training, placement support, and certification. WhatsApp us or Enroll Now!
How to Upgrade to SQL Server 2025: A Step-by-Step Guide
Upgrading to the latest version of SQL Server gives you new features, performance improvements and longer support. SQL Server 2025 mainstream support runs until January 2031 and extended support until January 2036, according to the Microsoft lifecycle page. Follow these steps for a safe upgrade.
1. Review System Requirements:
Check the SQL Server 2025 hardware and software requirements first. On Windows it needs Windows 10 or later, or Windows Server 2019 or later, an x64 processor of at least 1.4 GHz (2.0 GHz recommended), at least 1 GB of memory (4 GB or more recommended), 6 GB of free disk space and .NET Framework 4.7.2. Enterprise edition is supported only on Windows Server.
2. Backup Your Databases:
Data integrity is paramount during an upgrade. Begin by creating comprehensive backups of all databases to safeguard against potential issues. This step provides a safety net, allowing for the restoration of data in case of any unexpected problems during the upgrade process.
3. Check Compatibility:
Check that your databases and applications work with SQL Server 2025. Review the breaking changes and the discontinued features: Data Quality Services, Master Data Services, Synapse Link and Web edition are gone, and Reporting Services is now part of Power BI Report Server. Run an assessment with Microsoft’s migration tools and fix compatibility issues before the upgrade.
4. Update SQL Server Management Studio (SSMS):
Install the latest SQL Server Management Studio (SSMS 22) before you manage SQL Server 2025. SSMS 22 was released alongside SQL Server 2025 and includes GitHub Copilot. Older SSMS versions may not handle new features such as the vector and JSON data types properly.
5. Choose the Upgrade Method:
Select an appropriate upgrade method based on your organization’s requirements and constraints. Options include in-place upgrades, where the existing SQL Server instance is upgraded, and side-by-side migrations, involving the installation of a new SQL Server instance alongside the existing one. Consider factors like downtime tolerance and resource availability when making this decision.
6. Perform a Test Upgrade:
Before executing the upgrade in a production environment, conduct a test upgrade on a non-production server. This allows you to identify and resolve any issues specific to your databases and applications, ensuring a smoother transition when upgrading the live environment.
7. Install SQL Server 2025:
Run SQL Server 2025 setup on the target server and pick the right edition. Follow the installation wizard and set the instance configuration, authentication mode and feature selections. After installation, apply the latest cumulative update and change the database compatibility level to 170 when your tests pass, so the new features become available.
FAQs
What is the latest version of SQL Server?
The latest version of SQL Server is SQL Server 2025, version 17.x. Microsoft released it for general availability on November 18, 2025. As of November 2026, the newest cumulative update is CU11, build 17.0.5065.9, released on November 12, 2026. SQL Server 2022 (16.x) is the previous major release and is still supported.
What are the key new features in SQL Server 2025?
SQL Server 2025 adds a native vector data type and vector functions for AI search, external AI model support, a native JSON data type, regular expression functions, optimized locking, ZSTD backup compression, change event streaming and Mirroring in Microsoft Fabric. It also raises Standard edition limits to 32 cores and 256 GB memory.
What is the version number of SQL Server 2025?
SQL Server 2025 is version 17.x, and its database compatibility level is 170. SQL Server 2022 is 16.x, SQL Server 2019 is 15.x and SQL Server 2017 is 14.x. You can check your installed build by running SELECT @@VERSION in SQL Server Management Studio.
When was SQL Server 2025 released?
SQL Server 2025 became generally available on November 18, 2025. Microsoft follows it with regular cumulative updates that fix issues and add improvements. Mainstream support runs until January 2031 and extended support until January 2036, so it is a safe choice for new projects.
Is SQL Server 2025 free?
SQL Server 2025 has free editions. Express edition is free for small applications and now supports databases up to 50 GB. Enterprise Developer and Standard Developer editions are free for development and testing but cannot be used in production. Enterprise and Standard editions need a paid licence.
What is the difference between SQL Server 2025 and SQL Server 2022?
SQL Server 2025 adds AI features such as the vector data type and embedding generation, a native JSON type, regular expressions, optimized locking and Fabric mirroring. It also raises Standard edition limits and drops Web edition. SQL Server 2022 focused more on Azure-connected features like Synapse Link and the link to Azure SQL Managed Instance.
What editions are available in SQL Server 2025?
SQL Server 2025 comes in Enterprise, Standard, Enterprise Developer, Standard Developer, Evaluation and Express editions. Evaluation edition works for 180 days. The Standard Developer edition is new and matches Standard edition features for testing. Web edition and Express with Advanced Services are discontinued.
What are the system requirements for SQL Server 2025?
On Windows, SQL Server 2025 needs Windows 10 or later, or Windows Server 2019 or later, an x64 processor of at least 1.4 GHz, at least 1 GB of memory (512 MB for Express), 6 GB of free disk space and .NET Framework 4.7.2. Microsoft recommends 4 GB of memory or more.
Can I install SQL Server 2025 on Linux?
Yes, SQL Server 2025 runs on Linux as well as Windows. Microsoft added support for Red Hat Enterprise Linux 10 and Ubuntu 24.04, along with TLS 1.3 and tmpfs support for tempdb on Linux. You can also run it in Docker containers for development and testing.
Does SQL Server 2025 support AI and vector search?
Yes. SQL Server 2025 stores embeddings in a native vector data type and offers functions like VECTOR_DISTANCE for similarity search. It can call external AI models and generate embeddings with AI_GENERATE_EMBEDDINGS. The approximate vector index and VECTOR_SEARCH are still in preview and need the PREVIEW_FEATURES setting.
What is the latest cumulative update for SQL Server 2025?
As of November 2026, the latest cumulative update is SQL Server 2025 CU11 (KB5129223), build 17.0.5065.9, released on November 12, 2026. Microsoft lists every build on its latest updates page. Always test a new CU on a non-production server before applying it to production.
Is SQL Server 2022 still supported?
Yes, SQL Server 2022 is still supported and still receives cumulative updates. Its latest update as of November 2026 is CU28, build 16.0.4325.4. However, SQL Server 2025 has a longer support window, so new installations should usually start on 2025.
How do I upgrade to the latest version of SQL Server?
Check the SQL Server 2025 requirements, back up every database, and review breaking changes and discontinued features. Update SSMS, choose an in-place upgrade or side-by-side migration, and test on a non-production server. Then install SQL Server 2025, apply the latest CU and raise the compatibility level to 170 after testing.
Can I upgrade directly from SQL Server 2016 or 2019 to SQL Server 2025?
Yes. Microsoft supports direct upgrades to SQL Server 2025 from SQL Server 2014 SP3, SQL Server 2016 SP3, SQL Server 2017, 2019 and 2022. Older versions such as SQL Server 2008 or 2012 need a migration instead, for example backup and restore. Test carefully, because Data Quality Services and Master Data Services are not available in 2025.
What features were removed in SQL Server 2025?
SQL Server 2025 discontinues Data Quality Services, Master Data Services, Synapse Link, Purview access policies, Web edition and Express with Advanced Services. Synapse Link is replaced by Mirroring in Microsoft Fabric, and on-premises Reporting Services is consolidated into Power BI Report Server.
What is optimized locking in SQL Server 2025?
Optimized locking is a database engine feature that reduces blocking and lock memory and avoids lock escalation. It helps busy transaction systems where many users update data at the same time. It is available in Enterprise and Standard editions of SQL Server 2025.
Does SQL Server 2025 support JSON natively?
Yes, SQL Server 2025 adds a native JSON data type that stores JSON in an optimized binary format, along with JSON indexing. New aggregate functions JSON_OBJECTAGG and JSON_ARRAYAGG build JSON objects and arrays from query results. Earlier versions stored JSON as plain text in NVARCHAR columns.
Does SQL Server 2025 support regular expressions?
Yes, SQL Server 2025 adds regular expression functions to T-SQL, including REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_COUNT, REGEXP_MATCHES and REGEXP_SPLIT_TO_TABLE. They let you find, replace or validate text patterns, such as email formats, directly in queries.
Which SSMS version should I use with SQL Server 2025?
Use the latest SQL Server Management Studio, SSMS 22, with SQL Server 2025. Microsoft released SSMS 22 in November 2025 alongside SQL Server 2025. It understands the new data types and features and includes GitHub Copilot to help write and explain queries. Older SSMS versions may not handle the new features correctly.
What is the difference between an in-place upgrade and a side-by-side migration?
An in-place upgrade updates the existing SQL Server instance directly to SQL Server 2025. A side-by-side migration installs a new SQL Server 2025 instance next to the old one and then moves the databases across. Side-by-side takes more effort but makes rollback easier if something goes wrong.
Why should I back up databases before upgrading SQL Server?
Backups protect your data if something goes wrong during the upgrade. Full backups of all databases give you a safety net, so you can restore data if setup fails or an application behaves unexpectedly. Also save logins, jobs and linked server settings, because they live outside user databases.
What is Mirroring in Microsoft Fabric for SQL Server 2025?
Mirroring in Microsoft Fabric continuously replicates data from an on-premises SQL Server 2025 database into Microsoft Fabric for analytics. It replaces Synapse Link, which is discontinued in SQL Server 2025. You can control its resource use with Resource Governor and enable automatic reseed to keep the transaction log from filling up.
What are the Standard edition limits in SQL Server 2025?
In SQL Server 2025, Standard edition can use the lesser of 4 sockets or 32 cores, up from 24 cores in SQL Server 2022, and up to 256 GB of buffer pool memory. Resource Governor is now included in Standard edition with the same functionality as Enterprise edition.
Should I learn SQL Server 2025 or SQL Server 2022?
Learn on SQL Server 2025, because it is the latest version and companies will move to it over the next few years. The core T-SQL skills are the same in both versions, so what you learn also applies to SQL Server 2022 and 2019. The free Developer editions make practice easy.
How do I check which SQL Server version is installed?
Connect to the server in SSMS and run SELECT @@VERSION, or use SERVERPROPERTY(‘ProductVersion’). A version starting with 17 means SQL Server 2025, 16 means SQL Server 2022 and 15 means SQL Server 2019. Compare the full build number with Microsoft’s latest updates page to see if a newer CU is available.