-
Sql Server – TDE encryption on always on
•
TDE.sql Step 1: Database Master Key (DMK) on the primary replica first, you can check if your instance already has a database master key if the result came empty means no master key created since the result came empty we will create master key using the below qurey now we have master key with…
-
Sql server database backup in details
•
What Is a Transaction Log? Transaction log is a list of records for all Microsoft SQL database changes. It is an essential component of the SQL Server database. If there is a system failure, you will be able to use the T-log to bring your database back to a consistent state before the point…
-
Sql Server how to Manage transaction logs
•
Managing transaction logs Transaction managing in simple mode : here we will test log managing in both simple mode and full mode . i have created two database one full one simple mode added table on it then i will run trsnaction but i will not commit the transaction you can see the qurey…
-
Health check using pgmetrics
•
One of the key tasks for any PostgreSQL DBA is conducting daily health checks to ensure the database remains healthy. Performing these checks is critical as it helps identify potential issues and resolve them before they impact production. PostgreSQL provides several views to monitor various metrics such as wait states, CPU usage, I/O, and…
-
PostgreSql how to sperate data directory for data dir
•
When installing PostgreSQL, it defaults to creating its data directory in /var/lib/postgresql. For better performance, reliability, and management, it is often recommended to relocate the PostgreSQL data directory to a dedicated disk or separate mount point. This can help with I/O performance, backup management, and isolation of database operations from the rest of the…