Content by perirocha (2)

perirocha announces general availability of IDENTITY columns in Fabric Data Warehouse, adding IDENTITY_INSERT and reseed operations to support common migration and enterprise warehousing patterns, especially where preserving surrogate key values is required across dimension and fact tables.

perirocha introduces the generally available sp_get_table_health_metrics stored procedure for Microsoft Fabric Lakehouse tables, showing how SQL analytics endpoint users can diagnose physical table health (like small files, deleted rows, and checkpoints) in T-SQL and trigger OPTIMIZE only when it’s actually needed.