Session Abstract

SQL Server 2025 and Azure SQL Databases introduce a major shift in how databases participate in modern, AI-driven architectures. With native support for vector data, embeddings, REST integration, and powerful new T-SQL capabilities, the database is no longer just a storage engine but becomes an active component in intelligent applications. In this session, we focus on two key innovation areas: AI & intelligent data workloads and developer productivity. We explore how new features such as the vector data type, vector search functions, and direct calls to embedding models enable semantic search and Retrieval-Augmented Generation (RAG) scenarios directly from SQL Server and Azure SQL. We then dive into the expanding T-SQL feature set that significantly improves developer efficiency, including: * Calling REST endpoints from within the database * Using regular expressions for advanced pattern matching * Fuzzy string matching for data quality and deduplication * Enhanced JSON processing for semi-structured data The session will be practical demos only and helps you understand not just what is new, but how and when to use these features effectively in real-world SQL Server and Azure SQL solutions. After this session, you will be able to: * Understand how AI capabilities are natively integrated into SQL Server 2025 and Azure SQL * Implement vector search and embeddings for semantic and AI-assisted workloads * Use new T-SQL features such as REST calls, regex, fuzzy matching, and JSON enhancements * Make informed decisions about adopting these features in on-premises, cloud, or hybrid environments

Christian Peeters

Christian started in 2000 as a software developer. Seven years later he became a Microsoft Certified Trainer and has been teaching other developers ever since. Currently he is a Principal Cloud Architect at Betabit. A software development company specialized in building business critical applications in the cloud.