Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Have you noticed that relational "technology" seems to be taking a beating these days? With new “data models” and types of database systems purported to be better than relational, it seems that the ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...

When it comes to providing reliable, flexible, and efficient object persistence for software systems, today's designers and architects are faced with many choices. From the technological perspective, ...

The heart of any relational database management system is the system catalog that documents the database objects and system settings being used. The system catalog offers a wealth of information about ...

Airtable is an online platform for creating, using, and sharing small relational databases. It’s not ready for enterprise users yet (that’s coming), but right now, if you want help managing data for ...