SQL Server 2016: Provision a Database

Course details

Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service. In this course, Adam Wilbert reviews several ways of getting a SQL database up and running, helping you see the benefits and trade-offs of each option. He begins by explaining how to get started with Azure SQL Database, demonstrating how to deploy a database and choose the right service tier for you. He also shows how to deploy a virtual Windows Server machine, and migrate on-premises SQL Server databases to a SQL Server instance hosted on an Azure virtual machine.

This course is also ideal for anybody preparing for the Provisioning SQL Databases (70-765) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.

Learning objectives
Deploying a Microsoft Azure SQL Database
Planning for a SQL Server installation
Planning for an IaaS or on-premises deployment
Evaluating best practices for installation
Provisioning an Azure virtual machine
Deploying SQL Server using templates
Managing SQL Server instances
Migrating SQL Server databases to Azure VM
Migrating client applications

Concepts

0. Introduction

01 - Welcome
02 - Using the exercise files
03 - What you should know

1. Deploy Microsoft Azure SQL Database

04 - Create servers and databases
05 - Choose a service tier
06 - Create a server admin account
07 - Configure elastic pools

2. Plan for a SQL Server Installation

08 - Plan for an IaaS or on-premises deployment
09 - Size a virtual machine
10 - Performance-based storage pools
11 - Evaluate best practices for installation

3. SQL Server Instances

12 - Provision an Azure VM
13 - Storage layouts for a SQL Server VM
14 - Install SQL Server on an Azure VM
15 - Automate the deployment of SQL Server
16 - Deploy SQL Server using templates

4. Configure Secure Access to Azure SQL Databases

17 - Configure firewall rules
18 - Enable transparent data encryption
19 - Enable Always Encrypted
20 - Configure dynamic data masking

5. Configure SQL Performance Settings

21 - SQL database performance settings
22 - Configure max server memory
23 - Configure the database scope
24 - Create operators and alerts

6. Manage SQL Server Instances

25 - Create databases
26 - Install Management Studio
27 - Manage user database files
28 - Manage system database files
29 - Configure tempdb

7. Deploy Applications to Azure SQL Database

30 - Support multiple tenants
31 - Migrate SQL Server to Azure SQL Database
32 - Migrate data to Azure SQL Database

8. Deploy Applications to SQL Server on Azure VMs

33 - Migrate SQL Server databases to Azure VM
34 - Generate benchmark data
35 - Support availability sets in Azure

9. Migrate Client Applications

36 - Configure application connection strings
37 - Manage traffic
38 - Application retry logic

Conclusion

39 - Next steps