SQL Server Definitions

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

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

  • columnstore index

    A columnstore index is a type of index used to store, manage and retrieve data stored in a columnar format in a database.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close