JSON is just JSON, any system that parses JSON can parse JSON, be that SQL Server, powershell or any other tool you might be using.

JSON has the fundamental problem of...

JSON or XML are supposed to be versatile(unlike older mainframe type hierarchies) and capable of being transmitted and consumed by a broad range of systems. Where as relational databases are...

The issue isn't so much that SQL server can't parse and format json it's that the data is represented in fundamentally different ways.

In which case why bother with JSON? Isn't...

I could have a container running PostGres, another running Python 3.7 with a bunch of libraries, Python 3.9 with a different set of libraries and versions of those libraries, a...

It would be very helpful to have a clear definition of what the term "container" means.

What is the difference between a container and a virtual machine?

I was persuaded to enter...

The proponents I've seen for low code/no code encourages allowing the "citizen developer" to write low code/no code applications. They are the domain experts. They understand the problem. Under normal...

Some thoughts on the subject.

Axiomatic reuse. Software methods that apply to all possible applications. The relational model replaced every application needing to devise its own approach to data management.

Application derivation....

Chris Date - An Introduction to Database Systems - 8th Edition  - Chapter 21 Distributed Databases.

Published in 2004, but everything Date has to say about distributed DBMSs is just as...

What would I like to see in SQL Server in the future?

1. Assertions (in the SQL standard since SQL-92. Until now no one has implement them - I hear Oracle...

In the relational model all data is represented as attributes, within tuples within relations (columns, rows and tables in SQL speak). This means that all data manipulation can be achieved...

Or using powershell and regex

([regex]"(?im)--.*?$").replace(([regex]"(?s)\/\*.*?\*\/").replace($sql, ""), "")

The brand new go to technology in the NoSQL arena is TrumpDB.

The  same query in TrumpDB will always deliver a different answer.

TrumpDB is super...

A good article Steve, thank you.

There is one sentence that I would like to comment on.

The data is the more important asset we work with and all our efforts...

In my experience the "just want to hear how everyone is doing" meeting can often turn into the manager talking for the full hour with nobody else getting a word...

For managers the best kind of meeting is the meta-meeting. A meeting in which you do nothing other than discuss other meetings.