SQL Server Administration Definitions

  • D

    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.  

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close