Question about Azure Dedicated SQL Pool and Azure SQL Database

Question

I have a couple of questions that came up while going through the Microsoft Documents on Azure Dedicated SQL Pool:

1. Unlink Azure SQL Database - Single Database, there is no way to fine-tune zone redundancy or set up replica. Is this correct?
2. In terms of Azure Dedicated SQL Pool, the only High Availability related configuration I have is the failover group on the Azure SQL Server level, is this correct?
3. Why is zone redundancy configured on the database level? When I create a zone redundant database, doesn't the database server needs to be zone redundant as well?
4. Follow up on question 3, it's also possible for me to configure a zone redundant database and a non-zone redundant database and have them on the same SQL server, how does it work?
5. Is the relationship between Azure SQL Server and Azure SQL Database different compare to if I installed MSSQL locally? i.e. I install an MSSQL server instance, and I can create a database within this server.

I am having some trouble building up the mental model of how these works, please help! Thanks in advance!

Answer 1

Hi @Jeff Lu Thank you for posting your question on Microsoft Q&A.

1. Unlink Azure SQL Database - Single Database, there is no way to fine-tune zone redundancy or set up replica. Is this correct?
Yes, with Azure dedicated pool you can enabled geo-back up option to protect your data once a day to a paired data center.

2. In terms of Azure Dedicated SQL Pool, the only High Availability related configuration I have is the failover group on the Azure SQL Server level, is this correct?
yes, that is correct the only high availability related availability related configuration is failover you can enable it from the server level to automatically manage replication , connectivity and failover for a set of databases.

3. Why is zone redundancy configured on the database level? When I create a zone redundant database, doesn't the database server needs to be zone redundant as well?
yes the zone redundancy is created on the database level and the server will also be zone redundant.

it's also possible for me to configure a zone redundant database and a non-zone redundant database and have them on the same SQL server, how does it work?
Yes, you can enable zone redundant and no-redundant for databases on the same server.

*Is the relationship between Azure SQL Server and Azure SQL Database different compare to if I installed MSSQL locally? i.e. I install an MSSQL server instance, and I can create a database within this server.*c
Could you please clarify a bit more. Not really understanding the question.

Regards,
Oury

Answer 2

Is the relationship between Azure SQL Server and Azure SQL Database different compare to if I installed MSSQL locally? i.e. I install an MSSQL server instance, and I can create a database within this server.

Yes, as I understand it is different. When you install MS SQL Server locallly, the database are on that same machine and connected to that instance.

In Azure this is decoupled, and the server is only a logical concept. The databases on your "server" can be on different physical machines. You can understand that this is required to permit you to scale individual databases up and down. This is also required to permit for serverless databases which are attached when you need them, and I guess they are attached where there is capacity at the moment.

This is also why you cannot do cross-database queries in Azure SQL Database, and nor can you move between databases.

Answer 3

 "error": {
        "code": "FailoverGroupUnableToPerformGroupOperationOnDatabases",
        "message": "The operation cannot be performed due to multiple errors.",
        "details": [
            {
                "code": "40822",
                "message": "This feature is not available for the selected database's edition (DataWarehouse)."
            }
        ]
    }