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

In SQL Server, we may sometimes need to check which machine has established a connection and how many connections are being made. In today’s article, …

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 …