Visual Studio Code authors Olivia McVicker and Carlos Robles present a hands-on guide to leveraging the newest MSSQL extension features—including GitHub Copilot Ask, Agent Mode, and containerized SQL Server—for enhanced SQL development.

Boost Your SQL Development in VS Code: GitHub Copilot, Containers, and More

Presenters: Olivia McVicker, Carlos Robles

Explore the latest capabilities of the MSSQL extension for Visual Studio Code designed for SQL developers and data professionals. This session covers practical demonstrations for each feature, empowering you to modernize and streamline your database workflows.

Key Topics Covered

• GitHub Copilot Ask Integration:
  • Interact with Copilot directly within VS Code to suggest SQL queries, explain code, and boost productivity.
• Agent Mode:
  • Benefit from advanced SQL Agent features to schedule jobs and manage tasks efficiently.
• Connection Management Improvements:
  • Seamlessly pair with multiple SQL Server instances and simplify server switching.
• Local SQL Server Containers:
  • Develop and test against containerized SQL Server instances directly in your local environment.
• Enhanced Schema Tools:
  • Visual design and compare SQL schema using upgraded Designer and Compare tools, ensuring accuracy across modifications.

How These Features Help

• Shorten SQL development cycles with contextual AI suggestions (Copilot Ask).
• Manage complex environments using Agent Mode and containers.
• Ensure database changes are predictable and reliable with improved schema tooling.

Resources

• YouTube Playlist
• Azure SQL Blog
• GitHub Repo
• Official Docs

About the Presenters

Olivia McVicker and Carlos Robles share up-to-date insights direct from the Visual Studio Code and Microsoft SQL Server extension development teams.