Showing posts with the label RDBMSShow All

Benchmarking of Relational DB

To show benchmarking, below General Purpose mysql RDS created SHOW VARIABLES  LIKE   "%version%" ;

Read more

How to implement Row-Level Security in Azure SQL Database or SQL Server

Some one of you prefer view-based workarounds for row-level filtering. The benefits of using Row-Level Security (RLS) instead of views include: RLS reduces code complexity by centralizing access logic in a security policy and eliminating the need for an ex…

Read more

DBMS - Concurrency Control

A transaction is a collection of instructions. To maintain the integrity of a database, all transactions must obey ACID properties.  ACID  is an acronym for below Atomicity   − this property states that a transaction must be treated as an atomic unit, that is, …

Read more