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

  Buffer Pool Extension is a feature that was introduced in SQL Server 2014. With this feature, SQL Server uses the disk we specified for …

  In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …

  Postgresql is one of the RDMS databases presented in simple form. Therefore, we need to install the extension to use dblink, Foreign Data Wrapper, …

  If you don’t use PG ADMIN or any other similar application and you want to see the data type in the columns of the …

SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …

A script that you might need during database scaling. Calculation of transaction numbers between two specific dates. This script was tested in 11gR1 and 11gR2. …

  In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-69ef92c5d8b96688382791/] [crayon-69ef92c5d8b99494459331/] or [crayon-69ef92c5d8b9b043330564/] or [crayon-69ef92c5d8b9c256949168/] …

  In this article I’ll tell you how to stop Oracle Audit Vault Services. You should follow below sequence of steps: [crayon-69ef92c5d92e0171155747/] [crayon-69ef92c5d92e3134284995/] [crayon-69ef92c5d92e5175302052/] [crayon-69ef92c5d92e6447861477/] …

  Unplanned outages are very expensive, and the cost of downtime is rising as almost all mission critical systems are fully automated. Industries like banking …

  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 …