SQL Server 2016: Provision a Database

Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service.

Introduction

• Welcome
• Using the exercise files
• What you should know

1. Deploy Microsoft Azure SQL Database

• Create servers and databases
• Choose a service tier
• Create a server admin account
• Configure elastic pools

2. Plan for a SQL Server Installation

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

3. SQL Server Instances

• Provision an Azure VM
• Storage layouts for a SQL Server VM
• Install SQL Server on an Azure VM
• Automate the deployment of SQL Server
• Deploy SQL Server using templates

4. Configure Secure Access to Azure SQL Databases

• Configure firewall rules
• Enable transparent data encryption
• Enable Always Encrypted
• Configure dynamic data masking

5. Configure SQL Performance Settings

• SQL database performance settings
• Configure max server memory
• Configure the database scope
• Create operators and alerts

6. Manage SQL Server Instances

• Create databases
• Install Management Studio
• Manage user database files
• Manage system database files
• Configure tempdb

7. Deploy Applications to Azure SQL Database

• Support multiple tenants
• Migrate SQL Server to Azure SQL Database
• Migrate data to Azure SQL Database

8. Deploy Applications to SQL Server on Azure VMs

• Migrate SQL Server databases to Azure VM
• Generate benchmark data
• Support availability sets in Azure

9. Migrate Client Applications

• Configure application connection strings
• Manage traffic
• Application retry logic

Conclusion

• Next steps