Intermediate SQL Tutorials

Working with JSON in an RDBMS – Part 1, MS SQL Server

Working with JSON in an RDBMS – Part 1, MS SQL Server

I have to begin by admitting that I'm no expert with NoSQL databases. I understand them conceptually and have worked hands-on with MongoDB and AWS DynamoDB in some learning and exploratory environments. But I have yet to build anything substantial...
Working with JSON in an RDBMS – Part 2, PostgreSQL

Working with JSON in an RDBMS – Part 2, PostgreSQL

In the first installment in this series, I covered working with JSON documents in a SQL database using Microsoft SQL Server. As we saw, there are a number of functions that Microsoft has added to their database platform to allow you to store a...
%d bloggers like this: