What's New in SQL Server 2024

The preview release of SQL Server 2024 brings a wealth of new features and enhancements designed to boost performance, security, and developer productivity. This release focuses on cloud-native integration, advanced AI capabilities, and streamlined data processing.

Key Themes and Highlights

  • Intelligent Performance: Leverage AI-driven query optimization and adaptive caching for unparalleled speed.
  • Enhanced Security: Benefit from expanded confidential computing options and advanced threat protection.
  • Cloud Integration: Seamless connectivity and hybrid deployment capabilities with Azure.
  • Developer Experience: Improved tooling, T-SQL advancements, and extended language support.
  • Scalability & Reliability: Robust features for handling massive datasets and ensuring high availability.

Featured Innovations

AI-Powered Query Store Insights

Gain deeper understanding of query performance with intelligent suggestions and automatic remediation for performance bottlenecks.

Built-in Vector Search

Enable powerful AI and machine learning workloads directly within SQL Server with native vector database capabilities.

Enhanced Data Virtualization

Connect to and query data across various sources (including cloud storage) with improved performance and management.

Zero-Downtime Patching

Experience true high availability with innovative patching mechanisms that minimize or eliminate application downtime.

Getting Started with the Preview

The preview release is available for download and evaluation. We encourage developers and database administrators to explore the new features, provide feedback, and prepare for the production release.

Download the Preview Provide Feedback

Learn More

Dive deeper into the technical details, read case studies, and access comprehensive documentation: