Azure SQL provides a relational database hosted as a PaaS. Customers can provision this service, bring their own database schema and data, and connect their applications to it. It provides all the features of SQL Server that you get when deploying on a virtual machine. These services do not provide a user interface to create tables and its schema, nor do they provide any querying capabilities directly. You should be using SQL Server Management Studio and the SQL CLI tools to connect to these services and directly work with them.
Azure SQL Database comes with three distinct deployment models:
- Single instance: In this deployment model, a single database is deployed on a logical server. This involves the creation of two resources on Azure:
- SQL logical server
- SQL database
- Elastic pool: In this deployment mode, multiple databases are deployed on a logical server...
