{"id":70301,"date":"2025-11-26T15:20:25","date_gmt":"2025-11-26T14:20:25","guid":{"rendered":"https:\/\/www.schneider.im\/?p=70301"},"modified":"2026-02-26T08:54:00","modified_gmt":"2026-02-26T07:54:00","slug":"microsoft-sql-server-2025-available","status":"publish","type":"post","link":"https:\/\/www.schneider.im\/lu\/microsoft-sql-server-2025-available\/","title":{"rendered":"Microsoft SQL Server 2025 available"},"content":{"rendered":"<p style=\"text-align: justify;\">On\u202fNovember 15, 2025, Microsoft announced the\u202fgeneral availability\u202fof SQL Server 2025. This release introduces built-in artificial intelligence (AI), enhanced developer tools, and improvements in performance, security, and cloud integration.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"aligncenter size-large wp-image-70303\" src=\"https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2025-11-26-Update-Microsoft-SQL-Server-2025-available-800x334.png\" alt=\"\" width=\"800\" height=\"334\" srcset=\"https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2025-11-26-Update-Microsoft-SQL-Server-2025-available-800x334.png 800w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2025-11-26-Update-Microsoft-SQL-Server-2025-available-500x209.png 500w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2025-11-26-Update-Microsoft-SQL-Server-2025-available-150x63.png 150w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2025-11-26-Update-Microsoft-SQL-Server-2025-available-768x321.png 768w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2025-11-26-Update-Microsoft-SQL-Server-2025-available.png 1153w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\">What is SQL Server 2025?<\/h2>\n<p style=\"text-align: justify;\">SQL Server 2025 is Microsoft\u2019s latest enterprise-grade relational database management system (RDBMS). It supports deployment across on-premises, cloud, and hybrid environments. The platform is designed to deliver a consistent experience with a focus on scalability, security, and AI integration.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\">Licensing SQL Server 2025 Editions<\/h2>\n<p style=\"text-align: justify;\">There are no significant changes to SQL Server 2025 licensing models. Customers can continue using existing licensing options.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-71658 size-full\" src=\"https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-of-editions.png\" alt=\"\" width=\"1460\" height=\"796\" srcset=\"https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-of-editions.png 1460w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-of-editions-500x273.png 500w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-of-editions-800x436.png 800w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-of-editions-150x82.png 150w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-of-editions-768x419.png 768w\" sizes=\"(max-width: 1460px) 100vw, 1460px\" \/><\/p>\n<p style=\"text-align: justify;\">Key updates include:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Standard Edition:<\/strong>\u202fNow supports up to 32 cores and 256 GB memory. Includes Resource Governor.<\/li>\n<li style=\"text-align: justify;\"><strong>Developer Edition:<\/strong>\u202fA new Standard Developer Edition mirrors Standard Edition features for development and testing.<\/li>\n<li style=\"text-align: justify;\"><strong>Express Edition:<\/strong>\u202fSupports up to 50 GB per database. Express Advanced features are now included by default.<\/li>\n<li style=\"text-align: justify;\"><strong>Web Edition:<\/strong>\u202fMicrosoft has announced SQL Server Web edition is being discontinued, starting with the 2025 release. This makes SQL Server 2022 the final version to include the Web edition, which will remain supported until January 2033. For cost-effective web applications, Microsoft recommend migrating to Azure SQL. It offers scalable solutions, flexible pricing, and elastic pools perfect for multi-tenant apps. If you&#8217;re planning to stay on-premises, the recommended path is to upgrade to the Standard edition.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">For licensing guidance, <a href=\"https:\/\/www.schneider.im\/contact\/\">consult<\/a>\u202fSCHNEIDER IT MANAGEMENT\u202ffor expert advice.<\/p>\n<p>&nbsp;<\/p>\n<h2>Choose your edition of SQL Server 2025<\/h2>\n<p style=\"text-align: justify;\"><strong> <img decoding=\"async\" class=\"aligncenter wp-image-71654 size-full\" src=\"https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison.png\" alt=\"\" width=\"1450\" height=\"984\" srcset=\"https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison.png 1450w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-500x339.png 500w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-800x543.png 800w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-150x102.png 150w, https:\/\/www.schneider.im\/media\/2025\/11\/SCHNEIDER-IT-MANAGEMENT-2026-02-26-Update-SQL-Server-2025-Comparison-768x521.png 768w\" sizes=\"(max-width: 1450px) 100vw, 1450px\" \/><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\">Key Features<\/h2>\n<p style=\"text-align: justify;\"><strong>AI Built-In<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>AI is integrated directly into the SQL Server engine.<\/li>\n<li>Supports semantic search, vector embedding, and retrieval-augmented generation (RAG).<\/li>\n<li>Model management is available via T-SQL, with support for Azure OpenAI Service, OpenAI, and other frameworks.<\/li>\n<li>Enables developers to build AI-powered applications without external tools.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Developer Enhancements<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Native support for JSON, REST APIs, regular expressions (RegEx), and fuzzy string matching.<\/li>\n<li>Change Event Streaming allows real-time data updates to Azure Event Hubs.<\/li>\n<li>SQL Server Management Studio 22 (SSMS 22) includes AI assistance and ARM64 support.<\/li>\n<li>A new high-performance Python driver (mssql-python) supports modern authentication.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Performance and Availability<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Optimized locking reduces memory usage and improves concurrency.<\/li>\n<li>Tempdb resource governance prevents excessive disk usage.<\/li>\n<li>Optional Parameter Plan Optimization stabilizes query performance.<\/li>\n<li>Enhancements to Always On availability groups improve failover speed and diagnostics.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Security<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Microsoft Entra ID (formerly Azure Active Directory) managed identities enable secure, passwordless authentication.<\/li>\n<li>Modern encryption and identity management practices enhance data protection.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Cloud and Hybrid Integration<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Fabric Mirroring enables near real-time analytics with zero extract-transform-load (ETL).<\/li>\n<li>Azure Arc integration provides unified management across environments.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Linux and Container Support<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Expanded support for Red Hat Enterprise Linux 10 and Ubuntu 24.04.<\/li>\n<li>TLS 1.3, signed container images, and tmpfs support for tempdb.<\/li>\n<li>Visual Studio Code integration for container deployment.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>More Information<\/strong><\/h2>\n<p>Official Microsoft announcement: <a href=\"https:\/\/techcommunity.microsoft.com\/blog\/SQLServer\/sql-server-2025-is-now-generally-available\/4470570\">https:\/\/techcommunity.microsoft.com\/blog\/SQLServer\/sql-server-2025-is-now-generally-available\/4470570<\/a><\/p>\n<p style=\"text-align: justify;\">For our <strong>Microsoft page<\/strong>, please visit: <a href=\"https:\/\/www.schneider.im\/software\/microsoft\/\">https:\/\/www.schneider.im\/software\/microsoft<\/a>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-65589\" src=\"https:\/\/www.schneider.im\/media\/2025\/10\/SCHNEIDER-IT-MANAGEMENT-2025-03-11-Graphics-Office-People-8529-800x533.jpg\" alt=\"\" width=\"800\" height=\"533\" srcset=\"https:\/\/www.schneider.im\/media\/2025\/10\/SCHNEIDER-IT-MANAGEMENT-2025-03-11-Graphics-Office-People-8529-800x533.jpg 800w, https:\/\/www.schneider.im\/media\/2025\/10\/SCHNEIDER-IT-MANAGEMENT-2025-03-11-Graphics-Office-People-8529-500x333.jpg 500w, https:\/\/www.schneider.im\/media\/2025\/10\/SCHNEIDER-IT-MANAGEMENT-2025-03-11-Graphics-Office-People-8529-150x100.jpg 150w, https:\/\/www.schneider.im\/media\/2025\/10\/SCHNEIDER-IT-MANAGEMENT-2025-03-11-Graphics-Office-People-8529-768x512.jpg 768w, https:\/\/www.schneider.im\/media\/2025\/10\/SCHNEIDER-IT-MANAGEMENT-2025-03-11-Graphics-Office-People-8529-1536x1024.jpg 1536w, https:\/\/www.schneider.im\/media\/2025\/10\/SCHNEIDER-IT-MANAGEMENT-2025-03-11-Graphics-Office-People-8529-2048x1365.jpg 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\">Please <a href=\"https:\/\/www.schneider.im\/contact\/\">contact us<\/a> for <strong>expert services<\/strong> on your specific Microsoft software and online services requirements and to <strong>request a quote today<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On\u202fNovember 15, 2025, Microsoft announced the\u202fgeneral availability\u202fof SQL Server 2025. This release introduces built-in artificial intelligence (AI), enhanced developer tools, and improvements in performance, security, and cloud integration. &nbsp; What is SQL Server 2025? SQL Server 2025 is Microsoft\u2019s latest enterprise-grade relational database management system (RDBMS). It supports deployment across on-premises, cloud, and hybrid environments. [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":33016,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[147],"tags":[],"class_list":["post-70301","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-sql-server"],"_links":{"self":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts\/70301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/comments?post=70301"}],"version-history":[{"count":8,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts\/70301\/revisions"}],"predecessor-version":[{"id":71664,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts\/70301\/revisions\/71664"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/media\/33016"}],"wp:attachment":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/media?parent=70301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/categories?post=70301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/tags?post=70301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}