Index
A
Accelerated Database Recovery (ADR)
ALTER DATABASE command
benefits
filegroups
logical revert
log stream
Multithreaded Cleanup
phases
PVS
Additional Connection Properties tab
Advanced cluster preparation wizard
Advanced Encryption Standard (AES)
Affinity mask
ALTER SERVER CONFIGURATION
Always Encrypted
attestation service
client key
configuration
configure client
PowerShell script
changes
client driver
CreditCards table
cryptographic objects
database engine
definition
deterministic encryption
encryption types/feature compatibility
guarded host
insert data, encrypted columns
keys
Administrators
Column Master Keys
enclave enabled keys
sys.column_encryption_keys
sys.column_encryption_key_vales
sys.column_master_keys
key store values
limitations
randomized encryption
secure enclaves
segregation of duties
supported drivers
AlwaysOn Availability Groups (AOAG)
administrative considerations
automatic page repair
contained availability group
data-tier applications
HA
SeeHigh availability (HA)
monitoring
on Linux
topology
synchronous failover
virtual machines (VMs)
AlwaysOn dashboard
AlwaysOn Health Trace
App3
Application programming interface (API)
Asynchronous Commit mode
Atomic, consistent, isolated, and durable (ACID)
Autocommit transactions
AUTO_CREATE_STATISTICS
Automatic installation
installation routine, enhancing
PowerShell script
production readiness
Automation
AUTO_UPDATE_STATISTICS
Availability group listener
avg_fragmentation_in_percent column
Azure Arc
Azure Arc heartbeat
Azure SQL VMs vs. VMs onboarded
B
Backup database
BULK LOGGED recovery model
creation
devices
backup set
media set
differential
filegroup
full backup
full/differential/transaction logs
FULL recovery model
full/transaction log
log backup
media
mirrored media set
multiple devices
partial
SIMPLE recovery model
SSMS
Backup Options page
Disk/URL
encryption
filegroups
General page
Media Options page
Reliability section
transaction log
T-SQL
backup options
error management options
log-specific options
media set options
miscellaneous options
WITH options
types
Backup Preferences tab
Base containment
Bash (scripting language)
Binary data
Blockchain technology
B-tree (balanced-tree)
leaf level
root node
uniquifier
BUCKET_COUNT
Buffer pool extension
Bulk Copy Program (BCP)
bw-tree
C
Capacity management
Cardinality
Case sensitivity
Cell-level encryption
asymmetric keys
Authenticator column
Azure Blob storage
bloat
cryptographic functions
DECRYPTBYKEY() function
DecryptByKey parameters
definition
duplicate database selection
EncryptByKey() parameters
HASHBYTES() function
salt value
security risk
SensitiveData table
symmetric keys
UPDATE statement
Center for Information Security (CIS)
CentOS containers
Central management server (CMS)
Certificate authority (CA)
Change Data Capture (CDC)
Chapter5LogFragmentation
database creation
log reuse waits
log size and VLFs number
sys.databases
transaction log
Chapter15App2Customers database
Chapter15App3Sales database
CHECKSUM
Classifier function
Client connectivity SDK
Clustered indexes
CREATE CLUSTERED INDEX
DROP INDEX
primary key clustering
tables with/without
WITH options
Collation
accent sensitive
binary collation sort order
case sensitivity
configuration page
sort order
Columnstore indexes
clustered
nonclustered
Complex security framework
Consistency errors
Contained availability groups
Containerization
Containers
CREATE TABLE T-SQL
Cryptographic functions
CustomersMem table
D
Database
filegroup
storage
Database administrators (DBAs)
backup strategies
SQL Server Audit
Database consistency
DBCC CHECKDB
SeeDBCC CHECKDB
detecting errors
bad checksum error
CHECKSUM database
Corrupt Table
event types
memory-optimization tables
options page
page verify option
suspect_pages
TORN_PAGE_DETECTION
errors
system database corruption
database, reattaching
instance page selection
instance parameters, repairing
parameters, rebuilding
VLDBs
Database Engine service
Database-level security
built-in database roles
contained databases
db_datareader/db_denydatawriter
db_ReadOnlyUsers
schemas
Securables tab
T-SQL
Database metadata
Database Properties dialog box
Database snapshots
definition
implementation
querying
recovering data
Database users
Data manipulation language (DML)
Data Migration Assistant
Data Protection API (DPAPI)
Data quality server
Data structure
B-tree
leaf level
root node
uniquifier
heap
DBCC CHECKALLOC
DBCC CHECKCATALOG
DBCC CHECKCONSTRAINTS arguments
DBCC CHECKDB
arguments
CHECKALLOC
CHECKCATALOG
CHECKCONSTRAINTS
CHECKFILEGROUP
CHECKIDENT
CHECKTABLE
configure notification
corrupt page
Corrupt Table error
emergency mode
errors, job history
new operator selection
REPAIR_ALLOW_DATA_LOSS
repairing corruption
REPAIR_REBUILD
running command
suggested repair option
suspect_pages table
TempDB space
DBCC CHECKFILEGROUP
DBCC CHECKIDENT arguments
DBCC CHECKTABLE
DBCC TRACEON
DB_ID() function
dbo.suspect_pages
Deadlocks
chronology
deadlock monitor
generate
minimize risk
observation
scripts
victim’s query window
DecryptByKey parameters
Deferred transaction
Degree of parallelism (DOP)
Delayed durability
Delayed truncation
Deltastore
Dictionary compression
Dirty pages
Dirty read
Disaster recovery (DR)
AOAG
SeeAlwaysOn Availability Groups (AOAG)
database creation
GUI configuration
ad-hoc restores
Copy Files tab
Initialize Secondary Database tab
Log Shipping Monitor Settings
monitor server
New Job Schedule
No Recovery Mode
proxy account
Restore Transaction Log tab
Save Log Shipping Configuration
Transaction Log Backup Settings
Transaction Log Shipping page
log shipping
recovery point objective
T-SQL configuration
@backup_job_id output
sp_add_log_shipping_primary_database Parameters
sp_add_log_shipping_primary_secondary system
sp_add_log_shipping_secondary_database paremeters
sp_add_log_shipping_secondary_primary system
sp_processlogshippingmonitorsecondary parameters
vs. high availability (HA)
Distributed Availability Groups (DAGs)
dm_os category
Docker file
Docker images
Microsoft
Windows
Dynamic link library (DLL)
Dynamic management functions (DMFs)
Dynamic management views (DMVs)
binary mask
CPU
disk latency
Performance Monitor
resetting statistics
resource pool stats
sales user/manger login
sys.dm_resource_governor_resource_pool_affinity
sys.dm_resource_governor_resource_pools
sys.dm_resource_governor_resource_pool_volumes
sys.dm_resource_governor_workload_groups
workload group stats
E
Editions and license models
CAL
developer
enterprise
express
feature/licensing
operational teams
Server Core
standard
TCO
web
ENCRYPTBYKEY() function
EncryptByKey() parameters
Encryption hierarchy
asymmetric keys
CA
DPAPI
SQL Server
Azure Blob storage
Backup and restore Database Master Key
Database Master Key selection
EKM module
FORCE keyword
hierarchy
Restore Service Master Key
Service Master Key
symmetric key
End of life cycle (EOL)
Enlightenment
Evaluate Policies dialog box
Event session
database creation
dialog box creation
ActivityID
Advanced page
causality tracking
Data Storage page
Event Fields tab
Events page
Filter (Predicate) tab
General page
Global Fields (Actions) tab
module_start event
page_splits event
T-SQL
arguments
LogFileIO
NO_EVENT_LOSS option
WITH options
Event Tracking for Windows (ETW)
EXEC keyword
ExistingOrders table
Explicit transactions
Extended Events
actions
categories
channels
data analysis
data collection
Aggregation dialog box
analyzing data with T-SQL
Columns dialog box
Customers table
data viewer grid
data viewer toolbar
event_file target
wait_type column
data viewer
operating system data
Collector Set
Data Collector Set
event trace session
generate activity
merging trace files
Perfmon Data
Performance Monitor
Properties dialog box
scenario
trace file location
T-SQL command
Windows Performance Analyzer
WMI
packages
Perfmon data
predicates
session
SeeEvent session
targets
types and maps
Extensible Key Management (EKM) module
External fragmentation
F
Failover Clustered Instance (FCI)
active/active configuration
node
Quorum
three-plus node configurations
Filegroups
adding files
backup/restore strategies
expanding files
FILESTREAM
binary cache
buffer cache
container
database properties dialog box
drop-down box
FileTable
folder hierarchy
T-SQL commands
Windows cache
log maintenance
log file count
log size and VLFs number
recovery model
shrinking
structure
sys.databases
transaction log
VLFs per GB
memory-optimized strategies
memory-optimized tables
performance strategies
primary file
round-robin approach
secondary files
shrinking files
storage tiering strategies
FILESTREAM
binary cache
buffer cache
container
data
database properties dialog box
drop-down box
FileTable
folder hierarchy
tab
T-SQL commands
Windows cache
FILLFACTOR
Filtered index
Fine-grain permissions
First in first out (FIFO) methodology
fn_dump_dblog() system function
Fragmentation of index
detection of
fragmentations
page split
removal of
Full-text indexes (FTE)
Fully qualified domain name (FQDN)
G
GETDATE() function
GPG Public Keys
Graphical user interface (GUI)
GUI installation
installation center
advanced tab
installation tab
maintenance tab
options tab
planning tab
resources tab
tools tab
Stand-Alone Database Engine Instance
collation
SeeCollation
data directories tab
Distributed Replay Controller page
Feature Selection page
FILESTREAM tab
Global Rules page
Install Rules page
Instance Configuration page
License Terms page
Microsoft Update page
Product Key page
Product Updates page
Ready to Install page
selecting service accounts
Server Configuration tab
Setup Role page
H
Hardware requirements
storage
cloud storage
disk block size
file placement
SAN
strategic minimum requirements
Hardware security module (HSM)
Hash collisions
Hash index
Hashing algorithm
Heap
Hekaton
High availability (HA)
AlwaysOn failover clustering
active/active configuration
node
Quorum
cost of downtime
creation
database page selection
data synchronization page
dialog box
introduction page
results page
specify name page
Synchronous Commit mode
tabs
validation page
database creation
vs. DR
level of availability
calculation
percentage
proactive maintenance
SLAs & SLOs
SQL server
RPO & RTO
SQL Server configuration
standby classifications
High availability and disaster recovery technologies
Hybrid Buffer Pool
Hybrid management
capabilities
environmental health
configuration
Local Security Policy console
Microsoft Monitoring Agent
Scheduled Task
script, running
Microsoft Defender
SeeMicrosoft Defender
SQL BPA
SeeSQL Best Practice Assessment (SQL BPA)
I
Implicit transactions
Indexes
clustered indexes
CREATE CLUSTERED INDEX
DROP INDEX
primary key clustering
tables with/without
WITH options
columnstore indexes
fragmentation
detection of
external
internal
page split
removal of
in-memory indexes
missing indexes
nonclustered indexes
covering indexes
CREATE NONCLUSTERED INDEX
DROP INDEX
filtered index
partitioned indexes
resumable index operations
statistics
creation
filtered statistics
updation
tipping point
Index Scan operator
Initial data synchronization
In-Memory OLTP
Installation helper application
Instance configuration
buffer pool extension
Hybrid Buffer Pool
MAXDOP
Min/max Server Memory (MB)
ports
communication process
database engine
dynamic ports
IP addresses
ports
protocol tab
static port
processor affinity
affinity mask
bit maps
NUMA node
sp_configure
system databases
Master
Model
MSDB
mssqlsystemresource
TempDB
trace flags
DBCC TRACEON
startup parameters
trace flags
Windows Server Core
Instance installation
/ACTION Parameter
command line parameters
/FEATURES Parameter
/IACCEPTSQLSERVERLICENSETERMS switch
installation progress
license terms parameters
optional parameters
product update
required parameters
/ROLE Parameter
smoke test
troubleshooting
detail.txt
log files
summary.txt
SystemConfigurationCheck_Report.htm file
Instance-level security
AOAG
fixed server roles
General tab
granting permissions
login creation
authentications
CHECK_POLICY
database
Enforce Password Policy
options
Securables tab
Server Roles tab
SSMS
Status tab
T-SQL
User Mapping tab
Members tab
mixed-mode authentication
SA account
security vulnerability
New Server Role
permissions
second-tier authentication
server roles
Windows authentication
ownership chain
SID
SQLUsers group
Windows user/group
Integrated Scripting Environment (ISE)
Integration services
Intent locks
Internal fragmentation
Internal_Frag_With_FillFactor_Offset column
InternalReports
Invoke-SqlCmd cmdlet
is_Advanced
is_dynamic
Isolation
J, K
Jobs
database mail configuration
advanced page
Alerts page
Alert System page
BACKUP DATABASE command
blacklist/whitelist
Browser service
Configure System Parameters page
DBAs
history box
job creation
job owner
Logging Level
Manage Profile Security page
name/description fields
New Database Mail Account dialog box
New Job Step dialog box
notifications page
operator creation
PowerShell script
Profile page
Public Profiles tab
schedules page
Select Configuration Task page
SMTP server
steps page
system parameters configuration
targets page
Wizard page
monitoring/maintenance
alerts
execution
job history
L
Ledger
blockchain technology
database
creation
developers
status
digest management
automatic digest generation
Azure integration
creation/view block
CREDENTIAL
database digest
database verification
DML statements
JSON
Merkle Trees
operations
sys.database_ledger_blocks
trustworthiness
tables
Append-only
SSMS
types
updateable
SeeLedger tables, updateable
Ledger tables, updateable
vs. append-only ledger tables
columns
consideration
creation
custom name
dropped objects
EXECUTE AS clause
GoodsIn table, dropping
history table
Logins/Users
modification
results
view
Local distributor
Locally attached storage
Locking
compatibility
granularity
observation
online maintenance
partitioning
Lock partitioning
Logical backup device
Log sequence number (LSN)
Log shipping
DR
SeeDisaster recovery (DR)
failing over
monitoring
Log Shipping Primary Server Alert
Log Shipping Secondary Server Alert
Response tab
Server Agent Alerts
sp_help_log_shipping_monitor
report
switching roles
Disabling Log Shipping Jobs
reconfigure log shipping
reconfigure monitoring
M
master_App3
Master database
Master data services (MDS)
Master server (MSX)
Maximum degree of parallelism (MAXDOP)
Memory data
Memory-optimized tables
creation
disk-based tables
DLL
durability
In-Memory OLTP
memory pressure
migration
natively compiled stored procedures
Memory-Optimized TempDB Metadata
Memory tables
MERGE operation
Merge replication
Metadata
buffer cache usage
capacity management
file details
powerShell
sys.dm_db_file_space_usage
sys.dm_io_virtual_file_stats
sys.master_files
xp_fixeddrives
catalog view
DATALENGTH
definition
dynamic management view
information schema view
perfmon counters
rebuild indexes
registry values
server/instance level
waits
external waits
PAGELATCH waits
queue waits
signal waits
sys.dm_os_wait_stats
tasks
types
Metadata-driven automation
database snapshots
fragmentation
Microsoft Assessment and Planning (MAP)
Microsoft Container Registry (MCR)
Microsoft Cryptographic API (MSCAPI)
Microsoft Defender
alerts
Azure Arc
components selection
configuration
database types
e-mail notifications
File integrity monitoring
findings
fix confirmation window
provisioning
recommendations
scorecard
SQL extension
subset
suppression rules
upgrade screen
vulnerabilities
details page
filtering
subreport
Microsoft Developer Network (MSDN)
Microsoft Distributed Transaction Coordinator (MSDTC)
Microsoft website
Minimally logged (ML) pages
Mixed-mode authentication
Model database
Monitoring tool
msdb_App3
MSDB database
msdb.dbo.suspect_pages table
mssql-conf parameters
mssql-conf setup tool
MSSQLSERVER
mssqlsystemresource database
mssql-tools
Multidimensional and Data Mining mode
Multidimensional expressions (MDX) language
Multiserver jobs
master jobs
Multiserver job conversion
sp_add_jobserver parameters
sp_delete_jobserver
sp_delete_jobserver parameters
sp_msx_enlist stored procedure
sp_update_job procedure
sp_update_jobstep procedure
MSX and TSX servers
encryption
instances
Login Credentials page
Master Server operator page
Master Server Wizard
MsxEncryptChannelOptions
proxy creation
Registry updation
Target Servers page
Target Servers
Download Instructions tab
Force Defection button
Post Instructions button
Start Job, TARGETSERVER1
synchronize clocks
Target Server Status tab
N
Natively compiled stored procedure
NEWSEQUENTIALID()
New technology file system (NTFS)
NOLOCK query hint
Nonclustered hash index
Nonclustered indexes
covering indexes
CREATE NONCLUSTERED INDEX
DROP INDEX
filtered index
Nonrepeatable read
Non-uniform memory access (NUMA) node
O
Object-level security
assigning permissions
column-level permissions
OBJET_ID() function
OldOrdersStaging
Online transaction processing (OLTP)
Operating systems
configuration
assigning user rights
SeeUser rights assignments
background service
gold build
power plan
EOL
Optimistic isolation levels
Ownership chaining
P
Page locks
Page split
Page Verify
PartFunc
PartFuncWeek
Partitioned indexes
Partition elimination
Partitions
concepts
function
hierarchy
index alignment
partitioning key
scheme
definition
elimination
implementaion
existing table
new table creation
object creation
$PARTITION function
structure
Perfmon
Persisted version store (PVS)
Pessimistic isolation levels
Phantom read
PHP Web App
Policy-based management (PBM)
central management server
enterprise management
policy evaluation with PowerShell
condition
central management servers
database
description
evaluation modes
On Change: Log Only
On Change: Prevent
On Demand
On Schedule
supported execution types
ExecuteSQL() Parameters
ExecuteWQL() Parameters
facets
policies
server/instance name
simple static policy
BrokenPolicy Database creation
Description page
ExcludeSystemDatabases condition creation
New Condition dialog box creation
New Policy dialog box creation
prevents unwanted activity
target
PowerPivot
Primary role property
Profiler
PROSQLADMINAUTO1
PROSQLADMINCORE2
Publication Access List (PAL)
Q
QLAutoInstall1.ps1
Query optimizer
Query Store
configuration
database creation
DBAs
enabling
Force/Unforce Plan buttons
hints
challenge
feature
hash match
Intelligent Query Processing
lists
Merge Join
optimizer
performance issue
plan guides
Query IDs
removing
Secondary Availability Replicas
sp_query_store_set_hints
plans
Properties tab
queries, run
QUERY_CAPTURE_POLICY options
Regressed Query report
reports
CPU drill
databases
data points
DBAs
details
execution count
grid view
Overall Resource Consumption
queries
Query Plan
Query Wait Statistics
Top Resource Consumers
SET options
SSMS
stored procedures
T-SQL objects
catalog views
wait statistics mappings
wait types
Unforce plan
R
Read Committed isolation
Read Committed Snapshot
RECONFIGURE command
RECONFIGURE WITH OVERRIDE command
Recovery database
Recovery point objective (RPO)
Recovery time objective (RTO)
Red Hat
Redundant array of inexpensive disks (RAID) arrays
Remote distributor
Repeatable Read
Replicas tab
Replication
components
merge
snapshot
transactional
SeeTransactional replication
ReportingApp
Resource Governor
SeeResource pool
Resource pool
arguments
business rules
classifier function
creation
instance preparation
testing
configuration
creation
definition
DMVs
binary mask
CPU
disk latency
Performance Monitor
resetting statistics
resource pool stats
sales user and manger login
sys.dm_resource_governor_resource_pools
sys.dm_resource_governor_resource_pool_volumes
sys.dm_resource_governor_workload_groups
workload group stats
IOPS limits
memory limit
properties dialog
sys.dm_resource_governor_resource_pool_affinity
workload groups
Restore database
files
page
piecemeal
Point in Time
SSMS
backup timeline page
files page
General page
options page
Restore Options section
Tail-Log Backup section
verification
WITH PARTIAL
T-SQL
Backup set options
error management options
media set options
miscellaneous options
restore arguments
restore options
WITH options
Resumable index operations
Row locks
Row versioning
S
SA account
SalesApplication app
SalesApplication resource pool
Save points
Security identifier (SID)
Serial advanced technology attachment (SATA)
Serializable
Server Audit
AUDIT_CHANGE_GROUP
Audit-ProSQLAdmin
creation
database audit specification
enabling and invoking
filter
FOR SERVER AUDIT clause
log size
options
parameters
Security log
SensitiveData table
SERVER_ROLE_MEMBER_CHANGE_GROUP
specifications
sysadmin role
target
T-SQL
Windows Application log
Server Core
Server roles
Session Timeout property
Simple Mail Transfer Protocol (SMTP)
Sliding windows
Smoke tests
Snapshot isolation
Snapshot replication
Solid-state drives (SSDs)
Sparse file
sp_configure
ALTER SERVER CONFIGURATION
MAXDOP
processor affinity
sp_estimate_data_compression_savings
SPLIT operation
Split brain
SQL Agent services
SQLAutoInstall2.ps1
SQLAutoInstall3.ps1
SQLAutoInstall.ps1
SQL Best Practice Assessment (SQL BPA)
configuration
filtering
finding
front page
full stack
Insights tab
Kusto Query
log query window
message details
New Issues tab
report
timestamp
Trends tab
sqlcmd
SQL Server
AWS server
Azure Arc
backup types
certificates
data
DBAs
extension, Azure
hybrid features
installation
Linux
Log Analytics Workspace
media
Memory Pool
onboarded
Query Store
recovery models
Secure Enclaves
service account
Windows applications
SQL Server Agent
alerts
categories of activity
and responses
SQL Server events
SQL Server performance conditions
WMI events
definition
jobs
advanced page
credentials creation
database mail configuration
date and time
environment preparation
Frequency and Duration sections
general page
New Job dialog box
New Job Schedule box
notifications page
proxy creation
removing old backups
schedule creation
SCOM
SQLUser and WinUser
steps page
Multiserver jobs
operators
permissions
Proxy accounts map
schedules
security
database roles
proxy accounts
SQL Server Analysis Services (SSAS)
SQL Server Configuration Manager
SQL Server installation
Bash script
configuration
custom Windows container
Docker container
language selection
public gpg keys, importing
registeration, SQL Server repository
sa password
Scripted SQL Server Installation
Start Server Agent
SQL Server instance
SQL Server Integration Services (SSIS)
SQL Server Management Studio (SSMS)
distributor/publisher
adding filter
Agent Security page
Article Properties
Articles page
distributor page
Filter Table Rows page
Publication Database page
Publication Type page
Snapshot Agent page
Snapshot Agent Security
Snapshot Folder page
SQL Server Agent Start page
Wizard page
subscriber
Distribution Agent
Distribution Agent Location page
General page
Initialize Subscriptions page
Publication page
Subscribers page
Synchronization Schedule page
SQL Server security model
concept
database creation
database-level security
built-in database roles
contained databases
db_datareader/db_denydatawriter
db_ReadOnlyUsers
schemas
Securables tab
T-SQL
DBAs
hierarchy
accounts
database users
domain user/group
permissions
principals
securables
Windows login
instance-level
SeeInstance-level security
object-level security
assigning permissions
column-level permissions
OBJECT phrase
SELECT/EXECUTE permission
Server Audit
AUDIT_CHANGE_GROUP
Audit-ProSQLAdmin
creation
database audit specification
enabling and invoking
filter
FOR SERVER AUDIT clause
log size
options
parameters
Security log
SensitiveData table
SERVER_ROLE_MEMBER_CHANGE_GROUP
specifications
sysadmin role
target
T-SQL
Windows Application log
Standard data
Standard transactional replication
Standby classifications
Storage area network (SAN)
Summary.txt
SUSE Linux
SWITCH function
SWITCH operations
Synchronous Commit mode
sys.configurations
sys.dm_db_file_space_usage
sys.dm_db_index_physical_stats
sys.dm_io_virtual_file_stats
sys.dm_os_buffer_descriptors
sys.dm_os_enumerate_fixed_drives
sys_dm_os_performance_counters
sys.dm_os_waiting_tasks
sys.dm_server_registry
sys.dm_server_services
sys.fn_dump_dblog() function
sys.fn_PageResCracker
sys.master_files
System Configuration Checker
Systems Operation Center
T
Table locks
Table Memory Optimization Advisor
Tables
compression
columnstore
data compression wizard
dictionary compression
maintenance
page structure
prefix compression
row compression
sp_estimate_data_compression_savings
structure
tables and partitions
variable-length metadata
memory-optimized tables
SeeMemory-optimized tables
partition
elimination
existing table
function
hierarchy
index alignment
new table creation
object creation
partition
$PARTITION function
partitioning key
scheme
structure
Tabular mode
Target servers (TSXs)
TDE
SeeTransparent Data Encryption (TDE)
TempDB files
TempDB tab
Terabytes (TBs)
TORN_PAGE_DETECTION
Total cost of ownership (TCO)
Trace flags
DBCC TRACEON
startup parameters
Windows Server Core
Transactional anomalies
Transactional replication
definition
Distributor
PAL
Publication
subscriber
Transactions
atomic transaction
consistent property
in-memory OLTP
cross-container transactions
Read Committed isolation
Repeatable Read
retry logic
Serializable
snapshot isolation
isolation
dirty read
durable
nonrepeatable read
optimistic levels
pessimistic level
phantom read
observation
Transact-SQL (T-SQL)
Transmission Control Protocol (TCP)
Transparent Data Encryption (TDE)
advantages
Backup certificate
Database Master Key
enabling
FILESTREAM filegroup
implementation
Database Encryption key
Database Master Key
database progress
feature
Manage Database Encryption
In-Memory filegroup
instant file initialization
replication
restore and encrypted database
Server Certificate restore database
subscriber
TempDB
Trusted Platform Module (TPM)
U
Ubuntu
Uncomplicated Firewall (ufw)
/UPDATEENABLED parameter
URL
User acceptance testing (UAT)
User rights assignments
instant file
locking pages
SQL audit
V
Very large databases (VLDBs)
DBCC CHECKALLOC
DBCC CHECKDB
secondary server
split work load
Virtualization-based security (VBS)
Virtual log files (VLFs)
W, X
wget command
Whole-value substitution attack
Windows administration team
Windows authentication mode
Windows Authentication model
Windows Management Instrumentation (WMI)
Windows Performance Toolkit
Windows Server Core Installation
configuration file
auto-install script
SQLAutoInstall.ps1
SQLPROSQLADMINCONF1
instance
SeeInstance Installation
NET Framework 3.5
Windows Server Update Services (WSUS)
Write-ahead logging (WAL)
Y, Z
YAGNI principle
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.