Copilot in Azure SQL Database is now (March 2024) in private preview, offering two experiences within the Azure portal to streamline database management and improve productivity:

1. Natural language to SQL: This feature, available in the Azure portal query editor for Azure SQL Database, translates natural language queries into SQL code using table, view, and column metadata. Users can review and execute the generated code.
2. Azure Copilot integration: This experience adds Azure SQL Database skills to Microsoft Copilot for Azure, enabling users to ask context-rich questions and receive helpful suggestions for managing their databases and resolving issues independently.

Copilot in Azure SQL Database leverages various data sources, such as public documentation, database schema, dynamic management views, catalog views, and Azure supportability diagnostics to provide relevant responses to user queries. The tool assists with tasks like analyzing agent performance, generating summary tables, and troubleshooting database performance issues.

Check out the latest blog post on this by Asad Khan, Vice President Of SQL Server Products and Services.