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

In today’s article, I will be giving you information about active, inactive and other Session Statistics in the database. Active Session Statistics 1. We can …

In today’s article, we will cover retrieving data from MongoDB with PolyBase; PolyBase allows us to retrieve data from multiple sources and combine them into …

In today’s article, we will discuss checking for LOCKs in the database, which is one of the checks we perform when there is a problem …

In this article, we will see how to query a table in PostgreSQL by defining it as an external table in SQL Server. First, we …

This error is occurs because the statistics belonging to the External Table cannot be collected while collecting the statistics belonging to the tables. Solution: We …

In today’s article, we will be talking about What is Polybase? and how we can extract data from SQL to SQL with Polybase. Polybase is …

In today’s article we will be discussing how to remove GoldenGate in Oracle. The GoldenGate application is automatically removed by following the steps below. 1. …

In today’s article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0. Before starting the GoldenGate installation, GRID, RDBMS and Database are installed …

In today’s article, you can use the script below to see questions such as how much RAM is used in SQL Server? How much of …

In today’s article, we will be talking about the three basic commands of Oracle Enterprise Manager: Start, Status and Stop. 1. Start OEM; [crayon-67d3880e309e2930204571/] 2. …