Deploying a Database on Azure SQL – {coding}Sight

Deploying a Database on Azure SQL – {coding}Sight

The article describes how to create an SQL Server in Azure and deploy a small database using a free tier subscription and basic resources.

Introduction

Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure. Hence, you need the Azure subscription to use this SQL Database. Azure offers new subscribers a free subscription and $200 worth of resources for 30 days. Recently I revived my relationship with MS Azure and explored the platform a little bit, using the Warner Chaves’ PluralSight Azure SQL Database for SQL Server DBAs training for the start.

In this article, I will explore the steps required to create an SQL Server in Azure and deploy a small database. Here I am using a free tier subscription, and the resources are on the basic level. Further, I’ll explain these terms.

Exploring Azure Database Services

The landing page on Azure looks similar to Figure 1. Typically, you may not see all services offered on Azure on the first page. For that, click More Services > All Services (Figure 2).

Figure 1: Landing Page on Azure

Figure 2: Database Services on Azure

Microsoft has an impressive list of services broken down into separate sections. The Database section is in Figure 2. Three options for databases might initially confuse new subscribers. I’ll explain them below:

  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.

programming sql server azure sql database administration microsoft azure sql server

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Migrating SQL workloads to Microsoft Azure: Databases Trip to Azure SQL Database

In this article, we will discuss how to migrate an on-premises SQL Server database to Microsoft Azure SQL Database.

SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master

This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below.

Deploying the first SQL to Azure Migration project with Azure Database Migration Service

This article covers real-time issues and use cases of migration tasks for SQL Server to Azure cloud database with ADMS.

SQL Server System Databases - Basic Concepts

Understanding various SQL Server system databases and their roles is an excellent aid for managing your SQL Server instance.