MongoDB
MongoDB Database. Installation, Administration and Maintenance
MS SQL Server
MS SQL Server Knowledge Base Articles and SOP.
MySQL
MySQL Database. Installation, Administration and Maintenance
Interview Questions
Interview questions for Oracle DBA and MS SQL Server
MariaDB
MariaDB Database. Installation, Administration and Maintenance
How to check mySQL version
Commands to check client and server versions in MySQL Check client version: mysql --version Check server version: mysql> select @@version; […]
How to check Execution Plan in SQL Server
SQL server Performance || SQL Server Execution Plan || Query Execution Plan || SQL Server Blocking SELECT SPID,ER.percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as […]
How to check SQL Server login Password expiration
SQL Server login Password expiration || SQL Server Login Password Enforce Policy || Reset Passwords SELECT SL.name AS LoginName ,LOGINPROPERTY […]
How to identify Version_store in TempDB
Temp DB Issues || SQL Server Temp DB || What is Version_Store ? How to identify Version_store SELECT GETDATE() AS […]
SQL Server Buffer catch Hit Ratio
SQL Server Buffer catch Hit Ratio || What is The Default Settings Of Buffer Catch Hit Ratio SELECT object_name, counter_name, […]
SQL Server Long Running Query
How to check SQL Server Performance issues || SQL Server Long Running Query || SQL Server Query Running Slow SELECT […]
MS SQL Server Notes
1. SQL Server Versions: SQL Server 1.0 SQL Server 4.0 SQL Server 6.0 SQL Server 7.0 SQL Server 8.0 (SQL […]
How to Upgrade TFA in Oracle RAC
TASK: Upgrade TFA to latest version in 2 Node Oracle RAC. High Level Steps: 1. Check the current version and […]
How to do export using network_link in Oracle
Below are the steps to take export backup using the NETWORK_LINK parameter. How to do export using network_link in Oracle […]
How to Remove Orphan Files from Oracle ASM
Use below sql query to identify the orphan files in Oracle ASM and remove them to clear the space. In […]
How to Drop Database in Oracle RAC
Below are the steps to drop the database in Oracle RAC 1. Check and verify the database services: [oracle@dborg01 ~]$ […]
How to Drop Disk in Oracle ASM
Dropping Disk in Oracle ASM 1. Allocate new LUNs to the server, same number and size 2. Rescan server so […]