<ul data-eligibleForWebStory="true"><li>SSMS 21, the latest version, integrates with Copilot.</li><li>Copilot requires an Azure subscription, which incurs costs based on prompts. Microsoft Entra authentication is an option.</li><li>Set up Azure OpenAI service by creating it and selecting the gpt-4o model.</li><li>In SSMS, access Copilot and configure it with Azure OpenAI Endpoint and API Key.</li><li>The Open AI Deployment name defined earlier is used in the configuration.</li><li>Configuration settings can also be accessed under 'Tools' > 'Options' > 'Copilot' in SSMS.</li><li>Following these steps enables users to start interacting with Copilot in SSMS.</li><li>Privacy-wise, OpenAI states that prompts will not be used for model training.</li><li>The blog post aims to simplify the setup process for utilizing Copilot in SSMS.</li></ul>

Step-by-Step Guide to Enabling Copilot in SSMS

Discover more