𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞 𝐚𝐧𝐝 𝐓 𝐒𝐐𝐋 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 - Imprive & avoid limitations

𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞 𝐚𝐧𝐝 𝐓 𝐒𝐐𝐋 𝐬𝐮𝐩𝐩𝐨𝐫𝐭

✔️ Any news about T-SQL DDL ==>

• alter table add/remove column
• Identity Columns
• Primary keys
• RECORD Columns (store nested fields like json structures)
• temporary tables (useful on stored proc)
• Ok, we benefit from Time Travel T-SQL feature, but we also need ==> Temporal Tables for RAW / Staging databases (rows versioning after a merge - Sql server 2022) (useful on storec proc)

and T-SQL DML ==>

• merge (useful UPSERT on stored proc or for engine DBT compiler) (Type 1 upsert)
• merge with OUTPUT $action (useful UPSERT + CREATION new current row in case of update) on storec proc or for engine DBT compiler) (Row snapshot , Type 2 versioning)
• truncate table (useful on stored proc or for DBT engine compiler) (Full refresh)

on Fabric Warehouse ?

Nobody undersand these "super strange" limitations from Microsoft who slow down adoption

✔️ Query activity ==> Offer much more queries history insights

In a hurry to get on Fabric DWH Console similar SQL QUERIES insights as on Bigquery

Very useful to detect query performance ?

• Volumetry to read (Mb & Rows)
• Volumetry as result (Mb & Rows)
• Global & sub tasks query durations
• Fine Query Plan Presentation => Are we using a T SQL table partition ?

or other DWH feature to reduce SQL query ?

etc ..