When SQL Server 2025 was announced, Bob Ward mentioned that there would be some new commands for managing AI models and their definitions, as well as T-SQL functions to generate embeddings, etc. I even made a guess that the command might be CREATE AI MODEL…
Now that SQL Server 2025 has finally been released to the public, I was finally able to test and learn a lot about this command (named CREATE EXTERNAL MODEL), and I want to share my knowledge with you here. If you’re new to the world of AI, don’t worry, we’ll start with the basics and