SSMS 22 Meets Fabric Data Warehouse: Evolving the Developer Experiences
Why this Investment Matters
For years, SQL Server Management Studio (SSMS) has been the go-to tool for millions of SQL developers worldwide. With millions of active users, SSMS remains the most trusted environment for database professionals. Yet, Fabric Data Warehouse had long lacked deep integration with SSMS, leaving developers to juggle inconsistent experiences between web and desktop tools.
That changes now, Fabric Warehouse is fully investing in pro developer experiences, meeting developers where they are—inside SSMS 22 Preview. This is more than a feature update; it’s a strategic commitment to unify experiences across first-party integrations like SSMS and the Fabric Web editor, ensuring consistency, productivity, and familiarity for SQL developers.
What’s New in SSMS 22 Preview for Fabric Warehouse?
Friendly Connection Name: Previously, connecting to Fabric Warehouse from SSMS meant dealing with cryptic server names that provided little context. With SSMS 22, this is history. Now, when you connect, you’ll see the workspace name displayed in the object explorer. This small but impactful change improves clarity, reduces onboarding friction, and makes it easier for developers to identify the right environment—especially in multi-workspace scenarios.
Schema-Based Object Grouping: For years, developers requested schema-based grouping in SSMS. Objects such as tables, views, and stored procedures are now neatly organized by schema, just like in the Fabric Web editor. This alignment simplifies navigation, supports better logical organization, and accelerates development workflows for teams managing complex data models.
Warehouse-Centric Views: Instead of traditional Databases and Database Snapshots, SSMS now shows:
Warehouses & SQL Analytics Endpoints
Warehouse Snapshots
Snapshots were previously invisible in SSMS, limiting troubleshooting and historical analysis. With SSMS 22, developers can query snapshots directly, enabling point-in-time recovery scenarios and audit capabilities without leaving their favorite tool.
Full T-SQL Experience: The heart of SSMS—the T-SQL editor—remains intact and fully optimized for Fabric Warehouse. Developers can leverage IntelliSense, query execution plans, and scripting features they know and love. This continuity ensures that while the integration evolves, the core experience remains familiar and powerful.
Cleaner Context Menus: Context menus in earlier versions were cluttered with irrelevant options that didn’t apply to Fabric Warehouse. SSMS 22 introduces context-aware menus, removing unnecessary actions and focusing on what matters. This reduces confusion and ensures developers only see options that are actionable in the Fabric context.
Why this is Important
These changes aren’t cosmetic—they represent a philosophical shift. Fabric is embracing the tools developers love, which they use the most. By aligning SSMS and Fabric Web editor experiences, we:
- Reduce friction for millions of SQL developers.
- Enable cross-tool continuity for query management and schema exploration.
- Lay the foundation for advanced capabilities like version control, database projects development and much more from SSMS 2022.
What’s Next?
The journey doesn’t stop here. Upcoming investments include:
- Direct Warehouse & SQL Analytics Endpoints Discovery and Connection Soon, you’ll be able to browse and connect to Fabric Warehouses and SQL Analytics Endpoints directly from SSMS—no manual endpoint hunting required.
- Context Menu Actions at Warehouse and Object Level Expect richer, Fabric-specific actions like ‘Extract DacPac’, ‘Generate Scripts’, ‘Refresh Snapshot’ and many more right from the SSMS UI.
- Script Generation Aligned with Fabric Engine Edition We’re working on intelligent script generation that respects Fabric Warehouse engine specifics, ensuring compatibility and reducing errors.
- Create & Delete Warehouses from SSMS Manage your entire lifecycle—provision new warehouses or retire old ones—without leaving SSMS.
This investment is more than a feature rollout—it’s a strategic commitment to developers. By bringing Fabric Warehouse into SSMS, we’re bridging the gap between cloud innovation, and the tools developers trust every day.
We’re listening to the community and building for the future. SSMS 22 is just the beginning—expect continuous improvements that make Fabric Warehouse the most developer-friendly product on the market. Together, we’re shaping the next generation of analytics development.
