Category: Azure Database

AS we now Azure SQL Single database is one from deployment Azure Database models if you need to know more information check this post-Azure Database Deployment model options today I am writing about Fundamental information for Azure Single Database

For More Azure Database Articles Check this Link and If you are Preparing for AZ-103 Azure Administrator Certification check this Article

1. The Single Database deployment option creates a single isolated database in Azure SQL Database
2. Azure Single Database Support DTU-based and Vcore-based Purchased Model
3. The internal of SQL Database server is hidden from the end-user and all are managed by Microsoft Azure
4. Azure Single Database has it is own Resources (DTU or V-Core) and this resource will not be shared with other databases in the same single instance. Each Database has dedicated resources.
5. Single Database Isolated meaning if you created two single databases on the same single database server each Database has dedicated resources and the two databases cannot be communicated together and I think this one is a security feature
6. This means Azure Single Database is the best option for small workloads with applications connects to one DB.
7. To Provision Azure SQL Single Database, you need (resource Group, Database name, Server Name, User Name, Password, Location, deployment option either single or elastic pool, Compute Storage and purchase model either DTU-based or vCore-based)
8. In Azure SQL Single database provisioning you can create new or select existing one from (Resource group and Server name)
9. In Azure SQL Single database provisioning the (resource Group, Database name, Server Name) Should be a unique name.