Reset the Root Password of MySQL on Windows

12:20 Database administation, 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

09:45 Database administation, 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

Manage Transaction Concurrency Using Locks in SQL Server

11:07 Database administation, 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

10:27 Database administation, 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

09:38 Database administation, 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

15:02 Database administation, 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

02:06 Database administation, 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

00:26 Database administation, 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

17:59 Database administation, 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

11:56 Database administation, Security

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