Contents
Quick access to online references
Errata, updates, & book support
Important: How to use this book to study for the exam
Chapter 1 Implement SQL in Azure
Skill 1:1: Deploy a Microsoft Azure SQL Database
Skill 1:2: Plan for SQL Server installation
Plan for an IaaS or on-premises SQL Server deployment
Select the appropriate size for a virtual machine
Plan storage pools based on performance requirements
Evaluate best practices for installation
Design a storage layout for a SQL Server virtual machine
Skill 1:3: Deploy SQL Server instances
Deploy a SQL Server instance in IaaS and on-premises
Manually install SQL Server on an Azure Virtual Machine
Provision an Azure Virtual Machine to host a SQL Server instance
Automate the deployment of SQL Server Databases
Deploy SQL Server by using templates
Skill 1:4: Deploy SQL Server databases to Azure virtual machines
Migrate an on-premises SQL Server Database to an
Azure virtual machine
Generate benchmark data for performance needs
Perform performance tuning on Azure IaaS
Support availability sets in Azure
Chapter 2 Manage databases and instances
Skill 2.1: Configure secure access to Microsoft Azure SQL databases
Configure Always Encrypted for Azure SQL Database
Configure Dynamic Data Masking
Configure Transparent Data Encryption
Skill 2.2: Configure SQL Server performance settings
Configure database performance settings
Configure operators and alerts
Skill 2.3: Manage SQL Server instances
Skill 3.2: Perform database maintenance
Recover from database corruption
What do you think of this book? We want to hear from you!
Microsoft is interested in hearing your feedback so we can continually improve our
books and learning resources for you. To participate in a brief online survey, please visit: