Creating a dedicated SQL pool without a Synapse workspace

Question

Creating a dedicated SQL pool without a Synapse workspace

pmscorca 1,052

Hi,

I've always created a dedicated SQL pool after the related Synapse workspace, but it seems that it is possible to create a SQL pool without any Synapse workspaces.

Why and when is it proper creating a dedicated SQL pool without a Synapse workspace?

Thanks

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-12-13T02:43:29.03+00:00

@pmscorca - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

2 answers

Your answer

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-12-13T02:43:29.03+00:00

@pmscorca - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

They both are the same thing. Either you can first create a Dedicated SQL pool and link it with Synapse Workspace, or you can first create the Synapse Workspace and then dedicated pool inside it.

The below link provides details about the same :

https://azureaggregator.wordpress.com/2022/08/26/whats-the-difference-between-azure-synapse-formerly-sql-dw-and-azure-synapse-analytics-workspace/

In simple terms in case if you just need a dedicated pool and no other components present within the workspace, you can create the standalone dedicated pool

pmscorca 1,052 Reputation points

2023-12-05T17:33:26.7466667+00:00

Hi,

could I create a dedicated SQL pool without never creating a Synapse workspace?

Respect to a Managed workspace Virtual Network scenario, first could I create a dedicated SQL pool and then could I create the Managed workspace Virtual Network?

Answer 2

@pmscorca - Thanks for the question and using MS Q&A platform.

Yes, it is possible to create a dedicated SQL pool without a Synapse workspace. This is useful when you want to create a dedicated SQL pool that is not associated with any Synapse workspace.

For example, you may want to create a dedicated SQL pool for a specific project or application that does not require a Synapse workspace. In this case, you can create a dedicated SQL pool without a Synapse workspace.

However, keep in mind that if you create a dedicated SQL pool without a Synapse workspace, you will not be able to use some of the features that are available in Synapse Studio, such as the ability to create and manage pipelines, notebooks, and data flows.

Also, note that you will need to have the necessary permissions to create a dedicated SQL pool. If you do not have the required permissions, you will not be able to create a dedicated SQL pool.

For more details, refer to Quickstart: Create and query a dedicated SQL pool (formerly SQL DW) in Azure synapse Analytics using the Azure portal. **Note:**This quickstart helps you to create a dedicated SQL pool (formerly SQL DW).

To create a dedicated SQL pool in Azure Synapse Analytics workspace and take advantage of the latest features and integration in your Azure Synapse Analytics workspace, instead use Quickstart: Create a dedicated SQL pool using Synapse Studio.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

pmscorca 1,052 Reputation points

2023-12-06T11:27:21.1233333+00:00

Ok, but respect to a Managed workspace Virtual Network scenario, first could I create a dedicated SQL pool and then could I create the Managed workspace Virtual Network?
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-12-08T05:01:24.6266667+00:00

@pmscorca - With respect to managed workspace virtual network scenario, you need to create synapse workspace with Managed workspace Virtual Network and then create dedicated SQL pool from the synapse studio or Azure Portal.

For more details, refer to Azure Synapse Analytics Managed Virtual Network.

Hope this helps. Do let us know if you any further queries.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-12-15T09:15:07.8066667+00:00

@pmscorca - Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Creating a dedicated SQL pool without a Synapse workspace

2 answers

Your answer