Backup and Restore MySQL Database
Introduction: In this article, we are here to know different ways to generate the backup in the MySQL database server. It is essential to make regular backups of all data…
Read MoreMYSQL DB SWITCHOVER
INTRODUCTION: This doc will guide you through the process of performing a MySQL replication switchover, ensuring a smooth transition without any data loss. Let’s dive into the step-by-step instructions. Step…
Read MoreCREATING MAINTENANCE PLAN FOR BACKUP
A maintenance plan is a set of measures (workflows) taken to ensure that a database is properly maintained and routine backups are scheduled and handled. Login to the server Go…
Read MoreIdentify and remove unused indexes in SQL Server
Identify and remove unused indexes in SQL Server Introduction: Indexes means order information about data, with indexes we can retrieve data from the database more quickly than otherwise. Index…
Read MoreControlling visibility of databases and server level setting by Contained Database
Controlling visibility of databases and server level setting by Contained Database Introduction: Contained Database is a new feature of SQL Server 2012. A contained database is a database that is…
Read MoreDatabase Migration from Non-ASM to ASM
We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands Check the ASM instance is up and running If not…
Read MoreHow to install POSTGRESQL and PGADMIN on linux 7 (REDHAT,CENTOS,ORACLE LINUX)
INTRODUCTION: This doc will guide you through the process of installing Postgresql14, Pgadmin4 and also Creating users, databases, schemas VERSION: PostgreSQL14 PGAdmin-4 Verify Platform compatibility using below link https://www.enterprisedb.com/resources/platform-compatibility…
Read MoreCloning Tables Between Databases in SQL Server Using Export and Import Functions
Overview: Cloning tables between databases in SQL Server can be efficiently achieved through the use of the built-in export and import functions. This process involves exporting data from the source…
Read MoreINSTALLATION OF OEM 13.5 USING SILENT METHOD IN ORACLE DATABASE 19.3 ON LINUX.
OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used for integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents, Common Services and Tools to provide…
Read MoreWorkspace login is not working
Issue: When user was trying to login Apex with workspace login, getting error like below. Solution: Need to login Apex as Admin user. Click on Manage Workspaces>Manage Developers and…
Read More