Introduction |
|
ix | |
Organization of this book |
|
x | |
Microsoft certifications |
|
x | |
Acknowledgments |
|
x | |
Microsoft Virtual Academy |
|
xi | |
Quick access to online references |
|
xi | |
Errata, updates, & book support |
|
xi | |
We want to hear from you |
|
xii | |
Stay in touch |
|
xii | |
Important: How to use this book to study for the exam |
|
xiii | |
|
Chapter 1 Implement SQL in Azure |
|
|
1 | (94) |
|
Skill 1:1 Deploy a Microsoft Azure SQL Database |
|
|
1 | (30) |
|
|
2 | (10) |
|
Create servers and databases |
|
|
12 | (10) |
|
Create a sysadmin account |
|
|
22 | (3) |
|
|
25 | (6) |
|
Skill 1:2 Plan for SQL Server installation |
|
|
31 | (28) |
|
Plan for an IaaS or on-premises SQL Server deployment |
|
|
31 | (10) |
|
Select the appropriate size for a virtual machine |
|
|
41 | (6) |
|
Plan storage pools based on performance requirements |
|
|
47 | (8) |
|
Evaluate best practices for installation |
|
|
55 | (2) |
|
Design a storage layout for a SQL Server virtual machine |
|
|
57 | (2) |
|
Skill 1:3 Deploy SQL Server instances |
|
|
59 | (22) |
|
Deploy a SQL Server instance in IaaS and on-premises |
|
|
59 | (4) |
|
Manually install SQL Server on an Azure Virtual Machine |
|
|
63 | (5) |
|
Provision an Azure Virtual Machine to host a SQL Server instance |
|
|
68 | (4) |
|
Automate the deployment of SQL Server Databases |
|
|
72 | (4) |
|
Deploy SQL Server by using templates |
|
|
76 | (5) |
|
Skill 1:4 Deploy SQL Server databases to Azure virtual machines |
|
|
81 | (14) |
|
Migrate an on-premises SQL Server Database to an Azure virtual machine |
|
|
81 | (6) |
|
Generate benchmark data for performance needs |
|
|
87 | (2) |
|
Perform performance tuning on Azure IaaS |
|
|
89 | (2) |
|
Support availability sets in Azure |
|
|
91 | (1) |
|
|
92 | (1) |
|
Thought experiment answers |
|
|
92 | (1) |
|
|
93 | (2) |
|
Chapter 2 Manage databases and instances |
|
|
95 | (94) |
|
Skill 2.1 Configure secure access to Microsoft Azure SQL databases |
|
|
95 | (44) |
|
|
96 | (10) |
|
Configure Always Encrypted for Azure SQL Database |
|
|
106 | (21) |
|
Configure Dynamic Data Masking |
|
|
127 | (8) |
|
Configure Transparent Data Encryption |
|
|
135 | (4) |
|
Skill 2.2 Configure SQL Server performance settings |
|
|
139 | (32) |
|
Configure database performance settings |
|
|
140 | (14) |
|
Configure max server memory |
|
|
154 | (3) |
|
Configure the database scope |
|
|
157 | (6) |
|
Configure operators and alerts |
|
|
163 | (8) |
|
Skill 2.3 Manage SQL Server instances |
|
|
171 | (18) |
|
Manage files and filegroups |
|
|
171 | (6) |
|
|
177 | (4) |
|
Manage system database files |
|
|
181 | (2) |
|
|
183 | (3) |
|
|
186 | (1) |
|
Thought experiment answers |
|
|
187 | (1) |
|
|
187 | (2) |
|
|
189 | (88) |
|
Skill 3.1 Manage SQL Storage |
|
|
189 | (52) |
|
|
190 | (5) |
|
|
195 | (12) |
|
|
207 | (11) |
|
|
218 | (5) |
|
|
223 | (4) |
|
|
227 | (11) |
|
Recover from failed storage |
|
|
238 | (3) |
|
Skill 3.2 Perform database maintenance |
|
|
241 | (36) |
|
|
241 | (8) |
|
|
249 | (9) |
|
Automate maintenance tasks |
|
|
258 | (5) |
|
|
263 | (3) |
|
Verify database integrity |
|
|
266 | (3) |
|
Recover from database corruption |
|
|
269 | (4) |
|
|
273 | (1) |
|
Thought experiment answers |
|
|
273 | (1) |
|
|
274 | (3) |
Index |
|
277 | |