This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of an open glossary bridging relational tables and document folders

SQL Terms vs MongoDB Terms: A Practical Glossary

April 18, 2020
Pinal Dave
SQL Tips and Tricks
JSON, MongoDB, NoSQL, SQL Server

SQL terms vs MongoDB terms trip up teams that use both products. This glossary maps tables, collections, rows, documents and fields, shows tested SQL Server queries beside the mongosh equivalents, and marks where the vocabulary stops matching.

Read More
Gouache painting of a simple three-legged wooden stool on a wooden floor, one leg noticeably shorter and painted vermilion, the stool still balanced but tilted slightly against a plain wall in soft daylight.

What Is NoSQL? Data Models, the CAP Theorem and Trade-Offs

October 7, 2013
Pinal Dave
SQL Tips and Tricks
ACID, JSON, MongoDB, NoSQL

What Is NoSQL? It is a family of data models other than the classic table, each built for one kind of access pattern. This post covers the four data models, eventual consistency and the CAP theorem in plain words, and how to choose.

Read More
A wooden crate with fitted compartments holding bottles upright beside a loose canvas sack of potatoes on a pantry floor.

SQL or NoSQL for a New Project

July 30, 2013
Pinal Dave
SQL Tips and Tricks
Database, MongoDB, NoSQL, Software Development

Choose SQL or NoSQL for a new project by testing data shape, consistency needs, query patterns, and the skills the team can operate.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com