{"id":5314,"date":"2025-12-16T10:46:49","date_gmt":"2025-12-16T18:46:49","guid":{"rendered":"https:\/\/www.sqlskills.com\/blogs\/paul\/?p=5314"},"modified":"2026-02-12T11:34:21","modified_gmt":"2026-02-12T19:34:21","slug":"new-course-sql-server-2025-vector-search-essentials","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/","title":{"rendered":"New course: SQL Server Vector Search Essentials"},"content":{"rendered":"<p>(TL;DR: Video trailer for the course is <a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/aivse\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.)<\/p>\n<p style=\"text-align: justify;\">We&#8217;re tremendously excited to be developing a library of AI-focused courses, as well as new courses focused on traditional SQL Server topics, all based on SQL Server 2025 and Azure SQL Database. Joe Sack is back with us and he gets the honors for our first new course: AIVSE: Vector Search Essentials.<\/p>\n<p style=\"text-align: left;\"><a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/aivse\/\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-5315 size-medium\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg-300x300.webp\" alt=\"\" width=\"300\" height=\"300\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg-300x300.webp 300w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg-150x150.webp 150w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg.webp 600w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">This course prepares SQL Server DBAs and developers for AI-powered semantic search. You&#8217;ll learn how to store, index, and query vector embeddings directly in SQL Server 2025, enabling natural language search, recommendation systems, and retrieval-augmented generation (RAG) patterns.<\/p>\n<p style=\"text-align: justify;\">The hands-on lab database and all demo scripts are available on GitHub. Whether you&#8217;re running SQL Server locally, on a VM, or in Azure, the core concepts and query patterns you&#8217;ll learn apply across all deployment options.<\/p>\n<p style=\"text-align: left;\">You&#8217;ll learn the following:<\/p>\n<ul>\n<li>Semantic search fundamentals and when vector search outperforms traditional full-text<\/li>\n<li>Vector data types, embeddings, and how to generate them from text<\/li>\n<li>Distance metrics (cosine, Euclidean, dot product) and when to use each<\/li>\n<li>Approximate nearest neighbor (ANN) search with DiskANN indexes<\/li>\n<li>Hybrid query patterns combining vector similarity with traditional filters<\/li>\n<li>Production deployment strategies including performance tuning and monitoring<\/li>\n<\/ul>\n<p>More information about the course is <a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/aivse\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">It&#8217;s available for one-year and lifetime access and is on sale through the end of the year in our revamped <a href=\"https:\/\/www.sqlskills.com\/shop\/\" target=\"_blank\" rel=\"noopener\">shop<\/a>. If you&#8217;re a Blackbelt Lifetime subscriber, login and use the discount code &#8216;bbai&#8217; to save $100 on the sale price (it automatically checks your account email), otherwise, check the newsletter Wednesday morning for a $50 discount coupon.<\/p>\n<p>Any questions, <a href=\"mailto:paul@sqlskills.com?subject=AIVSE question from blog\">let me know<\/a>.<\/p>\n<p>Enjoy!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>(TL;DR: Video trailer for the course is here.) We&#8217;re tremendously excited to be developing a library of AI-focused courses, as well as new courses focused on traditional SQL Server topics, all based on SQL Server 2025 and Azure SQL Database. Joe Sack is back with us and he gets the honors for our first new [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[126,24,125,97],"tags":[],"class_list":["post-5314","post","type-post","status-publish","format-standard","hentry","category-ai","category-classes","category-sql-server-2025","category-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New course: SQL Server Vector Search Essentials - Paul S. Randal<\/title>\n<meta name=\"description\" content=\"Learn the essentials of vector search in SQL Server 2025 and Azure SQL Database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New course: SQL Server Vector Search Essentials - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Learn the essentials of vector search in SQL Server 2025 and Azure SQL Database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-16T18:46:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-12T19:34:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/\",\"name\":\"New course: SQL Server Vector Search Essentials - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg-300x300.webp\",\"datePublished\":\"2025-12-16T18:46:49+00:00\",\"dateModified\":\"2026-02-12T19:34:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"description\":\"Learn the essentials of vector search in SQL Server 2025 and Azure SQL Database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg.webp\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg.webp\",\"width\":600,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New course: SQL Server Vector Search Essentials\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New course: SQL Server Vector Search Essentials - Paul S. Randal","description":"Learn the essentials of vector search in SQL Server 2025 and Azure SQL Database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/","og_locale":"en_US","og_type":"article","og_title":"New course: SQL Server Vector Search Essentials - Paul S. Randal","og_description":"Learn the essentials of vector search in SQL Server 2025 and Azure SQL Database.","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/","og_site_name":"Paul S. Randal","article_published_time":"2025-12-16T18:46:49+00:00","article_modified_time":"2026-02-12T19:34:21+00:00","og_image":[{"width":600,"height":600,"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg.webp","type":"image\/webp"}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/","name":"New course: SQL Server Vector Search Essentials - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg-300x300.webp","datePublished":"2025-12-16T18:46:49+00:00","dateModified":"2026-02-12T19:34:21+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"description":"Learn the essentials of vector search in SQL Server 2025 and Azure SQL Database.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg.webp","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2025\/12\/aivse-sqlserver2025-1star.jpg.webp","width":600,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-course-sql-server-2025-vector-search-essentials\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"New course: SQL Server Vector Search Essentials"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/5314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=5314"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/5314\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=5314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=5314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=5314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}