5/21/2024 UPDATE - Microsoft Copilot in Azure will be available for all tenants and all users by default. You no longer need to sign-up in order to start to experience Microsoft Copilot in Azure. To learn how, see Manage access to Microsoft Copilot in Azure.
We are excited to announce the introduction of new Copilot skills for Azure SQL Database! Microsoft Copilot in Azure can now help you streamline the design, operation, optimization, and health of Azure SQL Database-driven applications. It improves productivity in the Azure portal by offering natural language to SQL conversion and self-help for database administration.
The new Copilot skills can be invoked in two Azure portal experiences:
- Natural language to SQL: This experience within the Azure portal query editor for Azure SQL Database translates natural language queries into SQL, making database interactions more intuitive.
- Azure Copilot integration: This experience adds Azure SQL Database skills into Microsoft Copilot in Azure, provides customers with self-guided assistance, and empowers them to manage their databases and solve issues independently.
Additionally, Copilot in Azure integrates data and formulates applicable responses using public documentation, database schema, dynamic management views, catalog views, and Azure supportability diagnostics.
Natural language to SQL
This experience within the Azure portal query editor for Azure SQL Database utilizes table and view names, column names, primary key, and foreign key metadata to generate T-SQL code. You can then review and execute the code suggestion.
This integration means that Copilot in Azure can answer questions with prompts like:
- Which agents have listed more than two properties for sale?
- Tell me the rank of each agent by property sales and show name, total sales, and rank
- Show me a pivot summary table that displays the number of properties sold in each year from 2020 to 2023
To use natural language to SQL, follow these steps:
In the query editor toolbar, select the Launch inline Copilot button.
Optionally, you can narrow down your selection of table and views for consideration.
Type your question in the input box. When ready, select the Generate Query button.
This will generate, but won't actually execute, a new T-SQL code statement. You either accept or decline the suggestion.
If accepted, execute the generated T-SQL query by selecting Run, or you can edit the prompt and regenerate new code. This regeneration will append, and not replace, any existing code in your Query editor window.
Copilot in Azure integration
You can ask and receive helpful, context-rich Azure SQL Database suggestions from Microsoft Copilot in Azure within the Azure portal. Get answers with prompts like:
- How much space is being used by this database?
- What are the active connections running right now?
- What are the top high CPU queries run in the last week?
For example, when you're experiencing slow performance, you could provide the prompt "My database is slow".
Copilot in Azure starts looking at your database based on your context in the Azure portal database blade. After the check, Copilot in Azure will detail specific areas that might be contributing to the issue. In this example, there was a specific query driving high CPU utilization:
You can continue the conversation and investigation with a prompt of "How can I tune that high CPU query?"
Copilot in Azure understands that this prompt refers to the query identified earlier, and provides a new index suggestion:
Copilot in Azure integrates data and formulates applicable responses using public documentation, dynamic management views, Query Store, catalog views, and Azure supportability diagnostics.
We hope that Copilot will help you to streamline your database management and improve your productivity.
Related Links
Microsoft Copilot in Azure: Microsoft Copilot for Azure (preview) | Microsoft Learn
Azure SQL capabilities overview: https://aka.ms/sqlcopilot-overview
FAQ: https://aka.ms/sqlcopilot-faq
Natural language to SQL and Azure portal Query editor (preview): https://aka.ms/sqlcopilot-nl2sql
Intelligent applications with Azure SQL Database: https://aka.ms/sqlai