DW Automation demo for Synapse SQL Pools (3/3)

This is the third blog in a series looking at the need for DW Automation focusing on Synapse SQL Pools (dedicated). In the first blog we looked at why we need DW Automation tools and what they look like:https://prodata.ie/2021/09/14/the-need-for-dw-automation-1-3/In the second blog we looked at a maturity model for DW automation with six levels of … Continue reading DW Automation demo for Synapse SQL Pools (3/3)

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