About
All major keywords used in this book are captured alphabetically in this section. Each one is accompanied by the page number of where they appear.
A
activate: 64
advantage: 5, 30, 68, 89, 117, 119, 122, 130, 144, 165
allocate: 69, 116
auditing: 14, 88-89
automation: 3, 5, 73, 83, 98-99, 129, 135
B
back-end: 62, 96
backup: 5, 30, 58, 64, 70, 84, 107, 134, 136-139, 141-143, 153-157, 159-161, 165
balancer: 58, 60, 62, 80, 107
bandwidth: 66-67, 69, 73, 116
bitlocker: 88
blobcache: 113, 121-122
blocksize: 70, 160
C
caches: 114
checkdb: 155
clustering: 61-62
cmdlets: 155, 159
compute: 8, 59, 67-68, 102, 114, 117-118, 135, 158
configure: 6-7, 17-19, 21, 34, 36-40, 46, 49, 58, 62, 64, 69, 78, 80-81, 86, 115, 121, 125, 133, 140, 142-143, 159
container: 4, 8, 15, 101-107, 159
-cores: 119
D
dashboard: 73, 141
databases: 3, 5-6, 8, 15, 49, 53, 59, 68, 70, 72, 78, 82, 101, 114, 127, 129, 131, 134, 138-143, 148, 150, 155-156, 159-162, 165-166
datacenter: 7, 17, 55-57, 79, 101, 154
dbatools: 130, 135
deployment: 4, 6, 30-31, 40, 53, 56, 64, 98-100, 102, 105-107, 114, 118, 137, 145-149
devops: 31, 98, 102
django: 96
docker: 4, 15, 98, 101, 104
domain: 30, 81, 142
downtime: 43-44, 55, 129, 134, 139, 161, 165
E
encrypted: 14, 81, 84, 86-88, 132
enterprise: 6, 15-16, 32, 36, 38, 40-41, 67, 86, 100-103, 106-107, 117, 137, 154, 158
F
failover: 12, 14, 36, 58, 61-62, 107, 157-158, 163, 166
filegroup: 72
filestream: 20
filesystem: 101, 121
filetable: 20
firewall: 80, 162
framework: 12, 94-96
G
gateway: 18, 80
github: 97
groups: 7, 14, 17, 30, 44, 57-63, 75, 78-79, 101, 134, 145, 154, 160-161, 165-166
H
hadoop: 11
hybrid: 13, 17, 30, 40-41, 64, 77-78, 80, 107, 143, 147, 149-150, 153-154, 156-158, 160, 163-164, 167
hyperscale: 8
hyper-v: 167
hypervisor: 29, 44
I
iaas-based: 23, 30, 49
images: 15, 32-33, 36-37, 41, 67, 100-103, 106, 119, 121
indexes: 9, 14, 77, 117, 120
instance: 4, 6-9, 15-16, 18, 22-23, 30, 36-37, 43, 59, 102, 104, 106, 119-120, 126, 150, 160-161, 163, 165, 167
K
kerberos: 81
kubernetes: 4, 105-106
L
latchless: 77
latency: 57, 61, 68, 70, 115, 118, 120, 122, 143, 161, 163, 166
libraries: 94-95, 101
license: 18, 20, 23, 36, 40-41, 64, 114, 118, 154, 158
lifecycle: 145
logical: 45, 56, 116, 131, 141
M
machine: 6, 11-12, 15, 19, 35, 53, 86, 95, 115, 118, 135
memory: 13, 42-44, 46, 49, 67, 69-70, 86, 88, 107, 114-118, 121-122
method: 4-6, 22, 30-33, 53, 81, 116, 144, 155
microsoft: 2-3, 5, 7, 9, 11-12, 14-15, 17-19, 23, 29-32, 38-41, 43, 55, 62, 67, 69, 77, 94-99, 101, 103-104, 106, 118, 125, 128-130, 144-145, 149-150, 153-154, 156, 158-162, 164-167
models: 5, 12, 23, 41, 95, 137, 155
mssql-cli: 98
mssql-conf: 121
mystorage: 70
N
native: 137, 144, 148, 155
network: 2, 40, 44, 56-57, 61-62, 67, 73, 78-81, 89, 95, 102, 107, 114, 116, 138, 140, 160-163
nvarchar: 12
O
openshift: 106
optimize: 66-67, 108, 113, 117, 121
oracle: 11, 53
P
package: 7, 9, 101
password: 36, 81, 84, 104
patching: 2, 5, 30, 40, 64, 78, 106
persistent: 13, 104
pipelines: 98-99, 102, 149
platform: 1-6, 8-9, 11, 15, 18-19, 22-23, 31, 53-55, 94-95, 97-100, 102-103, 105-106, 108, 127, 129-130, 133, 137, 148-149
portal: 18, 31-35, 41, 48, 56, 62, 65-67, 72-73, 78-79, 99, 114-115, 141, 159
powershell: 31, 33, 62, 67, 98-99, 135-136, 138, 141, 155, 159, 161, 166
premises: 16, 29
procedure: 138
processing: 4, 7, 11-13, 57, 77, 88, 95, 117
profiling: 12
protocol: 79, 81
provider: 1, 5, 30, 36, 38-39, 54, 63, 66-67
python: 12, 15, 53, 94-95
R
read-only: 62-63, 66, 160, 162-163, 165
read-scale: 61, 63, 164
readwrite: 121
recovery: 13-14, 17, 30, 41, 55, 58-60, 62-64, 107, 126, 137, 145, 150, 153-160, 163, 166-167
region: 9, 32, 43, 55-59, 61, 88, 107, 159
replica: 41, 59-60, 62-64, 154, 159-161, 163-165, 167
repository: 149
rollback: 13, 157, 164
row-level: 14, 88
rowstore: 13-14
runbook: 73
runtime: 71, 96, 120, 149
S
scaling: 8, 107, 162
schedule: 7, 78, 159-161, 167
schemas: 133
scripts: 5, 53, 58, 84, 120, 135
security: 3, 6-8, 14, 30-31, 40, 49, 54, 62, 78-82, 84, 86, 88-89, 95, 107, 144, 148-149, 162
sequelize: 96
server: 1-23, 29-41, 43, 45, 48-49, 53-54, 57-84, 86-89, 93-108, 113-122, 125-128, 130-132, 134-135, 137-146, 148-150, 153-167
serverless: 8, 105-106
shipping: 59, 134, 139-141, 160, 165, 167
sqlcmd: 36, 98, 155
sqlserver: 32
storage: 3, 7, 9, 11, 16, 18-19, 23, 34, 42, 44-49, 55, 58-59, 62, 64-70, 72, 74-75, 77, 80, 84, 101, 104, 107, 114-119, 121-122, 137-139, 154-155, 158-159, 161, 166
subnet: 79-80
supported: 4-5, 9, 12, 19-20, 23, 30, 37-38, 40, 58, 66, 83, 96, 100-102, 125, 143, 162, 167
synapse: 4
T
tempdb: 8, 13, 49, 66, 68, 70, 77, 86, 119, 122, 157
throughput: 44, 47, 49, 66, 114-116, 118, 120, 122, 128, 161
toolkit: 129-131
two-factor: 3
U
ubuntu: 6, 32, 38, 100-104, 106
unicode: 12
uninstall: 36
update: 6, 55, 57-58, 64, 69, 144-145, 165
upgrade: 11, 17, 72, 101, 114
utility: 98
V
version: 3, 5-8, 11, 13, 15-16, 19, 22, 30, 33, 37, 101-102, 120, 131-132, 144, 160, 165
vmware: 167
vscode: 97
W
warehouse: 117
windows: 4, 6, 15, 18-23, 29, 31-38, 40-41, 45, 48, 61, 64, 68-70, 74-75, 77-78, 81, 83, 86, 88, 94, 96, 98, 106, 114-115, 120, 131, 135, 137, 153, 160-164, 166-167
workflows: 99
workload: 6, 23, 43, 46-48, 56, 66, 107, 113-119, 122, 126-129, 131, 133-134, 144, 153, 158, 161-163, 165-166