Glossary

A

Active Directory

Ad hoc Report

AES 128 bit Encryption

AES 256 bit Encryption

Agents (SQL Server Agent)

Aggregate Query

Allocation Map

Allocation Unit

Always Encrypted

Always On Availability Groups

Amazon RDS for SQL Server

Automatic Tuning

Azure SQL Database

B

Backup

Base Backup

Blocking

Bloat

Buffer Pool

Bulk Loading

C

Columnstore Index

Compression (SQL Server)

CX Packet Wait

D

Data Capture (Change Data Capture)

Data Growth

Data Masking (Dynamic Data Masking)

Data Scrambling

Database DevOps / CI-CD for Databases

Database Forensics

Database Mirroring

Deadlock

Disk Usage

Dynamic SQL

E

Effective Permissions

Execution Plan

Extended Events

F

FERPA Audit

Fill Factor

Filter Driver

Full Recovery Model

G

GDPR and Database Compliance

Group By

H

Hekaton

High Availability Cluster

HIPAA Audit

Hybrid Cloud SQL Server

Hyper-V

I

In-Memory OLTP (Hekaton)

Index Rebuild

Intelligent Query Processing

Inventory Management

J

Join Optimization

L

Latch Wait

Latency

Ledger Tables

Log Shipping

M

Merge Replication

Mirror Database

N

Native Compression

O

Object Level Recovery

Online Transaction Processing

P

Page Split

Parallelism

Parameter Sniffing

Partial Differential Backup

Partitioned Tables

PolyBase

PowerShell

PowerShell (for SQL Server)

Q

Query

Query Performance Insight

Query Store

Quorum

R

Replication

Replication Monitor

Resource Governor

Restore

Root Cause Analysis

Row-Level Security

S

SCOM (System Center Operations Manager)

SQL Server Agent

SQL Server Integration Services (SSIS)

SQL Server Management Studio (SSMS)

SQL Server Profiler

T

Tempdb

Temporal Tables

Transact SQL

Transactional Replication

Transparent Data Encryption (TDE)

W

Wait Statistics