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.