SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

If you want to know what’s what in Big Data analytics today, you’ve got to know the basics of NoSQL databases, and how appropriate NoSQL databases facilitate Big Data analytics. What are the most ...

If you own a version of Microsoft Office that includes Access (Office Professional 2010 is the most current version), but you’ve never used it, you’re overlooking a powerful tool for organizing and ...

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

NoSQL keeps rising, but relational databases still dominate big data Your email has been sent NoSQL promised to upend the database market as big data forced a sea change in how we think about and ...

The development of database technology is one of the defining achievements of the information technology era. It not only has been the key to dramatically improved record-keeping and business process ...

The data explosion demands new solutions, yet the hoary old RDBMS still rules. Here's where you really shouldn't use it I am a NoSQLer and a big data guy. That’s a nice coincidence, because as you may ...