In this post, I just wanted to share some technical words here again it is good to know:
- OLAP: On Line Analytical Processing
- MOLAP: Multidimensional On Line Analytical Processing
- ROLAP: Relational On Line Analytical Processing
- HOLAP: Hybrid On Line Analytical Processing
- RTOLAP: Real Time On Line Analytical Processing
- DOLAP: Desktop On Line Analytical Processing
- SSIS: SQL Server Integration Services
- SSAS: SQL Server Analysis Services
- SSMS: SQL Server Management Studio
- SSRS: SQL Server Reporting Services
- Magic Table: A temporary table use at the time of trigger
- DML: Data Manipulation Language (Insert/Update/Delete)
- DDL: Data Definition Language (Create /Alter /Drop)
- DCL: Data Control Language (Grant /Revoke)
- TCL: Transaction Control Language (Rollback /Commit)
- ACID: Atomicity, Consistency , Isolation ,Durability
- PK: Primary Key
- FK: Foreign Key
- NF: Normal Form (1NF,2NF,3NF)
- ODBC: Open Database Connectivity
- OLEDB: Object Linking and Embedding Database
- RDBMS: Relational Database Management System
- CRUD: Create, Read , Update, Delete
- ETL: Extract Transform Load
- BI: Business Intelligence
- SP: Stored Procedure
- VLDB: Very Large Data Base
- CTE: Common Table Expression
- CDC: Change Data Capture
- TDE: Transparent Data Encryption
I will add more in future.
Thanks & enjoy !!!
Filed under: CodeProject, Database, DENALI, SQL Server, SQL SERVER 2008 - R2, SQL SERVER 2014, SSIS, SSRS, TIPS
Tagged: SQL JARGON, Sql server, TIPS
