TERADATA

Teradata – Secure Zones

Secure Zones This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides…

0 Comments

August 13, 2018

Sybase

Tracking configuration changes in SAP ASE 16

Introduction A principal component of a protected system is accountability. One way to ensure accountability is to examine events on…

0 Comments

August 13, 2018

ORACLE

Unable to start Enterprise Manager Database Control

Error: When the database is upgraded to version 10.2.0.4 or 10.2.0.5, the Enterprise Manager configuration ends with an error and…

0 Comments

August 12, 2018

MSSQL

Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition .

  For Always on Perrequisite Refer Document http://dbtut.com/index.php/2018/08/09/prerequisite-for-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition/   Specify the name of the Availability that you want to create.…

0 Comments

August 12, 2018

MSSQL

How To Get Script of Some Objects in the Database On SQL Server(Generate Script Method)

  We explained how to get the create script of all objects belonging to the database in the article titled…

0 Comments

August 11, 2018

MSSQL

How To Find Partitioned Tables In The Database On SQL Server

  I mentioned that we can not get the script of the partitioned tables by right clicking on the SSMS…

0 Comments

August 11, 2018

MySQL-MariaDB

Concurrent MySQL client

CCQL: CCQL is a tool that allow user to connect multiple mysql server node Concurrently at the same time. It…

1 Comment

August 10, 2018

MongoDB / NoSQL

Creating New Replica Set Configuration

Replica set configuration on ‘n’ node Replica: We generally have 3 nodes replica set with 1 Primary and 2 secondaries. Below are the…

0 Comments

August 10, 2018

MongoDB

MongoDB Version 3.6 Upgrade Process

Important Note : Following features are deprecated in 3.6 'rest = true' and 'httpinterface = true' these options need to…

0 Comments

August 10, 2018

ORACLE

RMAN : PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared

Error: When connecting to rman, "PLS-00201: identifier 'DBMS_BACKUP_RESTORE.SET_CHARSET' must be declared" error and connection could not be established. Reason: Problematic…

0 Comments

August 10, 2018