REST APIs, Vectors, and AI in SQL Server 2025
56mIntermediate2025-10-27
Authors
Ben Weissman
Course details
This course explores the new AI-driven and developer-centric capabilities in SQL Server 2025, focusing on REST API integration, vector search, and working with large language models (LLMs). Learn how to set up and configure SQL Server to support these features, securely connect to external APIs, and bring conversational AI into your T-SQL workflows. The course covers key concepts like embeddings, vector similarity, and indexing for efficient semantic search. Through hands-on examples, you can gain the skills to build intelligent, modern applications directly within SQL Server. By the end of this course, you should be able to design, implement, and optimize AI-enhanced solutions using the latest features in SQL Server 2025.
Learning objectives
Deploy and configure SQL Server 2025 to support REST APIs, vectors, and AI features.
Securely connect to and consume external REST APIs using T-SQL.
Integrate large language models into SQL workflows for conversational and intelligent query scenarios.
Evaluate architectural considerations for scaling and optimizing AI and API-driven workloads in SQL Server 2025.
Learning objectives
Deploy and configure SQL Server 2025 to support REST APIs, vectors, and AI features.
Securely connect to and consume external REST APIs using T-SQL.
Integrate large language models into SQL workflows for conversational and intelligent query scenarios.
Evaluate architectural considerations for scaling and optimizing AI and API-driven workloads in SQL Server 2025.
Skills covered
SQL ServerCloud StorageAPIsDatabase AdministrationFull-Stack Web DevelopmentDatabase DevelopmentDatabase ManagementData AnalysisWeb DevelopmentProgramming LanguagesCloud ComputingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftSoftware DevelopmentOne-Off
Concepts
Introduction
- REST APIs, vectors, and AI in SQL server 2025
- Course setup and version disclaimer
Why SQL Server 2025 for Intelligent Data Solutions
- What s New - AI Capabilities in SQL Server 2025
- Scenarios for REST APIs, vectors, and LLMs in modern applications
- Demo - Environment overview including deployment options
- Demo - Deploying on bare-metal Windows
- Architectural considerations for more advanced use-cases
Connecting SQL Server to External REST APIs
- What is a REST API
- Secure API Consumption via T-SQL in SQL Server 2025
- Best practices for performance, rate limiting, and retry logic
- Demo - Ingesting data and controlling workflows via REST APIs
Artificial Intelligence in SQL Server 2025
- large language models in a nutshell
- What LLMs can do with SQL - Conversational and generative use cases
- Understanding embeddings and vector storage
- Demo - Distance-based search
- Scaling and optimizing vector workloads through vector indexes
- Demo - Vector indexes
Building and Optimizing AI-Powered SQL Solutions
- Testing, logging, scaling, and monitoring AI workloads in SQL server
- Demo - Full Workflow - From API ingestion to vector search to LLM output
Conclusion
- Conclusion