microsoft DB – Microsoft DB

SQL

November 2, 2023November 2, 2023adminLeave a Comment

which stands for Structured Query Language, is a language used to add, update, and remove data from databases as well as modify the metadata related to those databases. SQL Commands or Types of languages in SQL In order to perform specific data-related tasks, SQL commands are queries sent to the database. Apart from database searches, […]

SQL Server – ACID Properties

December 25, 2024December 25, 2024adminLeave a Comment

ACID Properties ACID (atomicity, consistency, isolation, durability) is a set of properties that guarantee that database transactions are processed reliably. Atomicity: Atomicity requires that each transaction is “all or nothing”: if one part of the transaction fails, the entire transaction fails, and the database state is left unchanged. Consistency: The consistency property ensures that any […]