New AI integration for your SQL databases | RAG, Vector Search, Admin Automation

Check out new AI integrations for your Azure SQL databases. With Retrieval Augmented Generation, you can bridge structured data with generative AI, enhancing natural language queries across applications. With advanced vector-based semantic search, discover precise insights tailored to your data, while Copilot in Azure streamlines troubleshooting and T-SQL query authoring. Optimize workflows, personalize responses, and unlock new levels of efficiency in SQL-driven AI applications.

Accelerate performance troubleshooting and complex query authoring tasks with Copilot in Azure. Quickly diagnose database issues and receive expert recommendations for optimization, ensuring optimal performance and reliability. Seamlessly traverse hierarchies within tables and generate intricate queries with ease, saving time and resources.

Bob Ward, Azure Principal Architect, shows how to unleash the full potential of your SQL data, driving innovation and intelligence across your applications.

► QUICK LINKS:
00:00 - AI and Azure SQL
01:40 - Using T-SQL for search
02:30 - Using Azure AI Search
03:17 - Vector embeddings and skillsets
04:08 - Connect your SQL data to an AI app
05:44 - Test it in Azure OpenAI Studio playground
07:22 - Combine native JSON data type in SQL
08:30 - Hybrid search
09:56 - Copilot in Azure: Performance troubleshooting
11:11 - Copilot in Azure: Query authoring
12:24 - Permissions
12:40 - Wrap up

► Link References

► 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.

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

#Copilot #SQL #Azure #VectorSearch

[learningisgrowinglig]

what about large database like 2000-3000 tables with complex mapping/cardinality. a demo of this usecase would be brilliant

[DataSpook]

Nice!! In the words of the agent Smith, "we need more" (examples).

[RedOwl-lhzc]

How did you add the index with embeddings?

[nandhakumar]

@bobward436 I have created a index with SQL through wizard and adding fields manually. Tried adding the vector profile. But still i am not able to vectorize the data. Vector index size remains 0 size and not able to vectorize the data. Am i missing any step here.

[REYS]

Your Copilot looks smarter than the one i'm using...

[nandhakumar]

Can you please explain on how did you create single field "embedding" and store all the columns data into it?
I am able to generate and store single column data only into single embedding field. Not able to store all the columns data into single embeddings.

[gotqn]

The part to trust that my data is queried but not used for training models or something else is ...

[Thulebeez]

This is great new tech howeever some of us i still using on Prepm SQL 2016 due Application limitation, we still got a long way to go.

[bvsshivasaiinturi]

Is there any additional cost involved for using copilot inside query editor of azure sql?

[KenRossPhotography]

Also curious if there's an entirely on-prem scenario that could be supported, perhaps using one of the various Open Source vector databases [installed locally] and something like Phi-3 or Llama as a locally executing SLM. I have a high-profile scenario using on-prem SQL that could really use that kind of functionality but there is no option to connect to Azure.

[limjuroy]

Are all the fields in the Azure AI Search index (productdataindex) created automatically, or do we need to manually create them ourselves? I assume that these fields are generated automatically when connecting Azure AI Search to our SQL Database data source.

[sagarparbhane]

“That’s really cool. Is there a way I can set up everything as shown in the video and try these out on my own?”

[KenRossPhotography]

Given this is SQL and data often changes, what is the mechanism for making sure your embeddings are updated?

[fbifido]

can you ask Microsoft SQL team to make "SQL Server & Studio" keep a log of performance & query, as to allow us to look back to see if the server is running low on RAM, IOPs or Network?
then ask the Microsoft PowerToys teams to create an App to monitor the SQL Server for said performance.

With this info, they can use SQL AI to help the user get better SQL performance.

[nghiatran]

Can it does the same with MS Access like SQL databases? Thank you.

[JohnDoe-dxix]

At 13:18 that is because you are using the TFS wrong. Learn how to properly use TFS and don't spend money on Azure AI Search. Oh, by the way, Azure uses TFS to do the text search.