SQL with Manoj

 
On 19th November 2024 Microsoft announced the Private Preview of SQL Server upcoming version i.e. SQL Server 2025 !!!

This v-Next version emphasizes modern AI and Generative AI (GenAI) capabilities powered by Microsoft Copilot and contemporary Large Language Models (LLMs). These capabilities align with the latest advancements in GenAI, such as OpenAI’s ChatGPT, Meta’s Llama, etc. It also integrates Semantic Kernel, LangChain, and Retrieval-Augmented Generation (RAG) functionalities, positioning it as an enterprise-ready AI database !!!

 
>> Built-in AI:

– SQL Server 2025 will be having Vector Database capabilities
    — New native Vector datatype
    — Vector search capabilities by using new vector functions VECTOR_DISTANCE() for calculating euclidean, cosine, and negative dot distance between two vectors.
    — Vector index powered by DiskANN (Disk based Approximate Nearest Neighbor)
    — I will be posting more about this topic in my upcoming blogs…

– Can call REST APIs with sp_invoke_external_rest_endpoint system Stored Procedure for calling LLMs

– Semanic Kernel integration, for semantic search capabilities for more intuitive data retrieval and analysis

– LangChain integration, by enabling seamless interaction between natural language queries and structured database operations

 
>> Fabric Mirroring:
– Mirroring replicates databases to Fabric with zero ETL
– Data is replicated into One Lake and kept up-to-date in near real-time
– Mirroring protects operational databases from analytical queries
– Compute replication is included with your Fabric capacity for no cost.
– Free Mirroring Storage for Replicas tiered to Fabric Capacity.

 
>> Other Database engine new features:
– Native JSON datatype, index, and functions
– Regular Expression (Regex) support, with new functions used at CHECK constraint, WHERE clause, SELECT list
– Copilot/GenAI in SSMS (Ver 21) for SQL query/code completions and recommendations
– Enhancements in Performance and Scalability
– Optimized locking for reducing memory lock consumption and minimizing concurrent transactions blocking through Transaction ID (TID) Locking and Lock After Qualification (LAQ)
– Real time event streaming to Azure Event Hubs and Kafka, by capturing and publishing incremental changes to data and schema

 
>> SQL Server setup – Feature selection:

 
Signup for the SQL Server 2025 Private Preview program here: https://aka.ms/sqleapsignup
 

>> References:

– https://www.microsoft.com/en-us/sql-server/blog/2024/11/19/announcing-microsoft-sql-server-2025-apply-for-the-preview-for-the-enterprise-ai-ready-database/
– https://www.linkedin.com/pulse/announcing-sql-server-2025-bob-ward-6s0hc/
– https://ignite.microsoft.com/en-US/sessions/BRK195