Create a Dedicated SQL Pool in Azure

An Azure Synapse Dedicated SQL Pool (previously known as Azure SQL Data Warehouse), is a massively parallel processing database. It is a Big Data solution that stores information in a relational table format with columnar storage. It also uses a Massive Parallel Processing (MPP) architecture to leverage up to 60 nodes to run queries. Once you have your data in a Dedicated SQL Pool you can leverage this for historical analysis from a dashboard, use it as a dataset for Machine Learning, and any other data goals you might have for a massive dataset.

In this database development tutorial, we will explain the step-by-step process used to create a dedicated SQL Pool in Microsoft’s Azure Synapse Analytics.

How to Create a Dedicated SQL Pool

To start, we want to create a dedicated SQL Pool in Azure. Log into the Azure Portal with your free or paid subscription. Then click on Create a Resource.

Create a new Azure Resource

Next, in the Search Bar of Azure Portal, type Dedicated SQL Pool.

Azure Portal Search

Azure Dedicated SQL Pool

Choose Dedicated SQL Pool (Formerly SQL DW) and create a new Dedicated SQL Pool by clicking on the Create button.

Create a Dedicated SQL Pool

Next, we need to either create a new Resource Group or select an existing one.

How to Create a Dedicated Resource Group in Azure

Enter the name of the new Resource Group and click Ok.

Azure Resource Group Name

Now, fill in the basic details of the Dedicated SQL Pool.

Details of Dedicated SQL Pool in Azure

Read: How to Migrate On-premise SQL Database to Azure

How to Create a New SQL Server in Azure

At this point, a new SQL Server needs to be created If you do not have a server setup already. If you do, you can skip this part. To create the new SQL Server, click on Create New and enter the Server Name and Location. If you already have an SQL Server, you can enter that information here.

Create SQL Server in Azure

Next, for now, you can simply use SQL Authentication. Enter in your Server Admin Login details and a secure password. Once finish, click OK.

SQL Server Authentication in Azure

Now, after you have entered the SQL Pool details with your SQL Pool Name and set the server, you also need to choose your performance level – choose wisely, as per your project needs.

Dedicated Pool Performance in Azure

Select the Performance Level and you will be prompted with a new Configuration option.

Dedicated Pool Performance Level Options in Azure

In the Performance Level screen, you can scale your system per your performance and storage scalability needs. Once set, click on Apply.

Configure Performance Options in Azure for Dedicated Pools

Next, click on the Networking tab. Select the appropriate options and then click on the Additional Settings tab.

Dedicated Pool Networking Options

Make sure you choose the Sample under the Use Existing Data section, which will create a sample database named AdventureWorksDW.

Azure Dedicated Pools tutorial

Then, click on Review + Create. Finally, click on Create to initiate the deployment process.

Dedicated Pool Deployment in Azure

A notification will pop on the screen as the deployment is in progress; you can see the resources that will be created in real-time.

Azure Dedicated Pool example

During deployment, you can also click on the Operation Details to learn about the operation which contains data from Operation ID, Timestamp, Duration, and more.

Dedicated Pool Operation Details

 

Once the deployment is complete, you will be provided with a Go to Resource link.

Dedicated Pools in Azure

In the Resource Overview section, you can learn more about the Resource Sample Pool that was created. The server’s name, connection strings, and performance levels are all detailed here. Developers can also check out the metrics visualization of the DWU Usage that we just created.

Dedicated Pools in Azure details and overview

Read more database programming and database administration tutorials.

More by Author

Must Read