SQL Server Definitions

  • M

    Microsoft GeoFlow

    Microsoft GeoFlow is a three-dimensional data visualization mapping tool for Microsoft Excel.

  • Microsoft PowerPivot

    PowerPivot is a free Microsoft Excel tool that increases the capabilities of Excel's pre-existing pivot table tool by allowing users to import data from multiple sources.  

  • 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 SQL Server Parallel Data Warehouse (SQL Server PDW)

    Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) is a pre-built data warehouse appliance that includes Microsoft SQL Server database software, third-party server hardware and networking components.

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

  • Microsoft Visual FoxPro (Microsoft VFP)

    Microsoft Visual FoxPro (VFP) is an object-oriented programming environment with a built-in relational database engine.

  • MOLAP (multidimensional online analytical processing)

    MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database.

  • multidimensional expressions (MDX)

    multidimensional expressions (MDX)

  • O

    ODL (Open and Distance Learning)

    Open and Distance Learning (ODL) is a general term for the use of telecommunication to provide or enhance learning.

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

  • OPAC (Online Public Access Catalog)

    An OPAC (Online Public Access Catalog) is an online bibliography of a library collection that is available to the public.

  • P

    pivot table

    A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.

  • primary key (primary keyword)

    A primary key, also called a primary keyword, is a key in a relational database that is unique for each record.

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

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close