See how you can use your SQL data as a robust backend for AI applications with semantic search and retrieval augmented generation. Azure SQL Database along with any SQL servers you connect to Azure integrate seamlessly with Azure AI Search and the Azure OpenAI Service, enabling natural language search capabilities within your SQL data.

Use this approach to enhance e-commerce platforms, financial data analysis, or CRM systems while using SQL's granular access management controls to ensure that data searches and generated responses are limited to specific user permissions.

► QUICK LINKS: 00:00 - Generative AI for your SQL workloads 00:33 - Retrieval Augmented Generation 01:00 - Granular access management 01:15 - Enable natural language search 01:54 - Connect vectorized SQL data 02:20 - Test generative AI responses 02:41 - Wrap up

► Unfamiliar with Microsoft Mechanics?

As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.

• Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries

• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog

• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast

► Keep getting this insider knowledge, join us on social:

• Follow us on Twitter: https://twitter.com/MSFTMechanics

• Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/

• Enjoy us on Instagram: https://www.instagram.com/msftmechanics/

• Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics