Summary

  • 2 minutes

This module covered designing and implementing models and embeddings for Azure SQL Database and Fabric SQL database. You learned how to evaluate AI models, create external models to reference AI endpoints from Transact-SQL, and design effective chunking strategies. You also explored approaches for generating and maintaining embeddings as data changes.

After completing this module, you can:

  • Evaluate AI models for SQL database workloads based on capabilities and performance requirements.
  • Create and manage external models to reference AI endpoints from Transact-SQL.
  • Design embeddings with appropriate chunking strategies.
  • Generate and store embeddings using built-in SQL AI functions.
  • Choose maintenance approaches to keep embeddings aligned with source data.

Additional reading