Moving from SQL to MongoDB is mostly a change of vocabulary plus a new way to join. This post maps SELECT, WHERE, ORDER BY, GROUP BY and JOIN to find, sort, $group and $lookup, and tests each one on a small vegetarian shop.
MongoDB deleteMany: The Empty Filter That Deletes Everything
MongoDB deleteMany removes every document that matches a filter, and an empty filter matches all of them. This post tests deleteOne, deleteMany, findOneAndDelete and the two quiet traps: a misspelled field and a filter built from an unset variable.
MongoDB updateOne: $set, $inc and Upserts Without Surprises
MongoDB updateOne changes one document, and its result object shows how many documents matched and how many changed. This post tests $set, $inc, updateMany, upserts and the replaceOne mistake that wipes every other field.
MongoDB find: Filters, Projections and Sorting for SQL People
MongoDB find returns the documents that match a filter. This post tests find, findOne, $gt, $in, $and, $or, projection, sort, limit and countDocuments on 18 grocery products, each next to its SQL equivalent.
MongoDB insertOne and insertMany: Adding Documents the Right Way
MongoDB insertOne adds a document and insertMany adds a list. This post tests both with a unique index, a generated _id and a duplicate key in the middle of a batch, comparing ordered: true with ordered: false and showing what landed.
Getting Started With mongosh: Databases, Collections and Documents
mongosh is the shell that connects you to MongoDB. This post connects, creates a database and a collection on the first write, and stores a document. It explains the _id, the BSON types and the habits that surprise SQL Server people.
How to Know Backup Speed in SQL Server? – Interview Question of the Week #277
Question: How to Know Backup Speed in SQL Server?
Answer: It is very simple to know the backup speed in SQL Server. Let us discuss today.
HAS_DBACCESS Function: List the Databases You Can Open
The HAS_DBACCESS function tells you whether the current login can open a database. One query over sys.databases turns it into a list, and this post tests six databases to show what each zero means: no user, offline, restricted or a busy single user slot.
Memory-Optimized TempDB Tables: List Them and Check Status
Memory-optimized TempDB tables are the system tables that SQL Server 2019 and later can keep in memory. This post shows two queries: one that checks whether the feature is on, and one that lists the tables it covers. It also explains the limits that come with the feature.
Metadata Contention in TempDB: When Memory-Optimized Metadata Helps
Metadata contention in TempDB happens when many sessions create and drop temporary tables at the same moment. This post reads the waits that point to it, explains why RESOURCE_SEMAPHORE is a different problem, and shows how SQL Server 2019 and later can keep that metadata in memory.










