Implement SQL solutions by using AI-assisted tools
Intermediate
Database Administrator
Developer
Data Engineer
SQL Server
Azure SQL Database
Microsoft Fabric
Learn how to leverage GitHub Copilot and Fabric Copilot for AI-assisted database development across SQL Server, Azure SQL, and SQL databases in Microsoft Fabric.
Learning objectives
By the end of this module, you'll be able to:
- Describe AI-assisted development tools available for Microsoft SQL platforms
- Interpret security impact of using AI-assisted tools
- Enable GitHub Copilot and Fabric Copilot
- Configure model and Model Context Protocol (MCP) tool options in a GitHub Copilot or Fabric Copilot chat session
- Create and configure GitHub Copilot instruction files
- Connect to MCP server endpoints, including Microsoft SQL Server and Fabric Lakehouse
Prerequisites
- Experience writing T-SQL code for SQL Server or Azure SQL
- Familiarity with SQL Server Management Studio (SSMS) or Visual Studio Code
- Basic understanding of database development concepts (tables, stored procedures, views)