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.

  • A

    ACID (atomicity, consistency, isolation, and durability)

    ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonic device for learning and remembering the four primary attributes ensured to any transaction by a transaction manager (which is also called a transaction monitor).

  • ActiveX Data Objects (ADO)

    ActiveX Data Objects (ADO) is an application program interface from Microsoft that lets a programmer writing Windows applications get access to a relational or non-relational database from both Microsoft and other database providers.

  • AdventureWorks Database

    AdventureWorks Database is a sample OLTP database that Microsoft ships with all of its SQL Server database products.

  • AlwaysOn Availability Groups

    AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together.

  • application server

    An application server is a server program in a computer in a distributed network that provides the business logic for an application program.

  • AS1 (Applicability Statement 1)

    AS1 (Applicability Statement is a specification for Electronic Data Interchange (EDI) communications between businesses using e-mail protocols.

  • Azure Data Studio (formerly SQL Operations Studio)

    Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems.

  • B

    B-tree

    A B-tree is a method of placing and locating files (called records or keys) in a database.

  • binary tree

    A binary tree is a method of placing and locating files (called records or keys) in a database, especially when all the data is known to be in random access memory (RAM).

  • bit bucket

    Computer jargon users say that data which has been lost or thrown away has gone in the bit bucket.

  • BLOB (binary large object)

    In computers, a BLOB (binary large object), pronounced BLAHB and sometimes spelled in all lower case, is a large file, typically an image or sound file, that must be handled (for example, uploaded, downloaded, or stored in a database) in a special way because of its size.

  • block

    A block is a contiguous set of bits or bytes that forms an identifiable unit of data.

  • C

    C++

    C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications.

  • catalog

    In computing, a catalog is a directory of information about data sets, files, or a database.

  • Collaboration Data Objects (CDO)

    Collaboration Data Objects (CDO) is Microsoft's technology for building messaging or collaboration applications or adding these capabilities to existing applications.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close