Glossary

A

Active Directory

ActiveX Data Object

AES 128 bit Encryption

AES 256 bit Encryption

Aggregate Query

Allocation Unit

AlwaysOn Availability

Always On Availability Groups

B

Business Intelligence

C

Continuous Data Protection

Cross-database Chaining

Columnstore Index

D

Data Scrambling

Data Warehousing

Database Autoshrink

Database Forensics

Dynamic Link Libraries

Data Masking (Dynamic Data Masking)

Database Mirroring

E

Effective Permissions

Entity Framework

Extended Events

F

Fail-over Operator

Full Recovery Model

G

Global Assembly Cache

Graphical User Interface (GUI)

H

High Availability Cluster

Hybrid Cloud SQL Server

I

Infrastructure as a Service

IntelliCompress

Inventory Management

In-Memory OLTP (Hekaton)

J

Join Optimization

K

L

M

Master File Table

Merge Replication

Mirror Database

N

Native Compression

O

Object Level Recovery

Online Transaction Processing

P

Parallels Cloud Server

Partial Differential Backup

PowerShell Scripts

Partitioned Tables

Q

R

Replication Monitor

Repositive Recovery Model

Root Cause Analysis

Resource Governor

Row-Level Security

S

SQL Server Agent

SQL Server Integration Services (SSIS)

SQL Server Management Studio (SSMS)

SQL Server Profiler

T

Tabular Data Stream

Task Automation

Transaction Log Viewer

Temporal Tables

Transparent Data Encryption (TDE)

Transactional Replication

U

Upgrade Advisor (SQL Server Upgrade Assistant)

V

X

XML Schema Collection