{"id":39981,"date":"2025-08-05T17:23:04","date_gmt":"2025-08-05T15:23:04","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=39981"},"modified":"2025-08-13T14:34:10","modified_gmt":"2025-08-13T12:34:10","slug":"lift-your-application-in-the-age-of-ai-with-sql-server-2025","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/","title":{"rendered":"SQL Server 2025: Where Data Meets Intelligence"},"content":{"rendered":"\n<p>The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next phase of this evolution with context-aware AI assistants and autonomous AI agents that will have even more impact.<\/p>\n\n\n\n<p>Providers of modern and future-oriented platforms and applications seem to be aware of this development and are integrating AI in a targeted manner to increase efficiency and improve the user experience.<\/p>\n\n\n\n<p>With SQL Server 2025 being the most developer-oriented release in over a decade, Microsoft is clearly targeting the AI evolution making it easier than ever to integrate AI with your data.<\/p>\n\n\n\n<p>In this article I will introduce you in two of the latest AI oriented features which are now available in SQL-Server 2025 preview and I will show you an example how you can interact with an external AI-model programmatically.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-sp-invoke-external-rest-endpoint\">sp_invoke_external_rest_endpoint:<\/h1>\n\n\n\n<p>While the stored procedure sp_invoke_external_rest_endpoint was already available in Azure SQL Database and Managed Instance it\u2019s now also available in &nbsp;SQL-Server 2025 Preview and allows you to communicate with external REST services from On-Premise.<\/p>\n\n\n\n<p>This is significant in terms of AI because AI-models which are hosted on Cloud Platforms or on Premise (for example with Ollama) are usually REST compatible. This stored procedure allows you so to interact with an external AI model directly and programmatically through T-SQL.<\/p>\n\n\n\n<p>You can find more information about the stored procedure and the specific parameters on the following Link from Microsoft: <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-stored-procedures\/sp-invoke-external-rest-endpoint-transact-sql?view=sql-server-ver17&amp;tabs=request-headers\">https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-stored-procedures\/sp-invoke-external-rest-endpoint-transact-sql?view=sql-server-ver17&amp;tabs=request-headers<\/a><\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-json-datatype\">JSON Datatype:<\/h1>\n\n\n\n<p>In the previous version of SQL-Server JSON Data was stored in the varchar and nvarchar datatypes. With SQL-Server 2025 you can now store JSON data in a JSON datatype. The JSON datatype which is also available in Azure SQL Database and Azure SQL Managed Instance brings multiple advantages over working with JSON Data in nvarchar and varchar datatypes.<\/p>\n\n\n\n<p>As the new JSON Datatype is compatible with all JSON functions no code change is necessary while benefiting from the following advantages:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>reads are faster because with the JSON datatype your JSON data is already parsed<\/li>\n\n\n\n<li>you can update also individual values without accessing the whole JSON data<\/li>\n\n\n\n<li>the JSON datatype is optimized for compression which makes the storage more efficient<\/li>\n<\/ul>\n\n\n\n<p>In terms of AI this is significant because external AI-models are usually transferring data in the JSON format. With the new JSON datatype you can handle this data efficiently.<\/p>\n\n\n\n<p>To get more detailed information\u2019s about handling JSON data with T-SQL and about the new JSON datatype, you can access the following Link from Microsoft: <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/json\/json-data-sql-server?view=sql-server-ver17\">https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/json\/json-data-sql-server?view=sql-server-ver17<\/a><\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-hands-on-generating-product-descriptions-using-ai\">Hands On &#8211; Generating Product Descriptions using AI:<\/h1>\n\n\n\n<p>Enough theory for now! let\u2019s get practical. For demonstration purposes, I\u2019ve prepared a sample shop database for a clothing reseller running on SQL-Server 2025.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"757\" height=\"495\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png\" alt=\"\" class=\"wp-image-40024\" style=\"width:446px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png 757w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1-300x196.png 300w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><\/figure>\n\n\n\n<p>The database has some few tables which are containing product information\u2019s:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"456\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/18-1.png\" alt=\"\" class=\"wp-image-40053\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/18-1.png 479w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/18-1-300x286.png 300w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><\/figure>\n\n\n\n<p>With the following query you can see that we have 3000 products with different categories from different brands etc.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect p.product_id, p.product_name, p.currency, p.price, c.category_name, b.brand_name, co.color_name, g.gender, s.season \nfrom dbo.products p \ninner join dbo.category c on p.category_id = c.category_id \ninner join dbo.brand b on p.brand_id = b.brand_id \ninner join dbo.color co on p.color_id = co.color_id \ninner join dbo.gender g on p.gender_id = g.gender_id\ninner join dbo.season s on p.season_id = s.season_id\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"633\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/3.png\" alt=\"\" class=\"wp-image-40028\" style=\"width:552px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/3.png 827w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/3-300x230.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/3-768x588.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/figure>\n\n\n\n<p>What we don\u2019t have is a product description for attracting potential buyers. This is something we will do now using AI. Therefore I need an AI model which I can integrate with my product data. I deploy this model in Azure.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-deploy-an-ai-model-in-azure\">Deploy an AI Model in Azure:<\/h2>\n\n\n\n<p>In the Azure Portal I\u2019m looking therefore for Azure AI Foundry.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"457\" height=\"517\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/4.png\" alt=\"\" class=\"wp-image-40031\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/4.png 457w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/4-265x300.png 265w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><\/figure>\n\n\n\n<p>Then under AI Foundry I create a new resource of Azure OpenAI:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"917\" height=\"343\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/5.png\" alt=\"\" class=\"wp-image-40032\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/5.png 917w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/5-300x112.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/5-768x287.png 768w\" sizes=\"auto, (max-width: 917px) 100vw, 917px\" \/><\/figure>\n\n\n\n<p>The deployment is pretty much straight forward and after the deployment is finished I access my newly created resource:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"920\" height=\"337\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/6.png\" alt=\"\" class=\"wp-image-40033\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/6.png 920w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/6-300x110.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/6-768x281.png 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><\/figure>\n\n\n\n<p>In my new Azure OpenAI resource I\u2019m accessing now the Azure AI Foundry portal for deploying a new AI-model:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1148\" height=\"352\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/7.png\" alt=\"\" class=\"wp-image-40034\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/7.png 1148w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/7-300x92.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/7-1024x314.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/7-768x235.png 768w\" sizes=\"auto, (max-width: 1148px) 100vw, 1148px\" \/><\/figure>\n\n\n\n<p>In the AI Foundry Portal I\u2019m looking under the Model catalog for chat completion models and I select the gpt-4o model which is the \u201callrounder\u201d AI-model for chat completion tasks from OpenAI(It\u2019s in fact currently the model you are using with ChatGPT by default if you don\u2019t choose anything else specifically):<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1271\" height=\"332\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/8.png\" alt=\"\" class=\"wp-image-40035\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/8.png 1271w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/8-300x78.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/8-1024x267.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/8-768x201.png 768w\" sizes=\"auto, (max-width: 1271px) 100vw, 1271px\" \/><\/figure>\n\n\n\n<p>After clicking on the gpt-4o model, I clik on \u201cUse this model\u201d and finally on \u201cdeploy\u201d for deploying the model:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1146\" height=\"356\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/9.png\" alt=\"\" class=\"wp-image-40036\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/9.png 1146w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/9-300x93.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/9-1024x318.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/9-768x239.png 768w\" sizes=\"auto, (max-width: 1146px) 100vw, 1146px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"721\" height=\"702\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/10.png\" alt=\"\" class=\"wp-image-40037\" style=\"width:402px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/10.png 721w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/10-300x292.png 300w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><\/figure>\n\n\n\n<p>As far as I deployed the model successfully I\u2019m able to find it in the Azure AI Foundry Portal under \u201cDeployments\u201d:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1070\" height=\"371\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/11.png\" alt=\"\" class=\"wp-image-40038\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/11.png 1070w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/11-300x104.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/11-1024x355.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/11-768x266.png 768w\" sizes=\"auto, (max-width: 1070px) 100vw, 1070px\" \/><\/figure>\n\n\n\n<p>After clicking on the newly deployed model I can also find my https URL and API key for accessing the model:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1068\" height=\"557\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/12.png\" alt=\"\" class=\"wp-image-40039\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/12.png 1068w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/12-300x156.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/12-1024x534.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/12-768x401.png 768w\" sizes=\"auto, (max-width: 1068px) 100vw, 1068px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-interacting-with-the-ai-model-using-t-sql\">Interacting with the AI Model using T-SQL:<\/h2>\n\n\n\n<p>As the model is now successfully deployed we are ready to interact with it using T-SQL. Therefore I wrote a small stored procedure around the stored procedure sp_invoke_external_rest_endpoint which is doing the following stuff:<\/p>\n\n\n\n<p>It takes the Product ID, API Key, API Endpoint URL and the desired description language as input parameters:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"733\" height=\"317\" src=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/13.png\" alt=\"\" class=\"wp-image-40042\" style=\"width:559px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/13.png 733w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/13-300x130.png 300w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/figure>\n\n\n\n<p>It selects necessary product data for the provided Product ID from the database and stores it as a single string:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1177\" height=\"260\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/14.png\" alt=\"\" class=\"wp-image-40043\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/14.png 1177w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/14-300x66.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/14-1024x226.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/14-768x170.png 768w\" sizes=\"auto, (max-width: 1177px) 100vw, 1177px\" \/><\/figure>\n\n\n\n<p>It generates a prompt for the chat completion API and dynamically interpolates the selected product data into that prompt:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1758\" height=\"461\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/AI_prompt.png\" alt=\"\" class=\"wp-image-40015\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/AI_prompt.png 1758w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/AI_prompt-300x79.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/AI_prompt-1024x269.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/AI_prompt-768x201.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/AI_prompt-1536x403.png 1536w\" sizes=\"auto, (max-width: 1758px) 100vw, 1758px\" \/><\/figure>\n\n\n\n<p>Finally it invokes the external AI model using the stored procedure sp_invoke_external_rest_endpoint with the generated prompt:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1075\" height=\"431\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/15.png\" alt=\"\" class=\"wp-image-40044\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/15.png 1075w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/15-300x120.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/15-1024x411.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/15-768x308.png 768w\" sizes=\"auto, (max-width: 1075px) 100vw, 1075px\" \/><\/figure>\n\n\n\n<p>With the code below I\u2019m then executing the stored procedure above for a specific product in my database and I\u2019m extracting the product description from the AI models JSON response:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1072\" height=\"561\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/16.png\" alt=\"\" class=\"wp-image-40045\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/16.png 1072w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/16-300x157.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/16-1024x536.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/16-768x402.png 768w\" sizes=\"auto, (max-width: 1072px) 100vw, 1072px\" \/><\/figure>\n\n\n\n<p>As a random example I have this swim shorts in the color magenta in my Shop database with the product ID 2354:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1072\" height=\"310\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/17.png\" alt=\"\" class=\"wp-image-40046\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/17.png 1072w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/17-300x87.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/17-1024x296.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/17-768x222.png 768w\" sizes=\"auto, (max-width: 1072px) 100vw, 1072px\" \/><\/figure>\n\n\n\n<p>I\u2019m now able to generate a product description using the gpt-4o model hosted in Azure for this specific product:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1297\" height=\"437\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_english.png\" alt=\"\" class=\"wp-image-40018\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_english.png 1297w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_english-300x101.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_english-1024x345.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_english-768x259.png 768w\" sizes=\"auto, (max-width: 1297px) 100vw, 1297px\" \/><\/figure>\n\n\n\n<p>You can see here the full product description which was returned by the gpt-4o model:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Make a bold splash this summer with these vibrant magenta swim shorts from River Island. Designed for the modern man, they combine style and comfort, ensuring you stand out at the beach or poolside. Don&#8217;t just swim\u2014make a statement. Grab yours now and own the summer vibe!<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>The description is pretty good isn&#8217;t it? If magenta suited me, I would definitely buy one \ud83d\ude09<\/p>\n\n\n\n<p>The GPT-4o model is also quite a language expert. For example, you can even generate your product descriptions in Chinese.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1298\" height=\"576\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_chinese.png\" alt=\"\" class=\"wp-image-40020\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_chinese.png 1298w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_chinese-300x133.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_chinese-1024x454.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/Image_AI_response_chinese-768x341.png 768w\" sizes=\"auto, (max-width: 1298px) 100vw, 1298px\" \/><\/figure>\n\n\n\n<p>In case that I have Chinese speaking blog readers or if someone wants to translate it, here is again the full description:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u4eae\u773c\u7684\u7d2b\u7ea2\u8272\u6cf3\u88e4\uff0c\u8ba9\u60a8\u5728\u590f\u65e5\u6d77\u6ee9\u4e0a\u6210\u4e3a\u7126\u70b9\uff01River Island\u7cbe\u5fc3\u8bbe\u8ba1\uff0c\u517c\u5177\u65f6\u5c1a\u4e0e\u8212\u9002\uff0c\u5b8c\u7f8e\u8d34\u5408\u7537\u6027\u8eab\u5f62\u3002\u65e0\u8bba\u662f\u6e38\u6cf3\u8fd8\u662f\u6652\u65e5\u5149\u6d74\uff0c\u8fd9\u6b3e\u6cf3\u88e4\u90fd\u662f\u60a8\u7684\u7406\u60f3\u9009\u62e9\u3002\u7acb\u5373\u4e0b\u5355\uff0c\u5f00\u542f\u60a8\u7684\u590f\u65e5\u9b45\u529b\u4e4b\u65c5\uff01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>If you want to test it by your own you can find the whole code and a backup of the ShopAI database on GitHub: <a href=\"https:\/\/github.com\/HocineMechara\/SQL2025-AI-Product-Description-Blog\">https:\/\/github.com\/HocineMechara\/SQL2025-AI-Product-Description-Blog<\/a><\/p>\n\n\n\n<p>Of course, this is just a simple example. You can do much more. For instance, you could provide additional context to the chat completion model, such as the user&#8217;s recent orders or behavioral data, to generate personalized product descriptions tailored to individual customers.<\/p>\n\n\n\n<p>Feel free to share your thoughts in the comments, and stay tuned for upcoming posts from my colleagues and me. \ud83d\ude09<\/p>\n\n\n\n<p>Thanks for reading,<br>Hocine<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next phase of this evolution with context-aware AI assistants and autonomous AI agents that will have even [&hellip;]<\/p>\n","protected":false},"author":145,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3271,955,368,99],"tags":[2810,1338,652,51],"type_dbi":[],"class_list":["post-39981","post","type-post","status-publish","format-standard","hentry","category-azure","category-cloud","category-development-performance","category-sql-server","tag-ai","tag-azure","tag-data","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2025: Where Data Meets Intelligence - dbi Blog<\/title>\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.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2025: Where Data Meets Intelligence\" \/>\n<meta property=\"og:description\" content=\"The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next phase of this evolution with context-aware AI assistants and autonomous AI agents that will have even [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-05T15:23:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-13T12:34:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"757\" \/>\n\t<meta property=\"og:image:height\" content=\"495\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Hocine Mechara\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hocine Mechara\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/\"},\"author\":{\"name\":\"Hocine Mechara\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/29415d02bc1b50884796a01cf649951f\"},\"headline\":\"SQL Server 2025: Where Data Meets Intelligence\",\"datePublished\":\"2025-08-05T15:23:04+00:00\",\"dateModified\":\"2025-08-13T12:34:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/\"},\"wordCount\":1184,\"commentCount\":2,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/08\\\/1.png\",\"keywords\":[\"ai\",\"Azure\",\"data\",\"SQL Server\"],\"articleSection\":[\"Azure\",\"Cloud\",\"Development &amp; Performance\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/\",\"name\":\"SQL Server 2025: Where Data Meets Intelligence - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/08\\\/1.png\",\"datePublished\":\"2025-08-05T15:23:04+00:00\",\"dateModified\":\"2025-08-13T12:34:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/29415d02bc1b50884796a01cf649951f\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/08\\\/1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/08\\\/1.png\",\"width\":757,\"height\":495},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2025: Where Data Meets Intelligence\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/29415d02bc1b50884796a01cf649951f\",\"name\":\"Hocine Mechara\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f771f838feed0619485da1e42ae05d771dcb446e1f4785244582280315fa73c3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f771f838feed0619485da1e42ae05d771dcb446e1f4785244582280315fa73c3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f771f838feed0619485da1e42ae05d771dcb446e1f4785244582280315fa73c3?s=96&d=mm&r=g\",\"caption\":\"Hocine Mechara\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/hocinemechara\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2025: Where Data Meets Intelligence - dbi Blog","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.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2025: Where Data Meets Intelligence","og_description":"The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next phase of this evolution with context-aware AI assistants and autonomous AI agents that will have even [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/","og_site_name":"dbi Blog","article_published_time":"2025-08-05T15:23:04+00:00","article_modified_time":"2025-08-13T12:34:10+00:00","og_image":[{"width":757,"height":495,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png","type":"image\/png"}],"author":"Hocine Mechara","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hocine Mechara","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/"},"author":{"name":"Hocine Mechara","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/29415d02bc1b50884796a01cf649951f"},"headline":"SQL Server 2025: Where Data Meets Intelligence","datePublished":"2025-08-05T15:23:04+00:00","dateModified":"2025-08-13T12:34:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/"},"wordCount":1184,"commentCount":2,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png","keywords":["ai","Azure","data","SQL Server"],"articleSection":["Azure","Cloud","Development &amp; Performance","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/","url":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/","name":"SQL Server 2025: Where Data Meets Intelligence - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png","datePublished":"2025-08-05T15:23:04+00:00","dateModified":"2025-08-13T12:34:10+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/29415d02bc1b50884796a01cf649951f"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/08\/1.png","width":757,"height":495},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/lift-your-application-in-the-age-of-ai-with-sql-server-2025\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2025: Where Data Meets Intelligence"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/29415d02bc1b50884796a01cf649951f","name":"Hocine Mechara","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f771f838feed0619485da1e42ae05d771dcb446e1f4785244582280315fa73c3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f771f838feed0619485da1e42ae05d771dcb446e1f4785244582280315fa73c3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f771f838feed0619485da1e42ae05d771dcb446e1f4785244582280315fa73c3?s=96&d=mm&r=g","caption":"Hocine Mechara"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/hocinemechara\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/145"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=39981"}],"version-history":[{"count":19,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39981\/revisions"}],"predecessor-version":[{"id":40099,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39981\/revisions\/40099"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=39981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=39981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=39981"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=39981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}