Forum Discussion
DW Missing features compared to SQL server
Hi AJAJ,
Lakehouses and Warehouses do not support the full T-SQL language. If you want full SQL support like you're used to, I recommend using a SQL Database in Fabric (they just went into GA today).
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi AJAJ, thanks for your question. While it may make sense to compare SQL Server with Fabric Data Warehouse in certain scenarios, it is still an incorrect comparison. At the very high level, SQL Server is a transactional workload, while Fabric Warehouse is an analytical workload. They are designed and implemented to fulfil different purposes and achieve different goals. Therefore, there are functional differences between them. The correct comparison would be SQL Server vs Fabic SQL Database. Both are transactional workloads but the latter (Fabric Database) is fully integrated inside Fabric SaaS platfrom offering unique features not directly availabe with a aloud or stanalone SQL Server. Here is a link to learn more about how Fabric SQL database compares to a SQL Server database Limitations for SQL database - Microsoft Fabric | Microsoft Learn.
If you are interested in Analytical solutions in Microsoft Fabric, it offers two traditional analytical workloads: Lakehouse and Warehouse. They also have differences and you can learn about them here Microsoft Fabric Decision Guide: Choose between Warehouse and Lakehouse - Microsoft Fabric | Microsoft Learn.
If, on the other hand, you need help with understanding all different kinds of stores that Microsoft Fabric offers, you can start here Fabric decision guide - choose a data store - Microsoft Fabric | Microsoft Learn.
Hope this information helps resolve your confusion.
If you find this answer useful, please give it kudos and/or accept it as a solution to your question.