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, …
Read More »Session Statistics
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 …
Read More »Retrieve Data From MongoDB With PolyBase
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 …
Read More »Lock Control In Database
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 …
Read More »Data Transfer From PostgreSQL To SQL Server With PolyBase
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 …
Read More »ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
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 …
Read More »What Is PolyBase In SQL Server
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 …
Read More »Oracle GoldenGate Deinstall
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. …
Read More »Install Oracle GoldenGate 12.2.0.0.0
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 …
Read More »SQL Server Usage Memory
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 …
Read More »