Build Modern and AI-Ready Apps with SQL and GitHub Copilot in VS Code

Yo-Lei Chen demonstrates how to take an app from local development to cloud deployment, using SQL Server as the core data layer and GitHub Copilot in VS Code to speed up database and backend work.

Overview

The session walks through building a fully functional, AI-ready application powered by SQL Server, showing how GitHub Copilot in VS Code can streamline:

• Database design and schema creation
• Backend code generation
• Query assistance during SQL development

It also covers how to connect the backend to the rest of the application via:

• REST endpoints
• GraphQL endpoints

For the frontend and deployment path, the session includes building a modern frontend and deploying it with:

• Azure Static Web Apps

AI-ready data layer with SQL Server vectors

The video highlights SQL Server’s native vector data types and how they enable AI-oriented scenarios directly in the database layer, including:

• Semantic search
• Retrieval-augmented generation (RAG)

What you will learn

• How GitHub Copilot in VS Code accelerates SQL development (schema creation, backend code generation, and query help)
• How to build and deploy a full-stack application powered by SQL Server, connecting REST or GraphQL APIs to a modern frontend and Azure Static Web Apps
• How SQL Server vector data types can support semantic search and RAG scenarios to make applications AI-ready