At my last job I worked on a monolith that sat on top of a NoSQL database. Our DAOs were fairly simple beasts that did mostly CRUD operations and some non-trivial finds. For the vast majority of data, ...

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 ...

Designing an appropriate set of indexes can be one of the more troubling aspects of developing efficient relational database applications. Perhaps, the most important thing you can do to assure ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.

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 ...

You have created a new database in the first part of this tutorial, and you've chosen to create a table in Design View. Below is a portion of what you should have on your screen. It's a view we call ...

File-based databases have been around since the dawn of computing. We’ve always needed to have a way of storing records of the same kind of information. In the PC world, we ended up with very popular ...