Microsoft Azure Essentials Migrating SQL Server Databases to Azure

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