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 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 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 Azure SQL tutorial, I will explain what are schemas and how to manage them in an Azure SQL database. I will explain how you can create, view, alter and delete a schema in the database. I will create and explain multiple examples of managing schemas in an Azure SQL database. What is schema … Read more >>
In this Azure SQL tutorial, I will share how I resolved the error Cannot bulk load because the file could not be opened. Operating system error code (null). Cannot bulk load because the file could not be opened. operating system error code (null) Recently, when I was working with the BULK INSERT statement in the … Read more >>
In this Azure SQL tutorial, I will explain how I encountered the error “cannot drop schema because it is being referenced by object” and how did I resolve it. Cannot drop schema because it is being referenced by object I was trying to delete a schema in Azure SQL database using the DROP SCHEMA statement. … Read more >>
In this MongoDB tutorial, we will understand distinct query in MongoDB. We will cover this topic with different operations and examples. Additionally, we will also discuss the following topics: Distinct query in MongoDB MongoDB finds the distinct values for a defined field over a single collection. The distinct method will return a document that contains an array … Read more >>
In this MongoDB tutorial, we are going to discuss “display MongoDB data in HTML”. Additionally, we will also discuss the following topics: Display MongoDB data in HTML In this topic, you will learn the display MongoDB data in HTML. Let’s understand the theory behind displaying MongoDB data in HTML Between the HTML presenting your data and your … Read more >>
In this MongoDB tutorial, we will understand the Current date in MongoDB. We will cover this topic with different operations and examples. Furthermore, the following topics will cover: The current date in the MongoDB query In this topic, you will learn to create the current date field in MongoDB. The following two ways return date as a … Read more >>