Build AI-Ready Applications with SQL Server and GitHub Copilot in VS Code

AI-ready applications do not have to be complex, you can build them directly on top of SQL Server using tools you already know. In this session, you will see how the MSSQL extension integrated with GitHub Copilot in Visual Studio Code streamlines database design, helps generate schema changes, and guides you through adding SQL Server native vector data types to enable semantic search and Retrieval Augmented Generation (RAG) scenarios.

We will start with a traditional SQL-backed application and enhance it with vector columns, indexes, and embeddings, all created and managed inside VS Code. You will learn how Copilot assists with writing SQL, validating schema updates, and producing the queries needed for similarity search using SQL Server vector functions. The session then shows how these updates flow into the application layer so your backend can return meaningful, AI supported results with minimal changes.

The session also highlights how the MSSQL extension supports this workflow with a modern user interface, integrated query and editing tools, and local SQL container support for fast development and testing. Together these capabilities create a practical path for evolving existing applications or starting new projects that combine SQL development, vector search, and Copilot assisted productivity inside a single unified environment in VS Code.

- Understand how the MSSQL extension integrated with GitHub Copilot in VS Code accelerates schema design and SQL development
- Learn how to add vector columns, create indexes, and generate embeddings to support semantic search and RAG scenarios
- See how database updates flow into the application layer to enable AI supported behavior with minimal changes
- Explore how local SQL containers, modern UI tools, and integrated editing features in the MSSQL extension simplify end to end development in VS Code