Questions tagged [dedicated-sql-pool]

The tag has no usage guidance.

3 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
1 answer
122 views

Azure Dedicated SQL Pool - How to checksum a table?

We're moving all our on premise tables into the azure dedicated sql pool. We're using synapse workspace pipelines to import the data into the dedicated pool. Is there a way to checksum a table to ...
xmlapi's user avatar
  • 11
0 votes
1 answer
214 views

Hash, Replication, and Round Robin Distributions - Need more clarification

I will give a few examples of the tables we have: Table1 - Most queries are State Code and Year, has about 1000 rows, will grow by 1000 rows a year, used Round Robin Table2 - Most queries are by ...
xmlapi's user avatar
  • 11
0 votes
1 answer
350 views

Azure Dedicated SQL pool - group has db_datareader access but cannot login

We have created Test AD Group and they should have readonly access to the database (schemas and tables, views) in the Azure SQL dedicated pool. Our DBA team did it but the users in the Test AD Group ...
xmlapi's user avatar
  • 11