Overview
-
Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- What you should know
- Create servers and databases
- Choose a service tier
- Create a server admin account
- Configure elastic pools
- Plan for an IaaS or on-premises deployment
- Size a virtual machine
- Performance-based storage pools
- Evaluate best practices for installation
- 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
- Configure firewall rules
- Enable transparent data encryption
- Enable Always Encrypted
- Configure dynamic data masking
- SQL database performance settings
- Configure max server memory
- Configure the database scope
- Create operators and alerts
- Create databases
- Install Management Studio
- Manage user database files
- Manage system database files
- Configure tempdb
- Support multiple tenants
- Migrate SQL Server to Azure SQL Database
- Migrate data to Azure SQL Database
- Migrate SQL Server databases to Azure VM
- Generate benchmark data
- Support availability sets in Azure
- Configure application connection strings
- Manage traffic
- Application retry logic
- Next steps
