Deploying a Database on Azure SQL

Exploring Azure Database Services

Figure 1: Landing Page on Azure
Figure 2: Database Services on Azure
  1. Azure SQL. It is Microsoft’s platform as a service for SQL Server. It compares to Amazon’s Relational Database Service, but it is 3.6 times faster and 86% cheaper as the providers claim. This option allows you to create either an SQL Database or an SQL Database Server. You can consider Azure SQL as a “mother” for both SQL Server and SQL Database in the cloud.
  2. SQL Server (also known as an Azure SQL Database Server). This option allows you to create an SQL Server right away. Using on-premise terminology, it is an instance, a logical container for SQL Databases. Note that it is not a physical entity, and it may not map to a virtual machine.
  3. SQL Database. This option allows you to create a single database. When you make your first database with this route, you must also produce your first SQL Server. If you already have existing servers, select that one where you want to deploy your new database.
  1. Azure SQL. It is Microsoft’s platform as a service for SQL Server. It compares to Amazon’s Relational Database Service, but it is 3.6 times faster and 86% cheaper as the providers claim. This option allows you to create either an SQL Database or an SQL Database Server. You can consider Azure SQL as a “mother” for both SQL Server and SQL Database in the cloud.
  2. SQL Server (also known as an Azure SQL Database Server). This option allows you to create an SQL Server right away. Using on-premise terminology, it is an instance, a logical container for SQL Databases. Note that it is not a physical entity, and it may not map to a virtual machine.
  3. SQL Database. This option allows you to create a single database. When you make your first database with this route, you must also produce your first SQL Server. If you already have existing servers, select that one where you want to deploy your new database.

Creating Your First Database

Figure 3: Create a SQL Database
Figure 4: Database Options
Figure 5: Networking Options
Figure 6: Additional Settings
Figure 7: Review Settings
Figure 8: Deployment Progress
Figure 9: Logistics Database

Reviewing the SQL Server Using Management Studio

Figure 10: Logging on to the Server
Figure 11: Configuring Firewall Rules
Figure 12: New Firewall Rule
Figure 13: Using Management Studio

Conclusion

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
{coding}Sight

{coding}Sight

Awesome blog focused on databases and Microsoft, .NET and cloud technologies. http://codingsight.com/