The article describes how to create an SQL Server in Azure and deploy a small database using a free tier subscription and basic resources.
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.
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:
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.
In this article, we will discuss how to migrate an on-premises SQL Server database to Microsoft Azure SQL Database.
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.
This article covers real-time issues and use cases of migration tasks for SQL Server to Azure cloud database with ADMS.
Understanding various SQL Server system databases and their roles is an excellent aid for managing your SQL Server instance.