Developer’s Guide to AI in SQL Server 2025 and Azure SQL

Room 11Tue 27 Oct • 11:15–12:15DevIntermediate
AI is rapidly transforming modern applications, and SQL Server 2025 and Azure SQL now make it easier than ever for developers to bring AI directly into their transactional databases. In this session, you’ll learn how to build intelligent applications using native vector search capabilities, DiskANN indexing, and the new external model feature that enables seamless integration with AI models such as Azure OpenAI directly from T-SQL. We’ll begin with a practical introduction to Retrieval Augmented Generation (RAG), text embeddings, vector storage, indexing, and similarity search. From there, we’ll move into live demonstrations showing how SQL Server 2025 and Azure SQL can power real-world AI solutions using your own business data. You’ll see how to generate and store embeddings, perform high-performance semantic searches with VECTOR_SEARCH and DiskANN indexes, and use external AI models to deliver natural language experiences over relational data. Whether you’re modernizing existing applications or building entirely new AI-driven solutions, this session will show you how to leverage the latest SQL platform innovations to accelerate your AI journey.

About the speaker

Leonard Lobel

Leonard Lobel (Microsoft MVP, Data Platform) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a Microsoft consultant at Ernst & Young. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL Bits, and other industry conferences. Lenni has also authored several MS Press books and Pluralsight courses on SQL Server and Azure Cosmos DB programming.