If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.
SQL SERVER – Validating Positive Integer Strings with Explicit Boundaries
To Validate Natural integer strings, I define a nonempty positive ASCII-digit contract. A customer wanted a simpler validator.
How to Alter Index to Add New Columns in SQL Server? – Interview Question of the Week #278
Question: How to Alter Index to Add New Columns in SQL Server?
Answer: It is not possible to Alter Index definition to add or remove columns.
SQL to MongoDB: Mapping SELECT, WHERE, GROUP BY and JOIN
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.