Get AI-Ready With Erik: Creating External Models

## Summary
In this video, I delve into creating and using external models to generate embeddings directly within SQL Server 2025, Azure SQL Database, and Azure Managed Instance. While there's minimal coverage in the full course "Get AI Ready with Erik," which you can access using a special coupon code found in the video description, I provide deeper insights on how to integrate Python scripts for more efficient embedding generation outside of SQL Server. However, leveraging native SQL Server capabilities is incredibly convenient, especially when setting up your environment properly. I cover essential steps like enabling the External REST Endpoint and creating an external model using OLAMA or another provider. By walking through these processes, you can generate embeddings directly in T-SQL, which integrates seamlessly with transactions and triggers, making deployment simpler and more integrated than external methods.

## Topics
`SQL Server 2025`, `Azure SQL Database`, `Azure Managed Instance`, `External Models`, `Embeddings`, `AI Generate Embeddings Function`, `Python Scripts`, `OLAMA`, `HTTP Requests`, `HTTPS`, `SP Configure Setting`, `External REST Endpoint`, `T-SQL`, `Triggers`, `Store Procedures`, `Transactions`, `Vector Data Type`, `Float32`, `Machine Learning`, `AI Integration`, `Cloud Code`

## Chapters
- **00:00:00** - Introduction
- **00:01:27** - External Models in SQL Server 2025
- **00:03:06** - Benefits of Internal AI Embeddings
- **00:04:22** - SP Configure Setting Overview
- **00:05:37** - Creating an External Model
- **00:08:17** - Generating Embeddings with T-SQL

━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY

SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING

Learn T-SQL with Erik
https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL

Everything Bundle:
https://training.erikdarling.com/?coupon=SPRINGCLEANING

━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━

Need SQL Server performance help?
https://training.erikdarling.com/sqlconsulting

━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━

Ask questions at Office Hours
https://erikdarling.com/officehours/

Become a channel member
https://www.youtube.com/@ErikDarlingData/join

Видео Get AI-Ready With Erik: Creating External Models канала Erik Darling (Erik Darling Data)