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...
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 facts about standard database auditing,...
Database Security in Oracle
There is no secret that information makes the world go around currently. If an enterprise takes...
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. Providing a user with excessive...
Transparent Data Encryption and Always Encrypted
If you need to store confidential data in your database, you can use data encryption. SQL Server...
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 transaction or without a transaction) will...
SQL Server Database Backup Encryption
To manage the data security that has been backed up by the file system as a database backup files,...
