Microsoft Developer demonstrates the preview of GitHub Copilot integration in SSMS 22, showing how developers can use Copilot for T-SQL coding and database tasks within SQL Server Management Studio.

Introducing GitHub Copilot in SQL Server Management Studio 22 Preview

The preview of GitHub Copilot is now available in SQL Server Management Studio (SSMS) 22 Preview 3. With this integration, developers can benefit from Copilot’s AI-powered code suggestions directly within SSMS, making it easier to write T-SQL, troubleshoot issues, manage databases, and streamline development workflows.

Key Features

  • Integrated Copilot Access: Log in using the same Copilot license used for Visual Studio or VS Code.
  • T-SQL Assistance: Receive real-time code suggestions, completions, and explanations in the query editor.
  • Database Management and Troubleshooting: Use Copilot to get help with configuration, database exploration, and resolving issues.
  • Seamless Developer Experience: Enhances productivity by enabling advanced coding assistance within an SQL environment familiar to many developers.

How to Get Started

  1. Install SSMS 22 Preview 3: Download the latest preview from the official Microsoft website.
  2. Open the Query Editor: Start a session and connect to your target SQL database.
  3. Sign In to Copilot: Use your existing GitHub Copilot subscription credentials to log in.
  4. Explore Copilot Features: Begin typing T-SQL or use Copilot to assist with other database tasks.

Demo Overview

  • Live Demonstration: See Copilot in action, writing T-SQL statements and providing code suggestions.
  • Management Tasks: Learn how Copilot helps with database configuration and troubleshooting.
  • Roadmap: Overview of upcoming features and ongoing improvements planned for Copilot in SSMS.

Additional Resources

Conclusion

Bringing GitHub Copilot to SSMS 22 marks a significant step forward for SQL developers, enabling AI-powered assistance in database management and T-SQL development directly within SSMS.