This session highlights the enhanced MSSQL extension for Visual Studio Code, now more powerful than ever with new capabilities and AI-driven enhancements to streamline your SQL development experience.

Experience a revamped UI/UX (GA) and advanced Schema Management tools (Public Preview) that make SQL development faster, more intuitive, and developer-friendly. The new Schema Designer enables seamless visualization and editing, while Schema Compare helps you track and apply schema changes effortlessly.

Learn how GitHub Copilot (Public Preview) elevates your productivity by assisting with tasks such as schema design, query generation, and database performance optimization.

Whether you’re working locally with SQL Server or deploying to the cloud with Azure SQL Database / SQL Database in Fabric, the latest enhancements bring cloud-like workflows to local development, allowing you to interact with your databases seamlessly while leveraging modern SQL tools and techniques in Visual Studio Code.

You will learn:

• Master a modern SQL development workflow with a revamped UI/UX and cloud-like local development experience.
• Efficiently design, manage, and compare schemas using Schema Designer and Schema Compare.
• Boost productivity with AI-powered assistance, leveraging GitHub Copilot for schema design, query generation, and performance optimization.