Bijay 
In this MongoDB tutorial, I will explain how I managed to resolve the error “MongoDB data directory /data/db not found”. We will cover the solution of this by using the different operating systems. MongoDB data directory /data/db not found in windows Recently, when I installed the MongoDB database in the Windows operating system. I didn’t find any … Read more >>
In this Azure SQL article, you will learn how to view the most recent Azure SQL database query history. The query history of a database means the queries that are recently executed on that database. I will explain various techniques to see Azure SQL database query history. How to view the query history of an … Read more >>
In this Azure SQL tutorial, we will discuss various aspects of a read-only database in Azure SQL. We will discuss, what is a read-only database in SQL, how to make a database read-only in Azure and vice versa, advantages and disadvantages of a read-only database. Introduction In real-time scenarios, you have a primary database and … Read more >>
In this MongoDB tutorial, we are going to discuss how to compare two fields in MongoDB. We will cover this topic with different operations and examples. These are the following topics that we are going to cover in this tutorial: MongoDB compare two fields query MongoDB compare two fields equal MongoDB compare two fields not equal MongoDB … Read more >>
In this PostgreSQL tutorial, we will learn about “Postgresql while loop” and cover the following topics. Introduction to while loop When we need to perform the same task again and again then we use the while loop or while loop is used where the task is repetitive. Suppose that we want the population of the city … Read more >>
In this PostgreSQL tutorial, we will learn about “Postgresql regexp_replace” and cover the following topics. Postgresql regexp_replace In Postgresql, the REGEXP_REPLACE function replaces substrings that match a POSIX regular expression with a new substring. The syntax of regexp_replace is given below. Where the source is a string where the replacement will take. pattern: The pattern … Read more >>
In this SQL Server tutorial, we will understand How to test stored procedure in SQL Server. Additionally, we will also discuss the following topics How to test performance of stored procedure in SQL Server In SQL Server, we can check and test the performance of a stored procedure by using the SQL Server Management Studio. Moreover, in … Read more >>
In this tutorial, we will learn about bulk loading data to Azure SQL and see various bulk inserting techniques along with some examples. Bulk import and export to Azure SQL database Bulk importing or bulk loading means importing a large amount of data from a file into a database. If you encounter the need to … Read more >>
In this MongoDB tutorial, we will learn how to change the collection name in MongoDB. We will cover this topic with different operations and examples. These are the following topics that we are going to cover in this tutorial: Change the collection name in the MongoDB In MongoDB, you can use the renameCollection() method to rename … Read more >>
In this SQL Server tutorial, we are going to talk about SQL Server scheduled stored procedure. Here we will learn about different methods of scheduling a stored procedure in SQL Server. And we will also understand the following topics. SQL Server scheduled stored procedure In this section, we will try to understand how to schedule a stored … Read more >>
Download A 40 pages PDF And Learn Now.