Data and Analytics, Microsoft Sessions

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

07/30/2026

3:15pm - 4:30pm

Level: Intermediate to Advanced

Carlos Robles

Principal Product Manager

Microsoft

Learn how to go from local development to cloud deployment with a fully functional, AI-ready application powered by SQL Server. In this session, you’ll see how GitHub Copilot in VS Code streamlines database design, schema creation, and backend code generation, helping you move seamlessly from database to application code.

You’ll connect your backend through REST or GraphQL endpoints, build a modern frontend with Azure Static Web Apps, and explore how SQL Server’s native vector data types enable semantic search and retrieval-augmented generation (RAG) scenarios—bringing AI directly into your app’s data layer.

Whether you’re prototyping or scaling your next big idea, this session shows how to build intelligent, cloud-ready apps—starting entirely on your local machine.

You will learn:

  • How GitHub Copilot in VS Code accelerates SQL development, from schema creation to backend code generation and query assistance.
  • Understand how to build and deploy a full-stack application powered by SQL Server, connecting REST or GraphQL APIs with modern frontend frameworks and Azure Static Web Apps.
  • Explore how SQL Server’s vector data types enable AI scenarios such as semantic search and retrieval-augmented generation (RAG), making your apps AI-ready.