If you no longer need a collection in MongoDB, you can delete it.
Actually, the term for deleting a collection is to drop the collection.
Either way, here are two ways to delete/drop a collection when using the mongo shell.
Continue reading4 Ways to List the Collections in a MongoDB Database
When using MongoDB, there’s more than one way to list the collections in a database.
Here are four ways to get a list of collections in a MongoDB database:
- The
show collectionsCommand - The
listCollectionsCommand - The
db.getCollectionNames()Method - The
db.getCollectionInfos()Method
MongoDB Upsert Explained
Many update operations in MongoDB have the potential to be upserts. An upsert is a combination of an insert and an update.
It works like this: You perform an update operation based on filter criteria, and if there are any matches, only the matched documents are updated, but if there are no matches, then a new document is inserted.
Continue readingCreate a Collection in MongoDB
When you create a database in MongoDB, your database is basically an empty container for which you can add one or more collections to.
A collection is analogous to a table in relational databases.
In relational databases, you can use CREATE TABLE to create each table that you want in the database.
But MongoDB is not a relational database, and it stores its data as documents. Each document is stored in a collection.
This article shows you how to create a collection in MongoDB.
Continue readingCreate a Database in MongoDB
MongoDB doesn’t have a CREATE DATABASE statement like SQL does.
In MongoDB, you create a database simply by switching to a non-existent database, then inserting data.
Continue readingInstall MongoDB on Windows
MongoDB is a general purpose, document-based, distributed data platform built for modern application developers and for the cloud.
MongoDB is classified as a NoSQL database. It uses JSON-like documents with optional schemas.
You can use MongoDB as a cloud deployment, or as an on-premise installation.
In this tutorial, I install it as an on-premise installation using the MongoDB Community Edition on Windows.
Continue readingInstall MongoDB on a Mac
MongoDB is a general purpose, document-based, distributed data platform built for modern application developers and for the cloud.
MongoDB is classified as a NoSQL database. It uses JSON-like documents with optional schemas.
This tutorial shows you how to install MongoDB on a Mac via Homebrew.
Continue reading4 Ways to Get a List of Schedules in SQL Server Agent (T-SQL)
In this article, I present four options for using T-SQL to return the schedules that are attached to a SQL Server Agent job.
Continue readingCreate a SQL Server Agent Job in Azure Data Studio
In this article, I show you how to create a SQL Server Agent job in the Azure Data Studio GUI.
Here, I create a test job that includes one job step and an attached schedule.
Continue readingCreate a SQL Server Agent Schedule with T-SQL
When using T-SQL, you can use the sp_add_schedule stored procedure to add a SQL Server Agent schedule.
This procedure creates the schedule, but it doesn’t attach it to any jobs. To attach it to a job, you must use the sp_attach_schedule procedure.
You can also use sp_add_jobschedule to create the schedule and attach it all with the same procedure.