Modern SQL Development with the MSSQL Extension in VS Code

The MSSQL extension for Visual Studio Code now brings the most important SQL Server, Azure SQL, and Fabric SQL capabilities into a unified, modern developer experience. This session showcases how the extension has evolved into a comprehensive environment for building, managing, and deploying SQL-backed applications directly from VS Code.

Explore the full suite of core features, including a refreshed UI/UX, visual schema modeling and editing, and schema comparison. Then see the latest additions, including Edit Data (Public Preview) for quick spreadsheet-style updates and DACPAC import/export (Public Preview) with deployment workflows that simplify moving changes across environments. These capabilities work alongside Local SQL Containers for fast local development and Fabric integration with workspace browsing and SQL database provisioning, creating a seamless path from local iteration to cloud deployment.

The session will also highlight the new ADS-originated experiences now available in VS Code, including Backup/Restore, Flat File Import, Global Search, and SQL Profiler, bringing familiar workflows together and completing a streamlined, end-to-end SQL development experience.

- Understand the newest MSSQL extension capabilities for building and managing SQL schemas directly in VS Code - Learn how schema tools, Edit Data, DACPAC workflows, and SQL containers streamline local development and deployment - Explore newly added ADS workflows such as Backup/Restore, Flat File Import, Global Search, and SQL Profiler inside VS Code