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

Standalone or Integrated flavour of your Dedicated Pool (sqldw)

Now that MSFT have released Synapse as an Integrated framework of tools for Data Engineering we have two different ways to provision our enterprise data warehouse in a dedicated sql pool. Which is the best one to use ? Firstly we can use the new Integrated experience with the dedicated pool owned by Synapse Workspace. … Continue reading Standalone or Integrated flavour of your Dedicated Pool (sqldw)