Microsoft’s SQL Server, a relational database management system (RDBMS), can now be fully hosted on Microsoft Azure, either within a virtual machine (VM) or as a service. When hosted in Azure as a virtual machine, it operates under the infrastructure as a service (IaaS) model, while as a hosted service, it falls under platform as a service (PaaS). Azure offers a hosted version of SQL Server known as Azure SQL Database, optimized for software as a service (SaaS) application development.
The ebook “Microsoft Azure Essentials: Migrating SQL Server Databases to Azure” introduces both SQL Server in an Azure VM and Azure SQL Database. It guides you through setting up each environment, from creating SQL Server instances in VMs or as platform services to migrating on-premises databases into Azure. The book covers securing data and databases within Azure.
Each chapter includes practical walk-throughs with detailed screenshots. These guides help you create trial subscriptions, deploy SQL Server in an Azure VM, set up Azure SQL Database, migrate on-premises databases, manage users, perform data backups and restores, and handle data archiving.
Chapter 1
Overview of SQL Server in Microsoft Azure
Chapter 2
Getting started with SQL Server in an Azure virtual machine
Chapter 3
Getting started with an Azure SQL Database
Chapter 4
Migrating a database to Azure
Chapter 5
Authentication, authorization, and data resiliency
This open book is licensed under the Microsoft Open License and is available for free download in PDF format (12.5 MB).