Provisioning a Synapse dedicated SQL pool

You have two options when it comes to creating a Synapse dedicated SQL pool: a standalone version and a version that is integrated with the Synapse Analytics workspace. As we will need the Synapse workspace several times again later in this book, for example, when you examine the Synapse Spark pools in Chapter 6, Using Synapse Spark Pools, we will go and provision a workspace directly:

1. Click + Create a resource in your Azure portal and type Synapse into the search field. From the quick results, you can now already select Synapse Analytics or you hit Enter and select Synapse Analytics from the search results. On the Overview blade, hit Create and start provisioning.
2. On the following Basics blade, fill in the corresponding fields. You need to select the subscription where you want to create your environment. In the Resource Group field, either select an existing one or create a new one.
3. In the Managed Resource Group field, add...