Security

Reset the Root Password of MySQL on Windows

Database administration, MySQL, Security

When we install MySQL on Windows, we usually specify the password of the root user. This helps keep...
Read More

Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases

Database administration, Security

There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what...
Read More

Locking in SQL Server: Detailed Overview

Database administration, Security

In a multi-user environment, it is essential to maintain truncation concurrency. These locks are in-memory structures of 96 bytes in size....
Read More

Understanding SQL Server Lockdown to Secure Database Environment

Database administration, Security

Security is the main concern these days in every sector. Database Security is also a major worry...
Read More

Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel

Database administration, PostgreSQL, Security

PostgreSQL is a well-known relational database management system that boasts a secure environment for developers and users. But as remote...
Read More

Deploying a Certificate for Encrypted Connection SQL Server

Database administration, Security

Introduction Last year we got a requirement to ensure encrypted connections to our SQL Server instances. Before, we did not think it was...
Read More

Using Alerts and Operators in SQL Server

Database administration, Database Optimization & Structure, Security

Introduction With all the advancements in SQL Server and data, it feels great that such native SQL...
Read More

Understanding SQL Server Always Encrypted

Database administration, Security

Security is one of the most important requirements for a data-driven system. Encryption is one of the ways to secure the data. Wikipedia...
Read More

In-depth Exploration of Row Level Security

Database administration, Security

Introduction Organizations are becoming more and more concerned about how to reduce the cost of licensing database solutions using...
Read More

Introduction to Row-Level Security in SQL Server

Database administration, Security

Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default...
Read More
Close