Tools and Utilities 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).

  • C

    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.

  • D

    data aggregation

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

  • I

    In-Memory OLTP

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

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

  • S

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

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close