Generating embeddings with external models

DP-800 · Develop with SQL and AI features · Updated

Create an EXTERNAL MODEL, call AI_GENERATE_EMBEDDINGS, chunk text and control who may run it, in Azure SQL and SQL Server 2025.

This lesson is part of full DP-800 access

The first 2 DP-800 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-800 question bank.

In this lesson
  • External models
  • AI_GENERATE_EMBEDDINGS
  • Chunking
  • Calling other REST services
  • Permissions and cost
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-800 course outline

All 7 lessons · Course overview
  1. The vector data type and similarity searchDesign SQL database solutions for AI Free
  2. Design choices - JSON, graph tables and partitioningDesign SQL database solutions for AI Free
  3. Generating embeddings with external modelsDevelop with SQL and AI features Full access
  4. Keeping embeddings in sync with change trackingDevelop with SQL and AI features Full access
  5. Hybrid search and RAG over SQL dataDevelop with SQL and AI features Full access
  6. Securing SQL AI solutionsSecure, optimize and maintain SQL AI solutions Full access
  7. Performance, blocking and CI/CD for SQL AISecure, optimize and maintain SQL AI solutions Full access