Performance, blocking and CI/CD for SQL AI

DP-800 · Secure, optimize and maintain SQL AI solutions · Updated

Diagnose blocking with DMVs, use Query Store and automatic tuning, and deploy SQL projects idempotently through CI/CD pipelines.

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
  • Finding blocking
  • Query Store and tuning
  • Indexes and statistics
  • CI/CD for databases
  • Tooling
  • 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