SQL Server Administration 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).

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

  • C

    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.

  • commit

    A commit is the final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.

  • Community Technology Preview (CTP)

    The Community Technology Preview (CTP) is an early version of a Microsoft product that is released to testers during the software development process. Microsoft releases several CTPs for each product, adding new features, updating pre-existing ones and fixing bugs with each release.

  • contiguity

    Contiguity (from Latin contiguus and contingere, to have contact with) is the state of being in close proximity with or even touching another object.

  • contiguous

    Contiguous describes two or more objects that are adjacent to each other.

  • CORBA (Common Object Request Broker Architecture)

    Common Object Request Broker Architecture (CORBA) is an architecture and specification for creating, distributing, and managing distributed program objects in a network.

  • Java container

    In Sun Microsystems' JavaBeans component architecture and in Microsoft's Component Object Model (COM), a container is an application program or subsystem in which the program building block known as a component is run.

  • D

    DAO (Data Access Objects)

    DAO (Data Access Objects) is an application program interface (API) available with Microsoft's Visual Basic that lets a programmer request access to a Microsoft Access database.

  • data aggregation

    Data aggregation is any process in which information is gathered and expressed in a summary form, for purposes such as statistical analysis.

  • data corruption

    Data corruption is the deterioration of computer data as a result of some external agent.

  • data hiding

    Data hiding is a characteristic of object-oriented programming.

  • database replication

    Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued)

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close