SQL Server is Microsoft’s relational database management system (RDBMS). SQL Server can now be hosted entirely in Microsoft Azure, either in a hosted virtual machine (VM) or as a hosted service. Hosting a virtual machine in Azure is known as infrastructure as a service (IaaS), and hosting a service in Azure is known as platform as a service (PaaS). Microsoft’s hosted version of SQL Server is known as Azure SQL Database or just SQL Database that is optimized for software as a service (SaaS) app development.

This ebook, Microsoft Azure Essentials Migrating SQL Server Databases to Azure, introduces you to SQL Server in an Azure virtual machine and to Azure SQL Database, and walks you through getting started with each approach. It takes you from creating a SQL Server instance in a virtual machine or as a platform service to migrating an on-premises database into Azure and then to securing the data and the database in Azure.

Beyond the explanatory content, each chapter includes one or more walk-throughs with extensive screenshots so you can follow along and create a trial subscription, create SQL Server in an Azure virtual machine, create an Azure SQL Database, migrate an on-premises database to each Azure environment, create users, back up and restore data, and archive data.

Who should read this ebook

This ebook exists to help existing SQL Server database users understand Microsoft’s offering for SQL Server in Azure. It is designed to help you quickly start using the skillset you already have with SQL Server and to introduce you to Microsoft Azure. It is not intended as a deep dive into Azure itself or into virtual machines. Its focus is SQL Server itself and helping you understand how SQL Server in Azure is similar to SQL Server in an on-premises environment and where it is different. Its focus is also to distinguish the two Azure offerings from each other. A discussion of the Azure SQL Data Warehouse is beyond the scope of this ebook.

Carl Rabeler

Carl Rabeler is currently the content lead for SQL Database solution content on Azure.com. Carl is the author of multiple books and SQL CAT white papers, as well as various current MSDN and Azure.com articles on SQL Database and SQL Server 2016. He has been working with SQL Server since SQL Server 6.5 and with Microsoft Hyper-V and virtualization of SQL Server since Windows Server 2008. He has also been working with the Microsoft Azure cloud and SQL Database since its inception. In addition, Carl has been a speaker at multiple SQL PASS conferences and SQL Saturday events.