Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Percona Xtrabackup is open source backup solution for Percona & mysql server. It will not block the database or very minimal lock while performing …
Read More »
How To Detach and Attach a Database Containing FileStream Data
You may want to move a database containing “File Stream” data to another disk with the detach attach method. Moving a database containing “File Stream” …
Read More »Running SQL Server With High Performance(High Performance)
It is a setting made on windows so that SQL Server can work with higher performance. This setting can be made on Windows Server …
Read More »Enterprise Manager OC4J Configuration issue
ERROR : OC4J Configuration issue. <ORACLE_HOME> / oc4j / j2ee / OC4J_DBConsole_ <SERVER> _ <SID> not found. SOLUTION : The passwords of sysman and dbsnmp …
Read More »EMC flash drive as Temp database device
Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB …
Read More »ORA-01552: cannot use system rollback segment for non-system tablespace ‘XXXX’
The problem was that the UNDO table space had several data files in recover mode. SOLUTION : Problematic files are recovered from backup and …
Read More »What is Contained Database and How To Create
We mentioned the Contained Database in our article titled “How To Move Logins To Another Instance (sp_help_revlogin)“. A Contained Database is a type of …
Read More »Bash Script for Backup of Mysql Users & Privileges
Below is a simple script which backup Mysql users & grants into separate sql file. So,if you are taking particular database backup then this …
Read More »How To Improve Database Performance on MongoDB Part 1
This little guide is medium in scope, it is not exhaustive. It just gives you an idea to focus 1 Choose the right storage …
Read More »RDS to RDS Database Refresh-Oracle
This document covers steps involved in refreshing an Oracle database schema where source and target both are AWS RDS databases Prerequisites: RDS Instances …
Read More »