RajKishore 
In this Azure SQL tutorial, you will know what is Azure SQL. We have discussed the features of Azure SQL, things you should consider before buying a plan, and a number of frequently asked questions. Introduction to Azure SQL What is Azure SQL? The Azure SQL is a cloud-based SQL Server environment that where you … Read more >>
In this MongoDB tutorial, we will learn how to create backup and restore databases in MongoDB on different operating systems. these are the topics we are going to cover How does we create a backup of database in Windows Why do we backup The main reason for the backup is to make a copy of … Read more >>
This article is about How to Install MongoDB. In this topic, we will cover various operating systems where how we can easily install MongoDB and start the MongoDB server. These are some of the OS that we are covering: While talking about MongoDB, It supports many platforms, there are the following operating systems that are … Read more >>
In this article, I will explain how I encountered the error “SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’.” Also, I will explain what I did to resolve this error. Problem: Recently, when I was working with SQL Server stored procedures, I wanted to create a stored procedure that creates a directory in … Read more >>
Are you new to SQL Server? Stored procedures are very important in SQL Server. In this tutorial, we will learn what is a stored procedure in SQL Server? How to create a stored procedure in SQL server 2019, Advantages of using SQL Server stored procedure. Also, we will check how to execute and alter a … Read more >>
In this sql server tutorial, we will discuss how to fix the error message “Msg 15123: The configuration option ‘xp_cmdshell’ does not exist, or it may be an advanced option.“ sql the configuration option ‘xp_cmdshell’ does not exist or it may be an advanced option Recently, when I was working with SQL Server 2019, I … Read more >>
This tutorial is about the loops in SQL Server stored procedure. You will learn how loops work in stored procedures. You will see a number of examples of loops in stored procedures in SQL Server. SQL Server stored procedure for loop SQL Server does not support FOR loop. However, you can use the WHILE loop … Read more >>
In this MongoDB tutorial, let us see how to fix the error, “MongoDB shutting down with code 100“. We will also see the root cause of the issue. Why shutting down with code 100 in MongoDB While starting MongoDB, I recently got an error like “MongoDB shutting down with code 100“. It looks like below: … Read more >>
In this article, we will discuss the error message “Msg 567: Unable to retrieve data for this section of the report. Following error occurred. File is not a recognizable trace file.“ Problem I encountered this error while I was working with the Log files. I was trying to get various information about the stored procedures … Read more >>
In this article, we will discuss an error “Msg 266: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements.” that I faced when I was working with the SQL Server transactions and stored procedures. I will describe how I encountered the issue. Also, I will explain the cause and solution of … Read more >>