SQL Server 2025 출시 (AI 기능에 중점을 둔 업데이트)

📤 정보 공유
1

SQL Server 2025가 이번 Ignite 2025를 기점으로 정식 출시되었습니다. 현재 Microsoft Container Registry에도 컨테이너 이미지가 게시된 상태입니다.

여러 기능이 있지만, 가장 눈여겨 볼 부분은 SQL Server 2025도 이제 벡터 타입의 데이터를 저장하거나 쿼리할 수 있기 때문에 Embedding 모델을 활용한 RAG 구현이 가능하다는 점이 되겠습니다. Express Edition을 다운로드하여 충분히 기능을 테스트해보신다면 좋을 것 같습니다.

AI built-in

SQL Server 2025 comes with everything you need to support vector searching including:

  • A new vector data type

  • Flexible model definitions to support embedding models running on-premises or in the cloud, isolated from the SQL Server engine

  • T-SQL functions to support text chunking and embedding generation

  • A vector index based on DiskANN technology

  • T-SQL functions to support precise vector lookups (VECTOR_DISTANCE) and approximate search (VECTOR_SEARCH)

To take your skills further, Today we are announcing a new SQL AI Certification coming in Spring 2026. Learn more at https://aka.ms/learnsqlai.

We love our partners so check out how NVIDIA built an AI architecture with SQL Server 2025 using their NIM containers at https://aka.ms/sqlserver2025/NVIDIA.

Built for Developers

SQL Server 2025 bring the most significant features for developers in a decade. This includes:

  • A new JSON data type, and index, allowing up to 2GB per row.

  • A set of T-SQL enhancements including a set of T-SQL functions for Regular Expression (RegEx) pattern matching.

  • Change Event Streaming (CES) as a new way to build event driven applications based on transaction log changes.

  • REST API using T-SQL built into the SQL Server engine allows you to build new service oriented applications integrated with your data. SQL Developers can learn an entire new skill of AI development with this new feature.

Combine this with Data API Builder (DAB) (https://aka.ms/dab) to start developing new database AI powered applications.

Mission Critical

Did you know there are over 40+ new engine features in SQL Server 2025 across security, performance, and availability?

  • Break free from lock escalation with optimized locking.

  • Manage uncontrolled tempdb growth with tempdb resource governance.

  • Make your Always On Availability Group more resilient and performant just by upgrading.

  • Try our new ZSTD backup compression

  • Enable query store for read replicas and open up a new world of monitoring across all your replicas. Then see how persistent stats for replicas can accelerate read query performance.

Check out how MSC sees how SQL Server 2025 will transforms their use of SQL Server in key aspects of their business, How MSC Uses Microsoft SQL Server 2025 to Power Global Trade.

Azure and Fabric Integrated

Azure Arc continues to provide great value to customers connected to Azure, whether that be on-premises or in other clouds. SQL Server 2025 includes Managed Identity authentication both inbound and outbound via Arc and Microsoft Entra.

SQL Server 2025 also provides near-real time analytics seamlessly through Mirroring in Fabric unleashing the power of OneLake for all your data integration needs

Tools

SQL Server 2025 is well integrated with the new SQL Server Management Studio 22 (https://aka.ms/ssms) and with VSCode (https://aka.ms/vscode-mssql) including a new local container experience, both with GitHub Copilot experiences. And did you know we have a new Python driver for SQL Server? (aka.ms/mssql-python).

SQL Server 2025 comes in all the editions you are familiar with including Developer, Express, Standard, and Enterprise. But we have made some enhancements I think you will love with no pricing changes:

  • SQL Server Express now has a maximum database size of 50GB. Many of the new features, including AI, are supported in SQL Server Express.

  • SQL Server Standard Edition now supports 32 cores and 256GB RAM. In addition, Resource Governor, including the new tempdb resource governance, is now available in Standard Edition.

  • Developers can now develop and test for free with Standard Edition features and limits using the new Standard Developer Edition.

Start Learning Today

We have so many resources for you to learn more including: