Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
MySQL Enterprise Monitor is a tool that register several MySQL Instances and provide complete details i.e. performance graphs and other details for analysis, Costly …
Read More »Engr. Mohammad Rizwan Yasin
MySQL Auditing
MySQL Community Edition: MySQL Community Edition having feature of auditing but I cannot having feature filter the users To activate audit log: [crayon-66a469db3c3d9537154197/] …
Read More »MySQL Enterprise Backup
Pre-requites: Must have MySQL Enterprise Edition installed Download media file : meb-4.1.0-el6.x86_64.rpm (For Linux Platform) Installation of MySQL Enterprise Backup Command to install …
Read More »How To Migrate MSSQL Server Logins To Another Instance
Step 1: Create SP sp_help_revlogin on master database of Source / Primary instance The following script create two stored-procedures. You will use the first one …
Read More »MSSQL Server Availability Group(AG) : Fail-over Clustering with Secondary Replica
To create Availability Group(AG) Fail-over SQL Server Cluster with secondary replica we need 4 machines/VMs which are as follows Domain Controller: Machine Name: DC 192.168.1.71 …
Read More »Sybase ASE Migration from Physical to Virtual Machine
Pre-Migration : Questionnaire That need to ask from the client before planning to migrate SAP Sybase ASE database servers from physical machines to virtual. …
Read More »SAP Sybase ASE Warm Standby Database using Replication Server
We are going to create warm standby backup of SAP Sybase ASE Prod1 server to Standby1 server using Sybase Replication Server REP15_7 for a database …
Read More »