Today, Microsoft introduced the preview of SQL Server 2025, the successor to the preferred SQL Server 2022, which was once launched in 2022. With SQL Server 2025, Microsoft is concentrated on AI apps each on-premises and within the cloud.

SQL Server 2025 comes with progressed safety and function. It will improve Microsoft Entra-managed identities for progressed credential control and extra. Microsoft has made enhancements to clever question optimization and question efficiency execution to fortify workload efficiency and scale back troubleshooting. To build up uptime and fortify concurrency and scale for SQL Server apps, Microsoft has progressed failover reliability and optimized locking as smartly.

Microsoft could also be turning in extra seamless Azure integration with SQL Server 2025. The new Microsoft Fabric database mirroring will permit shoppers to arrange real-time analytics via replicating SQL Server knowledge to Microsoft OneLake. Also, they may be able to attach SQL Server 2025 with Azure Arc to control a hybrid SQL Server knowledge property at scale. Microsoft could also be providing pay-as-you-go licensing for on-premises shoppers.

For the primary time, Microsoft is bringing local vector improve to SQL Server. SQL Server 2025 will likely be an enterprise-ready vector database that may generate and natively retailer vector embeddings. This local vector improve will permit SQL Server shoppers to run generative AI fashions the usage of their very own knowledge. They can select the desired AI fashion with the extensible fashion control enabled via Azure Arc.

Finally, Microsoft is bringing Copilot to SQL Server Management Studio (SSMS). Copilot in SSMS will be offering real-time ideas, code completions, and easiest follow suggestions for database admins and builders.

Microsoft’s upcoming SQL Server 2025 is now in personal preview. Customers can be expecting a public preview within the coming months prior to normal availability.