GitHub Copilot in SQL Server (Preview)

GitHub Copilot for SQL Server Management Studio (SSMS) integrates AI directly into your database environment to streamline T-SQL development. Here is a summary of how it works and what it offers:

How it Works

The integration connects your GitHub Copilot account to SSMS. When you submit a prompt, SSMS sends it to the selected AI model along with contextual metadata—such as your SQL version and database schema—to ensure the generated code is accurate and relevant to your specific environment.

Key Features

• Interactive Chat: Use a dedicated chat window or an inline chat view to ask questions using natural language.

• T-SQL Assistance: Generate, fix, or optimize SQL queries on the fly.

• Slash Commands: Use quick shortcuts for specific tasks:

  • /doc: Automatically document your code.

  • Explain: Get a breakdown of complex queries.

  • Fix/Optimize: Improve query performance or resolve errors.

Note: This feature is currently in Preview. You will need an active GitHub Copilot subscription and the latest SSMS preview installation to use it. 

Cheers,

Samitha

npm run build does not work

If you are experiencing building js files for production follow these steps

•  Make sure you have the correct node version

          execute node -v in PowerShell / Command Prompt / VS Code terminal

• Delete node_modules 
• Delete package-lock.json
• Install correct node version
• Restart the Terminal (This step is required on Windows so PATH updates correctly)
• execute npm install in PowerShell / Command Prompt / VS Code terminal
• execute npm run dev in PowerShell / Command Prompt / VS Code terminal

Cheers

Samitha