SQL Server Administration Definitions

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

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

  • 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 whereby data is gathered and expressed in a summary form.

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

  • drilldown

    As currently used in information technology, to drill down (verb) is to focus in on something.

  • F

    fetch

    In computer technology, fetch has several meanings related to getting, reading, or moving data objects.

  • H

    hashing

    Hashing is the transformation of a string of characters into a usually shorter fixed-length value or key that represents the original string.

  • hybrid online analytical processing (HOLAP or Hybrid OLAP)

    Hybrid online analytical processing (HOLAP) is a combination of relational OLAP (ROLAP) and multidimensional OLAP (usually referred to simply as OLAP).

  • I

    In-Memory OLTP

    In-Memory OLTP is a Microsoft in-memory technology built into SQL Server and optimized for transaction processing applications.

  • L

    library

    In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units such as tape cartridges.

  • M

    Microsoft SQL Server 2016

    SQL Server 2016 is a SQL-based relational database management system released by Microsoft for general availability on June 1, 2016. It supports transaction processing, data warehousing and analytics uses and provides new and updated features with a 'mobile first, cloud first' approach.

  • Microsoft SQL Server Management Studio (SSMS)

    Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure.

  • Microsoft SSIS (SQL Server Integration Services)

    Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database.

  • O

    OLE DB (OLEDB or Object Linking and Embedding Database)

    OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources.

  • Q

    query

    A query is a question, often expressed in a formal way. A database query can be either a select query or an action query.

  • R

    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

  • 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 (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.

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

  • SQL Server Reporting Services (SSRS)

    SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, mobile and printed reports using SQL Server and other data sources.

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

  • trigger

    A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm.

  • U

    U-SQL

    U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments.

  • Y

    Yukon

    Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them easier to create and deploy, thus reducing the complexity and tedium involved in database management.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close