Microsoft Fabric Blog presents a comprehensive overview of the SSMS 22 integration with Fabric Data Warehouse, highlighting new features that enhance SQL development workflows and align cross-platform experiences for developers.

SSMS 22 Meets Fabric Data Warehouse: Evolving the Developer Experiences

Why this Investment Matters

SQL Server Management Studio (SSMS) has long been the standard for SQL developers, with millions of users worldwide. However, integration with Fabric Data Warehouse was limited—creating friction between web and desktop workflows. With SSMS 22, Fabric Warehouse delivers deep integration, aiming for a unified and consistent experience for developers.

What’s New in SSMS 22 for Fabric Warehouse?

Friendly Connection Names: Instead of cryptic server names, SSMS 22 displays readable workspace names in the object explorer, making environment identification easier, especially for those working with multiple workspaces.
Schema-Based Object Grouping: Tables, views, and stored procedures are now grouped by schema, mirroring the Fabric Web editor. This logical organization improves navigation and accelerates development for complex data models.
Warehouse-Centric Views: Warehouses and SQL Analytics Endpoints are now primary objects in SSMS, with warehouse snapshots visible and directly queryable—enabling point-in-time recovery and audits.
Full T-SQL Experience: The T-SQL editor continues to support familiar features like IntelliSense, query execution plans, and scripting, preserving productivity while introducing enhancements.
Cleaner Context Menus: Context-aware menus now present only relevant actions for Fabric Warehouse, reducing menu clutter and minimizing confusion.

Why this is Important

These updates reflect a developer-first commitment:

Reduced workflow friction between Fabric and SSMS
Consistent query and schema management across tools
Foundations laid for future features like version control and database projects within SSMS

What’s Next?

Upcoming investments include:

Direct discovery and connection to Warehouses and SQL Analytics Endpoints without manual searching
Expanded context menu actions (e.g., Extract DacPac, Generate Scripts, Refresh Snapshot)
Script generation tailored to the Fabric engine edition
Full warehouse lifecycle management (creation/deletion) from SSMS

These changes are part of an ongoing strategy to empower developers with seamless, cloud-powered analytics development inside their trusted tools.

Conclusion

The collaboration between Fabric and the SSMS team is closing the gap between cloud innovation and classic developer tools. With continuous feedback from the community, Fabric Warehouse in SSMS 22 represents only the first step toward a more powerful, developer-centric analytics platform.

This post appeared first on “Microsoft Fabric Blog”. Read the entire article here