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