In modern database development workflows, updates to the schema and data should be tested, so they don't introduce bugs or cause data loss. This testing can sometimes be referred to as a smoke test,...

This post covers the automation of cloning a Synapse dedicated SQL pool from one workspace to another where locks and encryption exist. The steps required by the code are as...

As you build out a Synapse workspace, you will inevitably start to create a dependency model between pipelines. When deploying artefacts to the workspace, you may need to clear down the existing...