Microsoft Azure Essentials Migrating SQL Server Databases to Azure

Description

Part of the Microsoft Azure Essentials series, this ebook helps SQL Server database users understand Microsoft s offering for SQL Server in Azure. Learn how SQL Server in Azure is similar to SQL Server in an on-premises environment, and how they are different. The author, a content lead for Azure.com, walks you through the steps of getting started with SQL Server in an Azure virtual machine and with Azure SQL Database. Follow the numerous screenshots to 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." Cover Copyright Microsoft Press Store Contents Introduction Who should read this ebook Assumptions Conventions and features in this ebook Acknowledgments Errata, updates, & ebook support Free ebooks from Microsoft Press We want to hear from you Stay in touch Chapter 1: Overview of SQL Server in Microsoft Azure Overview of SQL Server in Microsoft Azure What do I need to know about Azure? An overview of Azure services Subscribing to Azure services Paying for Azure services What are the Azure deployment models? Using the Azure portal Getting started with Azure PowerShell Getting started with the Azure Command-Line Interface What is Azure storage? What are Azure virtual machines? What is SQL Server in an Azure virtual machine (IaaS)? What is Azure SQL Database (PaaS)? When to use SQL Server in a VM (IaaS) and when to use Azure SQL Database (PaaS) Lab: Create an Azure subscription and connect to Azure portal Create an Azure trial subscription Connect to the Azure portal with your Azure trial subscription using your browser Install Azure PowerShell 1.0 Connect to Azure using PowerShell Chapter 2: Getting started with SQL Server in an Azure virtual machine Overview of an Azure virtual machine Selecting a deployment model Defining a resource group within an Azure region Defining storage resources Defining network resources Defining compute resources Additional configuration options Configuring diagnostics Configuring an availability set Provisioning the virtual machine with the Windows operating system and SQL Server Configuring SQL Server in the virtual machine Configuring SQL Server storage Configuring data and log disk storage Configuring TempDB and Buffer Pool Extensions Configuring authentication for SQL Server Configuring connectivity to your Azure virtual machine Selecting a provisioning method Walk-through: Getting started with SQL Server in an Azure virtual machine Provisioning a SQL Server virtual machine using the Azure portal Viewing and configuring your virtual machine in the Azure portal Connecting to your virtual machine Connecting to SQL Server within the virtual machine Connecting to SQL Server in your virtual machine from another computer Conclusion Microsoft Press Newsletters Chapter 3: Getting started with an Azure SQL Database Overview of SQL Database Service tiers Service tiers and performance levels DTU resource limits Other resource limits Service tiers and capabilities Business continuity services Automatic database backup and self-service geo-restore services Active geo-replication In-memory services SQL Database logical server Firewall rules Server-level firewall rules Database-level firewall rules Walk-through: Getting started with an Azure SQL Database Provisioning a SQL Database logical server and database using the Azure portal Viewing and configuring your SQL Database in the portal Connecting to your SQL Database using SQL Server Management Studio Conclusion Chapter 4: Migrating a database to Azure Overview of migrating a user database to Azure Managing breaking changes between SQL Server versions Migrating and managing metadata stored outside a user database Migrating a SQL Server user database to a SQL Server instance in an Azure virtual machine Migrating using full database backup for simplicity Migrating using full database and transaction log backups to minimize downtime Migrating a SQL Server user database to an Azure SQL Database Determining and resolving Azure SQL Database V12 compatibility issues Migrating a compatible SQL Server database to SQL Database Using transactional replication to migrate a SQL Server user database to SQL Server in an Azure virtual machine or to Azure SQL Database Migrating a non–SQL Server user database to SQL Server in an Azure virtual machine or an Azure SQL Database Walk-through: Migrating a SQL Server database to SQL Server in an Azure virtual machine using SQL Server backup and restore Backing up a SQL Server 2008 R2 user database to local storage Copying the backup file from local storage to Azure blob storage Copying the backup file from Azure blob storage to the Azure virtual machine Restoring the SQL Server 2008 R2 user database backup to SQL Server 2016 in an Azure virtual machine Walk-through: Migrating a SQL Server database to SQL Database using a BACPAC file Using the Deploy Database to Azure SQL Database Wizard to migrate a user database to SQL Database Conclusion Survey Chapter 5: Authentication, authorization, and data resiliency Securing connections Configuring and securing connections to SQL Server in an Azure virtual machine Configuring and securing connections to Azure SQL Database User authentication User authentication with SQL Server in an Azure virtual machine User authentication using mixed mode User authentication using Windows Authentication mode User authentication with Azure SQL Database User authentication using SQL Server Authentication User authentication using Azure Active Directory authentication Contained users User authorization User authorization with SQL Server in an Azure virtual machine Server-level permissions Database-level permissions User authorization with Azure SQL Database Azure Role-Based Access Control Master database–level permissions Database-level permissions Database backups and restores Database backups with SQL Server in an Azure virtual machine SQL Server backup to URL SQL Server Managed Backup to Windows Azure File-snapshot backups Database backups with Azure SQL Database Data archiving Data archiving with SQL Server in an Azure virtual machine Data archiving with Azure SQL Database Walk-through: Configuring authentication and authorization with Azure SQL Database Creating a login and a user Creating a contained user Granting server-level permissions to users Walk-through: Creating a database copy using automated backups Using automated backups to create a database copy Walk-through: Restoring a database copy using automated backups Using automated backups to restore a database to a point in time Creating an archive Conclusion About the author Free ebooks at Microsoft Virtual Academy