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

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

Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables. In an earlier tip, I showed a way to ...

Junk dimensions are often misunderstood and avoided. And they should not be. Junk dimensions offer a strategy to remain true to dimensional intentions and to better focus one's design and sometimes ...

The information below serves as a brief primer to help you better understand the database terms you’ll most often encounter. Relational Databases. Relational databases became the database of choice ...

Online analytical processing (OLAP) databases are purpose-built for handling analytical queries. Analytical queries run on online transaction-processing (OLTP) databases often take a long time to ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Extensible Markup Language (XML) has evolved considerably in its short five-year history. It started out as a simple way to mark up data and relied on seasoned technologies for data validation, such ...

In addition to needing an operating system, some embedded systems will need a structure for organizing data. In this article I discuss various ways of storing and retrieving data. Where appropriate, I ...