Introduction to Row-Level Security in SQL Server
Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default...
Essentials and usage of NOLOCK hint in SQL Server
The main idea of the SQL Server locking mechanism is that it controls the consistency of transactions. According to this principle, if a...
Main concept of SQL Server locking
In this post, we will discuss the SQL Server lock mechanism and how to monitor SQL Server locking with SQL Server standard dynamic...
Oracle Database Security: Database Auditing
In this article, I will continue with Oracle Database Security and I will present some important...
Database Security in Oracle
There is no secret that information makes the world go around currently. If an enterprise takes care of its intellectual property and each...
Oracle Database Security – Encryption and Decryption
Data encryption is very important because it’s a way to protect the current and the archived data in order to ensure its confidentiality....
Setting Database Access Permissions
Server security mainly depends on how correctly you can configure access permissions on objects....
Transparent Data Encryption and Always Encrypted
If you need to store confidential data in your database, you can use data encryption. SQL Server supports encryption with symmetric keys,...
SQL Server Security Ponderings
DBA is the guardian of the data, and there are two aspects of being a guardian. The first one is integrity. It includes tasks like checking...
Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL
Read Uncommitted If data is being changed in one transaction, selection of this data (in other...
