Reset the Root Password of MySQL on Windows
When we install MySQL on Windows, we usually specify the password of the root user. This helps keep...
Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases
There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what...
Locking in SQL Server: Detailed Overview
In a multi-user environment, it is essential to maintain truncation concurrency. These locks are in-memory structures of 96 bytes in size....
Understanding SQL Server Lockdown to Secure Database Environment
Security is the main concern these days in every sector. Database Security is also a major worry...
Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel
PostgreSQL is a well-known relational database management system that boasts a secure environment for developers and users. But as remote...
Deploying a Certificate for Encrypted Connection SQL Server
Introduction Last year we got a requirement to ensure encrypted connections to our SQL Server instances. Before, we did not think it was...
Using Alerts and Operators in SQL Server
Introduction With all the advancements in SQL Server and data, it feels great that such native SQL...
Understanding SQL Server Always Encrypted
Security is one of the most important requirements for a data-driven system. Encryption is one of the ways to secure the data. Wikipedia...
In-depth Exploration of Row Level Security
Introduction Organizations are becoming more and more concerned about how to reduce the cost of licensing database solutions using...
Introduction to Row-Level Security in SQL Server
Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default...
