Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  To deploy Cloudera Manager and CDH on an Google Compute VM instance, begin by creating an environment. The environment defines common settings, like region …

  1:- Enable oplog using –master option while starting mongod service [Version 3.2]. And later version (3.2 +) need to put replSetName=rs0 into the mongo.conf file in …

  As a high-level security measure in SQL Server, if you do not want application developers to know the application’s user password, this article will …

  You can download the MySQL binary files from below link. https://downloads.mysql.com/archives/get/file/mysql-5.7.21-el7-x86_64.tar.gz 1:- Add OS group [crayon-686113b51f7a7331248609/]   2:- Add OS user [crayon-686113b51f7ab392477358/]   3:- …

ERROR: In Oracle 11g r2 database rman crashes during exit and gives error like DBGMISC: ENTERED crmkmrsr. REASON: Inconsistency in NLS settings. (This is specified …

  If all the indexes in the partition table are not aligned according to the partition, you will get an error like the following during …

  Introduction A service broker is a high availibity technique in SQL Server which was introduced from SQL Server 2005. This is primarily to send …

Error: When trying to connect with rman “ORA-01008: not all variables bound” error is occured. Reason: Bug 10306699 Solution: You need to set the cursor_sharing …

  I explained how to create a partition int the article named “How To Create Partition On SQL Server“. In this article I will share …

  During a typical revision of mongod’s logs, we could find slow queries, by default, those queries that take more >100ms. You can change this time …