{"id":49404,"date":"2023-06-14T08:00:00","date_gmt":"2023-06-14T15:00:00","guid":{"rendered":""},"modified":"2025-06-02T07:48:35","modified_gmt":"2025-06-02T14:48:35","slug":"secure-your-ai-using-sql-server-machine-learning-with-microsoft-azure-openai-services","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2023\/06\/14\/secure-your-ai-using-sql-server-machine-learning-with-microsoft-azure-openai-services\/","title":{"rendered":"Secure your AI using SQL Server Machine Learning with Microsoft Azure OpenAI Services"},"content":{"rendered":"\n

Microsoft SQL Server Machine Learning Services<\/a> is a feature that allows you to run Python, R, Java, and other Machine Learning languages in-database, using open-source packages and frameworks for predictive analytics and machine learning. Microsoft Azure OpenAI Service<\/a> is an AI cognitive service that uses advanced systems for natural language, code, and image generation and understanding. In this blog post, you will see how you can use SQL Server Machine Learning Services with Microsoft Azure OpenAI Service in a practical example. Using SQL Server Machine Learning Services with Azure OpenAI Service is a powerful combination that can help businesses save money and securely leverage the products they already have.<\/p>\n\n\n

\n\t
\n\t\t
\n\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"CLO18_bankCoworkers_002\"\t\t\t\t<\/div>\n\t\t\t\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t

Microsoft SQL Server Machine Learning Service<\/h2>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t

What is SQL Server Machine Learning Services with Python and R?<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tLearn more<\/span>\n\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

Using the AdventureWorks sample database in a practical example<\/h2>\n\n\n\n

The AdventureWorks (fictitious) company uses a database that stores data about sales and marketing, products, customers and manufacturing.<\/a> It also contains a view that joins information about the products, such as the product name, category, price, and a brief description.<\/p>\n\n\n\n

Currently, AdventureWorks sends the product name and brief description to a marketing firm to develop a campaign to boost sales. The cost for this marketing specialist is significant, and after looking into the capabilities of Generative Pre-trained Transformers<\/a> (GPT), the company is curious to know if this AI could be used to create starter-text for brochures, automating the first step of the process. GPT-4 is a powerful language model that can generate coherent and creative text from complex input, or prompts<\/em>.<\/p>\n\n\n\n

Instead of hiring a professional writer, they can use SQL Server Machine Learning Services<\/a> with Microsoft Azure OpenAI Service<\/a> to automatically generate high-quality starter ad copy based on the product description and other relevant data. This can save time and money on the marketing budget. This approach also has the added benefit of security, since the database stays local, Stored Procedures have high security granularity, and Azure OpenAI Service does not use the information sent for further training.<\/p>\n\n\n\n

This process works on SQL Server Machine Learning Services platforms on Windows, Linux, Containers, and Kubernetes clusters, including virtual machines and SQL Server Managed Instance, from version 2019.<\/p>\n\n\n\n

During their research, AdventureWorks discovered that it is important to be cautious when generating text using a GPT model. It is possible that the generated text may not always be appropriate or accurate, so it is important to have a system in place for reviewing and approving any changes before they are published.<\/p>\n\n\n\n

The proof-of-concept (PoC) for AdventureWorks involves the following requirements:<\/p>\n\n\n\n

    \n
  1. Create a Stored Procedure to accept the model of a given product.<\/li>\n\n\n\n
  2. Generate marketing brochure text for that product, highlighting its features and benefits, using Azure OpenAI Service’s GPT-4 model.<\/li>\n\n\n\n
  3. Ensure that the generated text is safe and factual, and that it can be edited before publishing.<\/li>\n<\/ol>\n\n\n\n

    Example code<\/h2>\n\n\n\n

    The POC project for AdventureWorks involves the following steps:<\/p>\n\n\n\n

      \n
    1. Install SQL Server Machine Learning Services<\/a> on a Microsoft Windows, Linux, or Container environment.<\/li>\n\n\n\n
    2. Create and deploy a model on Azure OpenAI Service<\/a>, and obtain the model\u2019s name, keys and endpoints<\/a>.<\/li>\n\n\n\n
    3. Install the openai<\/em> Python package using Azure Data Studio<\/a> or the sqlmlutils<\/em> package<\/a>. This enables the code to use OpenAI API in Python scripts.<\/li>\n\n\n\n
    4. Write a Python script that uses the sp_execute_external_script<\/em> stored procedure to query the product\u2019s view, send the product name and description as a combined prompt<\/em> to the Azure OpenAI API. The script should also specify the parameters for the model, such as the engine name<\/em> (such as `davinci`), the temperature<\/em> (a measure of randomness), the max tokens<\/em> (the maximum length of the generated text), and the stop sequence<\/em> (a token that indicates the end of the text). The script should also handle any errors or warnings from the API and return the generated text as a result set.<\/li>\n\n\n\n
    5. Execute the Python script from SQL Server Management Studio<\/a> or Azure Data Studio<\/a> and review the generated text for each product. Edit the text as needed or re-run the script with different parameters to get different results.<\/li>\n\n\n\n
    6. Once the result is satisfactory, wrap the code in a stored procedure to take the product\u2019s model number from the user, and ensure the security chain is verified for the Stored Procedure.<\/li>\n\n\n\n
    7. In the end-user application, display the result for the ad text to the user for editing, and send the edited result to the database for storage.<\/li>\n<\/ol>\n\n\n\n

      With that outline, sample code in an Azure Data Studio Jupyter Notebook<\/a> has been developed for AdventureWorks, allowing descriptive blocks, code, and persistent results display. After testing and editing, the code can be copied to a Transact-SQL script and deployed to testing and then on to production. The end result produces the following starter text to display to the end user for editing and confirmation before being set to the database:<\/p>\n\n\n\n

      [sic]<\/em><\/p>\n\n\n\n

      Dear Mountain Bike Enthusiast, Are you looking for a bike that can deliver the performance you need without breaking the bank? Look no further than the Mountain-400-W Silver, 38.  This bike is designed to give you the high-level performance you need to tackle any terrain, without the high price tag. With its responsive and maneuverable design, you’ll be able to navigate even the toughest trails with ease.  But it’s not just about performance – the Mountain-400-W Silver, 38 also offers peace-of-mind when you decide to go off-road. With its sturdy construction and reliable components, you can trust this bike to handle anything you throw at it.  So why wait? Order your Mountain-400-W Silver, 38 today and experience the ultimate in off-road performance at a price you can afford. Don’t settle for anything less than the best – choose the Mountain-400-W Silver, 38 and take your mountain biking to the next level.<\/em><\/p>\n\n\n\n

      Other applications of this approach<\/h2>\n\n\n\n

      As you can see, using Microsoft SQL Server Machine Learning Services with Microsoft Azure OpenAI Service has practical applications. In this example we used it to create a marketing brochure text for various products. This is a powerful and creative way to leverage AI for business needs. The resulting text could be sent to an image-generating service (such as DALL-E<\/a>) to generate images for the brochure. Other data sets in the AdventureWorks database could be used in other applications, such as investigating sales regions and much more.<\/p>\n\n\n\n

      However, it is important to be cautious and responsible when using AI models, as they may not always produce accurate or appropriate results. You should always review and edit the generated text before publishing it and follow the safety and ethical guidelines of Microsoft Azure OpenAI Service<\/a>.<\/p>\n\n\n\n

      Learn more<\/h2>\n\n\n\n