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."
Author(s): Carl Rabeler
Publisher: Microsoft Press
Year: 2016
Language: English
Pages: 160
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
