5: Optimize your dedicated SQL Pools per environment

There might be times where you need to optimize your dedicated SQL Pools per environment.

For example, you might have a table development environment which only needs a round-robin distribution whereas the table needs to use a hash distribution in a production environment.

You can do this in Azure Pipelines by using PowerShell tasks.

I go into more details about this in a blog post I wrote called Transform your SQL Server database schema for a dedicated SQL Pool.