Synpase SQL Tip 2 – Comments in Views/Procs

Synapse SQL Dedidcated Pools (aka SQLDW) does not support comments in views or procs in the same was as standalone SQL. This is annoying as comments can be very useful with tracking changes and lineage of objects, especially when used in conjunction with Schema Compare tools in Visual Studio. Everyone has seen that incident where … Continue reading Synpase SQL Tip 2 – Comments in Views/Procs

Synapse TSQL Tip 1 – Use Double Defensive Inserts

When loading a Star Schema Datawarehouse it is very common to need to insert rows into the a dimension based on exceptions. For example: Inferred Members (aka early arriving facts)Unknown Members (missing data) A Typical Query may look something like this for inferred members INSERT INTO DimAccount(AccountCode, AccountName, Inferred) SELECT f.AccountCode, 'Account Missing',1 FROM staging.FactTransactions … Continue reading Synapse TSQL Tip 1 – Use Double Defensive Inserts