SQL vc Microsoft Fabric

fabric relies on an advanced query engine that auto‑optimizes queries without necessitating manual index creation.

Instead of manually applying missing index recommendations, Fabric’s engine dynamically adjusts execution strategies based on workload patterns, so you typically review performance metrics and query logs rather than a detailed index tuning process.

Capacity Metrics app—to view real‑time resource utilization and built‑in usage and billing reports

the shortcut lets you rapidly create sandbox  large tables,

Fabric minimizes the need for manual session management by enforcing policy‑driven controls and automated resource re‑cycling.

In summary Microsoft Fabric shifts many of the traditional DBA responsibilities into an automated, monitoring‑driven model that leverages modern cloud infrastructure and integrated analytics tool