{"id":111065,"date":"2026-05-28T14:46:48","date_gmt":"2026-05-28T14:46:48","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&#038;p=111065"},"modified":"2026-05-28T15:52:53","modified_gmt":"2026-05-28T15:52:53","slug":"ai-text-embeddings-in-sql-server-everything-you-need-to-know","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/ai-text-embeddings-in-sql-server-everything-you-need-to-know\/","title":{"rendered":"AI text embeddings in SQL Server: everything you need to know"},"content":{"rendered":"\n<p><strong>Complete guide to AI text embeddings in SQL Server, featuring everything you need to know &#8211; with tips, advice and examples.<\/strong> <strong>Plus: how to install and use Ollama with SQL Server.<\/strong><\/p>\n\n\n\n<section id=\"articles-list-block_3c87350a75cc3a51d290764ffa3aa157\" class=\"articles-list my-5xl\">\n    <div class=\"grid gap-3xl\">\n        <div class=\"@container\">\n    <article class=\"flex gap-2xl items-center flex-col @md:flex-row-reverse\">\n        <div class=\"w-full @md:w-1\/3 flex items-center justify-center peer\">\n            <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/how-to-host-an-ai-text-embeddings-model-for-sql-server-using-ollama\/\" aria-label=\"How to host an AI text embeddings model for SQL Server using Ollama\" class=\"no-underline relative aspect-3\/2 bg-gray-100 border border-gray-100 dark:border-gray-800 flex items-center justify-center flex-col gap-md w-full p-md\">\n\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/05\/shutterstock_2694390327-1024x683.jpg\" class=\"object-cover absolute inset-0 w-full h-full wp-post-image\" alt=\"\" srcset=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/05\/shutterstock_2694390327-1024x683.jpg 1024w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/05\/shutterstock_2694390327-300x200.jpg 300w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/05\/shutterstock_2694390327-768x512.jpg 768w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/05\/shutterstock_2694390327-1536x1024.jpg 1536w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/05\/shutterstock_2694390327-2048x1365.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t<\/a>        <\/div>\n        <div class=\"w-full @md:w-2\/3 overflow-auto group\/content-text\">\n            \n<div class=\"block mb-md align-middle\">\n            \n        <a\n        href=\"https:\/\/www.red-gate.com\/simple-talk\/author\/drgreglow\/\"\n        class=\"group\/author inline align-middle no-style min-w-fit\"\n        rel=\"author\"\n    >\n        <img decoding=\"async\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2025\/11\/GregLowProfileImage-150x150.png\"\n            alt=\"Image of author: Greg Low\" \n            class=\"rounded-full align-middle w-6 h-6 duration-200 inline-block object-cover\"\/>\n        <span class=\"group-hover\/author:text-brand-600 peer\/ftr-image:text-brand-600 group-hover\/author:dark:text-brand-400 peer\/ftr-image:dark:text-brand-400 group-hover\/author:underline min-w-fit align-middle duration-200\">Greg Low<\/span>\n    <\/a>\n\n        <span class=\"card__categories align-middle\">\n                                                        <span class=\"text-gray-600 align-middle dark:text-gray-400\">in<\/span>\n                    <a\n                    class=\"inline align-middle no-underline hover:text-brand-600 hover:dark:text-brand-400 hover:underline\"\n                    href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/\">\n                            SQL Server                    <\/a>\n                                        <\/span>\n<\/div>\n<a class=\"no-underline group\/content-text-lower\" href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/how-to-host-an-ai-text-embeddings-model-for-sql-server-using-ollama\/ \">\n    <div>\n        <h1 class=\"\n            duration-200 mt-0 mb-1 text-xl\n            \n            peer-hover:group-[]\/content-text:text-brand-600\n            group-hover\/content-text-lower:text-brand-600\n\n            peer-hover:group-[]\/content-text:dark:text-brand-400\n            group-hover\/content-text-lower:dark:text-brand-400\n            \n            peer-hover:group-[]\/content-text:underline\n            group-hover\/content-text-lower:underline\n            \n        \">\n            How to host an AI text embeddings model for SQL Server using Ollama        <\/h1>\n                    <p class=\"mb-0\">\n                Learn how to install Ollama locally to generate text embeddings for SQL Server vector search, plus configure a Caddy proxy&#8230;            <\/p>\n            <\/div>\n            <div class=\"flex items-center gap-1 mt-md\">\n            <time>01 June 2026<\/time>\n            <span class=\"w-1 h-1 bg-current\tinline-block my-auto rounded-full\"><\/span>\n            <span>5 min read<\/span>\n                    <\/div>\n    <\/a>        <\/div>\n    <\/article>\n<\/div>\n\n\n            <\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Complete guide to AI text embeddings in SQL Server, featuring everything you need to know &#8211; with tips, advice and examples. Plus: how to install and use Ollama with SQL Server.&hellip;<\/p>\n","protected":false},"author":346483,"featured_media":0,"template":"","tags":[159075,159401,159400,4150,4151],"coauthors":[159368],"class_list":["post-111065","collection","type-collection","status-publish","hentry","tag-ai","tag-greglowollamaseries","tag-ollama","tag-sql","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/collection\/111065","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/collection"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/collection"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/346483"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=111065"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=111065"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=111065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}