Modern analytics teams are adopting open, SQL-first data transformation, robust CI/CD and governance, and seamless integration across lakehouse and warehouse platforms. dbt is now the standard for analytics engineering, while Microsoft Fabric unifies data engineering, science, warehousing, and BI in OneLake.
Deployment Challenges While Solutions Are in Development Microsoft Fabric has revolutionized data analytics with its unified platform, but deploying complex architectures with cross-dependencies remains a significant challenge for organizations. The good news is that the Microsoft Fabric team is actively working on native warehouse deployment capabilities with DacFx, cross-item dependency resolution, and cross-warehouse reference support. … Continue reading “Bridging the Gap: Automate Warehouse & SQL Endpoint Deployment in Microsoft Fabric”
In our earlier announcement, we shared that newly created data warehouses, lakehouses and other items in Microsoft Fabric would no longer automatically generate default semantic models. This change allows customers to have more control over their modeling experience and to explicitly choose when and how to create semantic models. Starting end of October 2025, Microsoft … Continue reading “Decoupling Default Semantic Models for Existing Items in Microsoft Fabric”
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 … Continue reading “SSMS 22 Meets Fabric Data Warehouse: Evolving the Developer Experiences”
Motherson, a global manufacturing specialist industry and one of the world’s leading automotive suppliers, faced significant challenges during their migration to Microsoft Fabric. They shared how the workspace collation settings transformed their experience: “As part of our migration from Microsoft SQL Server to Microsoft Fabric, we hit a major roadblock with the default case-sensitive collation … Continue reading “Streamlining Data Management with Workspace Collation Settings in Microsoft Fabric Warehouse and SQL Endpoint”
