Glossary

A

Active Directory

ActiveX Data Object

Ad hoc Report

AES 128 bit Encryption

AES 256 bit Encryption

Agents

Aggregate Query

Allocation Map

Allocation Unit

Always On Availability Groups

B

Backup

Base Backup

Bloat

Buffer Pool

Bulk Loading

C

Compression

Cross-database Chaining

CX Packet

Columnstore Index

D

Data Capture

Data Growth

Data Scrambling

Database Forensics

Disk Usage

Dynamic SQL

Data Masking (Dynamic Data Masking)

Database Mirroring

E

Effective Permissions

ESX Hosts

Extended Events

F

FERPA Audit

Fill-factor

Filter Driver

Full Recovery Model

G

Global Assembly Cache

Graphical User Interface (GUI)

Group By

H

Hekaton

High Availability Cluster

HIPAA Audit

Hybrid Cloud SQL Server

Hyper-V

I

Index Rebuild

Inventory Management

In-Memory OLTP (Hekaton)

J

Join Optimization

K

Kernel

KVM Switch

L

Latch Wait

Latency

Linq

Linux Hot Copy

Log Shipping

M

Master File Table

MDX

Merge Replication

Middleware

Mirror Database

Mount Points

N

Native Compression

Nesting

NodeXL

O

Object Level Recovery

Online Transaction Processing

Overflow Error

P

Page Split

Parallelism

Parallels Cloud Server

Partial Differential Backup

PowerShell

PowerShell Scripts

Partitioned Tables

PolyBase

Q

Query

Quorum

Query Store

R

Replication

Replication Monitor

Restore

Root Cause Analysis

Resource Governor

Row-Level Security

S

Scaffolding

SCOM

SQL Server Agent

SQL Server Integration Services (SSIS)

SQL Server Management Studio (SSMS)

SQL Server Profiler

T

Tabular Data Stream

Tempdb

Transact SQL

Temporal Tables

Transparent Data Encryption (TDE)

Transactional Replication

X

XML Schema Collection