Microsoft Copilot in Azure with Azure SQL Database

Artikel
2025-04-12

van toepassing op:Azure SQL Database-

Microsoft Copilot in Azure with Azure SQL Database is a capability of the Microsoft Azure Copilot experience that enhances the management and operation of Azure services, providing robust capabilities for SQL-dependent applications. It provides a conversational interface for users to interact with their databases, allowing them to ask questions and receive relevant answers based on the context of their database. Het verbetert de productiviteit in Azure Portal door zelfhulp te bieden voor databasebeheer. This makes it easier for developers and database administrators to manage their databases, troubleshoot issues, and optimize performance.

This article provides an overview of Microsoft Copilot in Azure with Azure SQL Database, including its features, how it works, and best practices for effective use.

How Copilot works in Azure SQL Database

Microsoft Copilot in Azure is now integrated with Azure SQL Database.

Copilot in Azure SQL Database uses large language models (LLMs) to analyze the context of your database and provide relevant answers to your questions. It applies various data sources, including public documentation, dynamic management views, catalog views, and Azure supportability diagnostics, to generate applicable responses. This allows users to ask questions in natural language and receive detailed explanations and suggestions for their database-related queries.

Features of Copilot in Azure SQL Database

Copilot biedt relevante antwoorden op vragen van gebruikers, vereenvoudigt databasebeheer door databasecontext, documentatie, dynamische beheerweergaven, Query Store en andere kennisbronnen toe te passen.

Voorbeeld:

Databasebeheerders kunnen onafhankelijk databases beheren en problemen oplossen, of meer informatie over de prestaties en mogelijkheden van uw database.
Ontwikkelaars kunnen vragen stellen over hun gegevens zoals ze zouden doen in tekst of gesprek om een T-SQL-query te genereren. Ontwikkelaars kunnen ook sneller query's schrijven via gedetailleerde uitleg van de gegenereerde query.
Microsoft Copilot in Azure-integratie: met deze ervaring worden Azure SQL Database-vaardigheden toegevoegd aan Microsoft Copilot in Azure, klanten met zelfhulp, waardoor ze hun databases kunnen beheren en problemen onafhankelijk kunnen oplossen.
Copilot integreert gegevens en formuleert toepasselijke antwoorden met behulp van openbare documentatie, dynamische beheerweergaven, catalogusweergaven en diagnostische gegevens over azure-ondersteuning.

Copilot inschakelen in uw Azure-tenant

For information on enabling Microsoft Copilot, visit What is Microsoft Copilot for Azure.

Best practices for using Copilot in Azure SQL Database

U kunt nuttige, contextrijke suggesties van Microsoft Copilot in Azure in Azure Portal vragen en ontvangen.

Consider the Azure SQL database you're working with and the context of your question. The more specific you are, the better the responses can be. For example, if you ask about a specific database, Copilot provides information relevant to that database.

Additionally, if you're asking Copilot a question about a different database from the database service or page you are on, the result isn't clear and is more likely to give you a bad output.

Voorbeelden van aanwijzingen

The following example prompts are clear, specific, and tailored to the properties of your schema and database.

You can provide prompts for the Microsoft Copilot in Azure around different capability areas.

  - What service tier should I use for this database?
  - Which connection string should I use to connect to my database?
  - Why was my database unavailable?

For a list of more prompts, visit List of sample prompts.

Opmerking

AI zorgt voor Copilot, dus verrassingen en fouten zijn mogelijk.

Responsible AI in Microsoft Copilot in Azure

Microsoft is committed to responsible AI. We're continuously working to improve the quality and safety of our AI systems. Microsoft Copilot in Azure is designed to help you be more productive, but it's important to remember that it isn't a replacement for human judgment. Always review the output produced by Copilot before using it in production.

For more information on how Microsoft implements responsible AI tools in Microsoft Copilot in Azure, see Responsible AI FAQ for Microsoft Copilot in Azure.

Delen via