SQL Server Definitions

This glossary explains the meaning of key words and phrases that information technology (IT) and business professionals use when discussing Microsoft SQL Server and related software products. You can find additional definitions by visiting WhatIs.com or using the search box below.

  • R

    record standardization

    In data management, record standardization is a process in which files are first parsed (assigned to appropriate fields in a database record) and then translated to a common format.

  • relational database

    A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

  • relational database management system (RDBMS)

    A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database.

  • replication

    Replication (pronounced rehp-lih-KA-shun) is the process of making a replica (a copy) of something.

  • rollback

    A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed.

  • S

    Microsoft SQL Server

    Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments

  • schema

    In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database.

  • segment

    A segment is a defined portion or section of something larger such as a database, geometric object, or network.

  • spatial data

    Spatial data, also known as geospatial data, is information about a physical object that can be represented by numerical values in a geographic coordinate system.  

  • SQL (Structured Query Language)

    SQL, short for Structured Query Language, is a programming language for relational databases. It lets users modify database structures and insert, update and query data.

  • SQL Azure

    SQL Azure is Microsoft’s cloud database service.

  • SQL Server 2014

    SQL Server 2014 is relational database management system (RDBMS) designed for the enterprise environment.

  • SQL Server buffer pool

    An SQL Server buffer pool, also called an SQL Server buffer cache, is a place in system memory that is used for caching table and index data pages as they are modified or read from disk. 

  • SVVP (server virtualization validation program)

    SVVP (server virtualization validation program) is a policy that allows administrators running running Windows Server on certified virtualization technologies other than Hyper-V and Microsoft Virtual Server to receive technical support for Windows Server from Microsoft.

  • T

    T-SQL (Transact-SQL)

    T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables.