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.

  • 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.

  • tablespace

    In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a tablespace plays a role similar to that of a folder on the hard drive of a computer. (Continued)

  • transcription error

    A transcription error is a specific type of data entry error that is commonly made by human operators or by optical character recognition (OCR) programs.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close